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
http://www.issociate.de/board/post/219385/ASP_and_DB_-_different_servers.html
http://www.ureader.com/message/859776.aspx