One of our clients is using the following ASP code to connect to the MS Access DB on IIS 5.
dsn = "dsn=mydb;uid=GOPUser;pwd="""";"
It works great for a couple of days. Then it dies on the open code. with the following error.
error '80004005' unspecified error
To fix the problem I comment out pwd=""""; part from the dsn string and it works again for a while. Until it dies again. I put the pwd part back and we are up and running again.
I did notice there are a bunch or ADODB.Recordset objects that get created but either not getting closed or not set to nothing. Would that eventually lead to connection failing to open?
Anyone has any suggestions?