Hi. I have written an intranet application in ASP connection to an Access
database. The application works fine and has been installed at several
locations. At one location, however, there is a problem.
The ASP pages seem to loose their connection to the database after a while
(usually half a day). All pages return an "unspecified error" upon
connection to the database:
cnStr = "DBQ=" & Server.MapPath("/db/wbdat.mdb") & ";Driver={Microsoft
Access Driver (*.mdb)};DriverId=25;FIL=MS Access;" Set cn =
Server.CreateObject("ADODB.Connection")
cn.Open cnStr ' The error occurs in this line
After the error occurs no one can access the database. To fix the problem
the server (Windows 200 server) has to be either restarted or the IIS Admin
Service must be stopped and started.
It seems that the error doesn't have anything to do with the number of
users connected, since we have rapports of one single user working with the
application from his Mac and making the application loose its connection to
the database. It seems that there is something in the server that gets
"overflowed".
If anyone has had similar problems or have a solution or some good advice,
it would be greatly appreciated!!!
-Lars
PS. I know one should probably be using a SQL server, but this is not
possible in this case.