Provider error '80004005' Unspecified error

[TheCandyman]

Yes the un-helpful error. I have searched all over, but i can't see a simple problem-fix to this error. I am runing several ASP pages pulling info from a Access DB. I tried this on II6 and also on II5, same error on both systems. I also compact and repaired the DB just incase. But i can open it just fine, so it has to be something in the code that it can't handle.


Error
Provider error '80004005'
Unspecified error
/convention/exhibitor/lib/openconnection.asp, line 15


Code in openconnection.asp
<%
' pStr = "private, no-cache, must-revalidate"
' Response.ExpiresAbsolute = #2000-01-01#
Response.AddHeader "pragma", "no-cache"
' Response.AddHeader "cache-control", pStr
Response.AddHeader "cache-control", "private"'pStr
Response.CacheControl="Public"
' Response.CacheControl = "no-cache"
' Response.Expires = -1

Dim Conn,rs,rs1,rs2,rs3,rs4,strCon
strCon = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath ("Regdb/azreg.mdb")
Set Conn = CreateObject("ADODB.Connection")
Conn.mode = 3 ' adModeReadWrite
Conn.open strCon (Line 15)
Set rs = Server.CreateObject("ADODB.Recordset")
Set rs1 = Server.CreateObject("ADODB.Recordset")
Set rs2 = Server.CreateObject("ADODB.Recordset")
Set rs3 = Server.CreateObject("ADODB.Recordset")
Set rs4 = Server.CreateObject("ADODB.Recordset")
%>

 

[Sheco]

First thing to check is if IIS is configured to use Anonymous access... if it is, check to see that the account it is using has read/write privilages to the .mdb database file. The default account is IUSR_MachineName and it might have read only rights, or no rights at all.

 

[TheCandyman]

I forgot to post that, i added the ISRU_xxx and had it with read/write and it didn't work. i even gave it full control but no dice. The site does allow Anon access and i can see everything but those ASP pages

 

[DotNetGnat]

This error is usually related to incorrect permissions are set on the server.

-DNG

 

[DotNetGnat]

try this:

Open the .mdb in access. Go to Tools->Options->Advanced. Deselect the "Open databases using record-level locking" option. Press "OK" Close Access.

and restart your server...

-DNG

 

[TheCandyman]

Yes i know, but i cant see where i went wrong. Suggestions?

 

[TheCandyman]

Wow, taking that off worked on the IIS5 box, have to put it on the live IIS6 box and see if it still works... just seems such an easy fix DotNetGnat.

 

[DotNetGnat]

cool...glad that it worked for you...

-DNG

 

[Sheco]

Nice one DNG

 

[TheCandyman]

Spent 3 hours tring to get it to work on IIS6, finally took out the

...(*.mdb)};DBQ="&Server.MapPath ("Regdb/azreg.mdb")

and replaced with

...(*.mdb)};DBQ=C:/xxxxxxxxxxxxxxx/Regdb/azreg.mdb"

works like a charm!! Must be something with virtual paths..

 

[DotNetGnat]

glad to know that you could solve your issue finally

-DNG

 

[Sheco]

Thanks for posting your solution so that others that have this same problem will be able to get the answer using the Search feature.