dbTalk Databases Forums  

Failing to connect to Oracle Server in ASP Session_OnEnd

comp.databases.oracle comp.databases.oracle


Discuss Failing to connect to Oracle Server in ASP Session_OnEnd in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Agoston Bejo
 
Posts: n/a

Default Failing to connect to Oracle Server in ASP Session_OnEnd - 09-27-2004 , 02:49 AM






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



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.