Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Failing to connect to Oracle Server in ASP Session_OnEnd
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
![]() |
![]() |