Hi All!
I’m looking for some help with an intermittent VBScript problem I’m having when trying to talk to Access databases.
I often get the following error when going to pages, or reloading current sites.
Error Type:
Provider (0x80004005)Unspecified error
/workorders/userview.asp, line 17
Line 17 is the line with the *****
DBName = Server.MapPath(“workorders.mdb”)
Set myConn = Server.CreateObject(“ADODB.Connection”)
*****myConn.Open “DBQ=” & DBName & “;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;”
Set myRS = Server.CreateObject(“ADODB.Recordset”)
As I said, the problem seems to be very sporadic. At times, it will work fine, other times I will have to reload each page several times to getthe error to go away.
If more source from the file is necessary, please let me know. Thanks for the help.
-S