ASP 'Catastropic Failure' error on Conn.open
362437May 26 2004 — edited Jun 16 2005We have an IIS/ASP multiuser web based application that uses Oracle Provider for OLE DB 9.2.0.1.0 and MDAC 2.71. One of our clients is having intermittent (1/2x day)trouble with their production server, intermittently receiving ONE of the following error messages on a random Connection.Open within the application:
--
ADODB.Command error '800a0e7d'
Requested operation requires an OLE DB Session object, which is not supported by the current provider.
--
Provider error '8000ffff'
Catastrophic failure
--
Active Server Pages error 'ASP 0115'
Unexpected error
A trappable error (C0000005) occurred in an external object. The script cannot continue running.
--
Regardless of the error message, the DLLHOST process refuses any further .open methods and we need to kill and restart in order to once again allow use of the application. We are very careful to close down all command and connection objects immediately after each query is run.
Code snippet is below. Thanks in advance for any guidance. --Rich
Set adoConn = Server.CreateObject("ADODB.Connection")
adoConn.Provider = "OraOLEDB.Oracle"
adoConn.Properties("Data Source").Value = ServerName
adoConn.Properties("User ID").Value = UserName
adoConn.Properties("Password").Value = Password
adoConn.Open *****crashes on this line