?
Solved

Provider error '80004005'  in ASP

Posted on 2007-04-10
1
Medium Priority
?
499 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
[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
1 Comment
 
LVL 6

Accepted Solution

by:
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:

"

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

-dirar
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

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…
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…
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.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

764 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