Rajaam
asked on
Connect Remote Database of Ms Access
I have developed an intranet application in ASP 3.0 technology. The objective of this application is to fetch the data from remote/online database of Ms Access. But when I try to connect it with remote/online database it gives me following error that comes due to IIS Configuration and Authentication problems.
Error:
[Microsoft ADO/RDS (0x800A2011)
- Internet Server Error: Object/module not found
- /Medisoft/GetDataPost.asp, line 7 ]
I am using the following connection string to connect the database.
Set Connection2 = CreateObject("ADODB.Connec tion")
Connection2.open "Provider=MS Remote;" &_
"Remote Server=http://www.bhe.com.pk;" &_
"Remote Provider=Microsoft.Jet.OLE DB.4.0;" &_
"Data Source=C:\Inetpub\vhosts\b he.com.pk\ httpdocs\D atabase\Me diForm.mdb ;UID=bhe.c om.pk;PWD= zmakqo10;"
Please send me proper solution to solve this error. I am waiting for immediate and positive response.
Best Regards
Rizwan Ahmed
Email: rizwanbox@hotmail.com
Error:
[Microsoft ADO/RDS (0x800A2011)
- Internet Server Error: Object/module not found
- /Medisoft/GetDataPost.asp,
I am using the following connection string to connect the database.
Set Connection2 = CreateObject("ADODB.Connec
Connection2.open "Provider=MS Remote;" &_
"Remote Server=http://www.bhe.com.pk;" &_
"Remote Provider=Microsoft.Jet.OLE
"Data Source=C:\Inetpub\vhosts\b
Please send me proper solution to solve this error. I am waiting for immediate and positive response.
Best Regards
Rizwan Ahmed
Email: rizwanbox@hotmail.com
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://www.aspfaq.com/show.asp?id=2168