Provider error '80004005'  in ASP

Posted on 2007-04-10
Medium Priority
Last Modified: 2012-05-05
I have an ASP page on my site, where users loggin to take a test. It recently stopped working and now I get an error.

Provider error '80004005'

Unspecified error

/clubs/AntiTobacco/includes/test_connect.asp, line 24

Here are lines 24 & 25 from test_connect.asp

 24 Set test_connector = Server.CreateObject("ADODB.Connection")
 25 test_connector.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath "./database/test.mdb")
Question by:dansagg
1 Comment

Accepted Solution

Dirar Abu Kteish earned 2000 total points
ID: 18882040
I googled and found this:

connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="
connStr = cst & Server.MapPath("./database/test.mdb")
set test_connector = CreateObject("ADODB.Connection")
test_connector.mode = 3 ' adModeReadWrite
test_connector.open cst

this may be caused by the mode in which Access is opened. Unless otherwise specified, IIS opens Access databases with adModeUnknown... which has proven to cause random problems in certain configurations. You can overcome this by setting the mode to adModeReadWrite *before* opening the connection, such as:




Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:   The Exchange of informatio…
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…
The video will let you know the exact process to import OST/PST files to the cloud based Office 365 mailboxes. Using Kernel Import PST to Office 365 tool, one can quickly import numerous OST/PST files to Office 365. Besides this, the tool also comes…
If you are looking for an automated tool which can generate reports for Outlook emails and other items from PST file, then you can go for Kernel PST Reporter tool. The reports which are created by this tool are helpful to analyze and understand PST …

623 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