C
Catherine Jones
Respected sir/madam,
I have a problem in accessing the Microsoft Access Database located on
the remote system from my ASP Page. As and when users open my ASP page i
must able to pick up the latest records in their Access database located at
the fixed path (c:\data\data.mdb) known to me.
My Approach to the Problem is mentioned below:
------------------------------------------------------------------------
I have used the following code in my asp page :
<%
set dbcon=server.CreateObject("ADODB.Connection")
set dbrst=server.CreateObject("ADODB.Recordset")
dbcon.Open "Provider=MS Remote;Remote Server=" &
Request.ServerVariables("remote_addr") & ";Remote
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data\data.mdb;Uid=;pwd="
dbrst.Open "select * from d2ksetup where type='HL'",dbcon
Response.Write dbrst.Fields(2).Value
%>
I have done the configuration in IIS 5.1 as mentioned below:- (I am using
Windows XP OS)
1. I created a virtual directory named MSADC mapping to c:\Program
Files\Common Files\System\MDAC folder. The permissions of
this folder is set to Execute (Including Script)
2. In the IIS, i have opened the properties of the virtual directory and
configured the Authentication Methods as mentioned below:
a. Unchecked "Allow IIS to control Password" and entered a new
password
user name : IUSR_NA password: balaji
b. On the Users Machine (People who acess my asp page), Under
Computer Management added a user with the
same ID and Password as mentioned in( Point a)
3. I have double clicked on Handunsf.reg file located in c:\program
files\common files\system\MSADC and restarted the web server.
I have done the above configuration with the help of 251122 article posted
in Knowledge Base.
When i execute the ASP page in IE i am getting the following error message
Microsoft ADO/RDS (0x800A1004)
Business Object cannot be created.
Please send the solution in detail mentioning step by step.
I have a problem in accessing the Microsoft Access Database located on
the remote system from my ASP Page. As and when users open my ASP page i
must able to pick up the latest records in their Access database located at
the fixed path (c:\data\data.mdb) known to me.
My Approach to the Problem is mentioned below:
------------------------------------------------------------------------
I have used the following code in my asp page :
<%
set dbcon=server.CreateObject("ADODB.Connection")
set dbrst=server.CreateObject("ADODB.Recordset")
dbcon.Open "Provider=MS Remote;Remote Server=" &
Request.ServerVariables("remote_addr") & ";Remote
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\data\data.mdb;Uid=;pwd="
dbrst.Open "select * from d2ksetup where type='HL'",dbcon
Response.Write dbrst.Fields(2).Value
%>
I have done the configuration in IIS 5.1 as mentioned below:- (I am using
Windows XP OS)
1. I created a virtual directory named MSADC mapping to c:\Program
Files\Common Files\System\MDAC folder. The permissions of
this folder is set to Execute (Including Script)
2. In the IIS, i have opened the properties of the virtual directory and
configured the Authentication Methods as mentioned below:
a. Unchecked "Allow IIS to control Password" and entered a new
password
user name : IUSR_NA password: balaji
b. On the Users Machine (People who acess my asp page), Under
Computer Management added a user with the
same ID and Password as mentioned in( Point a)
3. I have double clicked on Handunsf.reg file located in c:\program
files\common files\system\MSADC and restarted the web server.
I have done the above configuration with the help of 251122 article posted
in Knowledge Base.
When i execute the ASP page in IE i am getting the following error message
Microsoft ADO/RDS (0x800A1004)
Business Object cannot be created.
Please send the solution in detail mentioning step by step.