Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Failing to connect to Oracle Server in ASP Session_OnEnd

Failing to connect to Oracle Server in ASP Session_OnEnd

From: Agoston Bejo <gusz1_at_freemail.hu>
Date: Mon, 27 Sep 2004 09:49:41 +0200
Message-ID: <cj8gtq$jd1$1@news.caesar.elte.hu>


In ASP I am using a connection string that works everywhere in the application, except in Sub Session_OnEnd. There I get the following error message:

"Requested operation requires an OLE DB Session object, which is not
supported by the current provider."

The connection string is:
"Provider=OraOLEDB.Oracle.1;Data Source=[servername];User
ID=[user];Password=[password];Persist Security Info=True;PLSQLRSet=1;"

The parameters in [] are not quoted here, but they contain valid parameters.

The code is quite simple:

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection") Conn.ConnectionString = Application("Connection_String")

    'this connection string works everywhere but here Conn.Open 'ERROR HERE
....

What may cause this, and how to get around this? It is crucial for me to be able to perform some cleanup tasks once a session ends.

Thx Received on Mon Sep 27 2004 - 02:49:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US