I am connecting to an Access 2000 database from an ASP page.

I am using ADO.

At times, I get the following message:

Error Type:
Provider (0x80004005)
Unspecified error
/issm/arts/DBConn.inc, line 17

my DBConn.inc file:
  Set objConn = Server.CreateObject("ADODB.Connection")

  strDBPath =  Server.MapPath("db3.mdb")
  strSource="Driver={Microsoft Access Driver (*.mdb)}"
  strSource=strSource & "; DBQ=" & strDBPath & ";"
  objConn.ConnectionString = strSource
  objConn.ConnectionTimeout = 10

  objConn.open
  if err.Number<>0 then
    Response.write "<br> ERROR ON Connection Opening<br>"
    Response.write "<br> err Number: " & err.Number & "<br>"
    Response.write "<br> err Description: " & err.Description & "<br>"
    Response.write "<br> err SQL State: " & err.SQLState & "<br>"
    Response.write "<br> err Source: " & err.Source & "<br>"
    Response.end
  end if

line 17 is "objConn.open"

The error does NOT occur all the time.

The user will be in the system working fine and then at any
given moment, the error occurs. Then after minutes pass, the
error seems to clear up and the user can continue working.

Anyone have any suggestions or a solution?

Try this for you ConnectionString;

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=databaseName"

(If you need to add a user account, append the following:
  ";User ID=userName;Password=userPassword"

I've never gotten the provider you're using to work *at all*!

Skip