Just recently when the web services or the server is restarted, IIS
often goes into a state where 1 in 5 page requests result in a
0x800A01FB error on the line where I'm opening the connection
"conn.open". If it hit refresh the page sometimes works, it sometimes
comes up with this - its random.
This problem now happens on a daily basis as I close the web+sql
services when backing up, then start them when finished and it goes
into this state.
The only solution is to manually restart the web services again which
I use IISRESET /RESTART to do. I have no clue why this is happening.
All code in the pages is correct and connections / objects are closed
and set to nothing correctly. Anyone know whats wrong?
I'm using SQL Server 2000 SP4, ODBC connections, MDAC 2.8 installed,
on Win2000 Server SP4, IIS 5.