We've been having some issues with one of our internal web servers. Actually, its an issue with the JET engine and the load we are asking it to handle, but since that's somewhat out of my hands I'm focusing on what I can do.
We've found that under peak load the JET engine locks up and any attempt to connect to an Access database throws an error adErrUnspecified - a.k.a the least helpful of all messages.
The only solution we've found so far is to re-boot the server. I've added some checks in the code to test for adErrUnspecified and redirect them to a generic error page if it occurs.
My question is this: is there is a way to either shut down and restart IIS (Don't know if that will be enough or not), or trigger a re-boot of the server if the error is detected? Since I'm 8 to 5 (well, theoretically), but there are staff that need the site 24/7, I want to avoid issues like last night where the site locked up and for 12 hours was unavailable.
Even if it is possible, I may not be able to implement it, but I'd like the option to be available.
Topic Locked
Posted - 21 May 2007 : 09:57:52
