Constantly losing connection to Access via ODBC
Posted on 2008-06-24
I am the webmaster of Dauphin County, we created an access program a few years back that we enable the Personnel department to process, edit, add, delete job posting. I then connect to the access app thru an ODBC connection. simple.
but for some reason, it stopped working properly... almost on a nightly occurance now, the connection string will drop and the postings will display:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Cannot open database '(unknown)'. It may not be a database that your application recognizes, or the file may be corrupt.
/employment/fulltime.asp, line 76
I tried everything and it still seems as if the connection will just automatically drop. Each morning I come in, I immediatly open the server and reset WWW service and it fixes the issue, until it drops again.
is there anything suggestions on why this is happening?
(On dauphincounty.org, the postings are set in an IFRAME which is pulled from dauphinc.org and dauphinc.org is also the same server where the ODBC connection is.)