I have an intermittent error which appears on an IIS 6 Server running Windows 2003 R2 SP2. This is running an ASP application which receives fairly high usage. The error displayed to the client is:
Active Server Pages error 'ASP 0241'
The CreatObject of '(null)' caused exception C000005.
The object call which fails is the 'Server.CreateObject("ADOD
t"). The error is always limited to the current user's session (no other user is affected at that moment) and restarting the web browser and reaccessing the page (creating a new session) will make the error disappear and the page works fine.
I have performed a large-scale cleanup of all code to ensure that there are no recordsets or connections which have not been closed. I also find that after this error has been reported, when logging into the server via remote desktop, I find immediately an error indicating "IIS Worker Process encountered an error and had to restart". Also, the event log contains the following error at a similar time:
Faulting application w3wp.exe, version 6.0.3790.3959, faulting module unknown, version 0.0.0.0, fault address 0x00390038.
Other information if relevant:
Application runs with its own process pooll. Worker processes are configured to recycle twice per day outside of production hours as opposed to a specified number of minutes or requests. Only 1 worker process in the web garden.
The below code is a simplified version of the code that is used when the error occurs:
' Presume that the connection, "myConn" has already been declared and successfully created.
myRS = Server.CreateObject("ADODB.Recordset")
myRS.Open "mySQLStoredProcedure @param1 = 'hello', @param2 = 'world'", myConn