Solved

Provider error '80004005'  in ASP

Posted on 2007-04-10
1
482 Views
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")
0
Comment
Question by:dansagg
1 Comment
 
LVL 6

Accepted Solution

by:
dxz2 earned 500 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:

"

http://access.databases.aspfaq.com/why-does-access-give-me-unspecified-error-messages.html

-dirar
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

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…
I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

920 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now