Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ASP 'Catastropic Failure' error on Conn.open

362437May 26 2004 — edited Jun 16 2005
We 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

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 14 2005
Added on May 26 2004
15 comments
8,969 views