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=OraOL EDB.Oracle.1;Da ta Source=[servername];User
ID=[user];Password=[password];Persist Security Info=True;PLSQL RSet=1;"
The parameters in [] are not quoted here, but they contain valid parameters.
The code is quite simple:
Dim Conn
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Connection String = Application("Co nnection_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
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=OraOL EDB.Oracle.1;Da ta Source=[servername];User
ID=[user];Password=[password];Persist Security Info=True;PLSQL RSet=1;"
The parameters in [] are not quoted here, but they contain valid parameters.
The code is quite simple:
Dim Conn
Set Conn = Server.CreateOb ject("ADODB.Con nection")
Conn.Connection String = Application("Co nnection_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