1 2 Previous Next 15 Replies Latest reply on Jun 16, 2005 9:27 PM by 362437

    ASP 'Catastropic Failure' error on Conn.open

      We have an IIS/ASP multiuser web based application that uses Oracle Provider for OLE DB 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
        1 2 Previous Next