I was using a Microsoft Access ODBC connection to serve an on-line database.
I decided to upgrade it to SQL 6.5 and I ma having some trouble. Sometimes
people get the pages fine but other times people either get a blank web page
or the error listed below:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'BatDB'.
header.asp, line 38
So it works, but it doesn't work. ggrrr. All I did to my ASP was change the
ODBC DSN souyrce to the source that pointed to the SQL server. The source
obviously works since sometimes you get the data... but something has got to
be wrong. Is the source being locked by 1 connection? so the 2nd connection
gets the error?
I'm really lost nhere. Its hard to troubleshoot when the problem only
occures once in a while.
Any help is greatly appreciated.