Solved

Connect Remote Database of Ms Access

Posted on 2006-06-12
4
361 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

Independent Software Vendors: 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

Suggested Solutions

Title # Comments Views Activity
Error viewing ASP page 12 179
Writing comments on <p></P> or paragraph 2 23
Want an individual results display div 8 49
Diff of the day 2 11
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…
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

730 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