Solved

Connect Remote Database of Ms Access

Posted on 2006-06-12
4
365 Views
Last Modified: 2008-02-01
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.Connection")
Connection2.open "Provider=MS Remote;" &_  
"Remote Server=http://www.bhe.com.pk;" &_
"Remote Provider=Microsoft.Jet.OLEDB.4.0;" &_
"Data Source=C:\Inetpub\vhosts\bhe.com.pk\httpdocs\Database\MediForm.mdb;UID=bhe.com.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


0
Comment
Question by:Rajaam
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 20

Accepted Solution

by:
Gawai earned 125 total points
ID: 16883922
0
 
LVL 20

Expert Comment

by:Gawai
ID: 16883929
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.

691 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question