Re: ADO Connection object in Session_OnEnd

From: Bob Barrows [MVP] (reb01501_at_NOyahoo.SPAMcom)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 10:04:04 -0400

You can try disableing session pooling for this connection by adding

OLE DB Services=-2

to your connection string in this sub.

Bob Barrows

Agoston Bejo wrote:
> "Provider=OraOLEDB.Oracle.1;Data Source=***;User
> ID=***;Password=***;Persist Security Info=True;PLSQLRSet=1;"
>
> Sorry, but I don't think I should provide the information that I've
> replaced with ***.
> I'm connecting to an Oracle 8.1.7 server.
> Anyway, believe me that it works this way outside Session_OnEnd,
> since I copied
> it from Session_OnStart.
>
> Many thanks
>
> "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
> news:%23Z6BvsjoEHA.1800@TK2MSFTNGP15.phx.gbl...
>> And what is the value of Application("Connection_String") ?
>>
>> --
>> http://www.aspfaq.com/
>> (Reverse address to reply.)
>>
>>
>>
>>
>> "Agoston Bejo" <gusz1@freemail.hu> wrote in message
>> news:unDoxqjoEHA.3392@TK2MSFTNGP15.phx.gbl...
>>> Yes, how silly of me, I forgot that little detail:
>>>
>>> Error message:
>>> "Requested operation requires an OLE DB Session object, which is not
>>> supported by the current provider."
>>>
>>>
>>> "Aaron [SQL Server MVP]" <ten.xoc@dnartreb.noraa> wrote in message
>>> news:eKA4jljoEHA.1576@TK2MSFTNGP12.phx.gbl...
>>>> It might help if you tell us WHAT error.
>>>>
>>>> --
>>>> http://www.aspfaq.com/
>>>> (Reverse address to reply.)
>>>>
>>>>
>>>>
>>>>
>>>> "Agoston Bejo" <gusz1@freemail.hu> wrote in message
>>>> news:OOX4xijoEHA.2764@TK2MSFTNGP11.phx.gbl...
>>>>> Hi!
>>>>> Why doesn't the following code work?
>>>>>
>>>>> Sub Session_OnEnd
>>>>> Dim Conn
>>>>> Set Conn = Server.CreateObject("ADODB.Connection")
>>>>> Conn.ConnectionString = Application("Connection_String")
>>>>> Conn.Open 'here is the error
>>>>> ...
>>>>> End Sub
>>>>>
>>>>>
>>>>> A Conn object is created the same way in Session_OnStart and is
>>>>> used throughout the application, and
>>>>> Application("Connection_String") still exists here (I tested).
>>>>> So I suppose the error is caused by the fact that we are in
>>>>> Session_OnEnd. 

-- 
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

Relevant Pages

  • Re: Indexing of Connections
    ... connection open error and I need to know what connection it is ... Please reply to the newsgroup. ... This email account is my spam trap so I ...
    (microsoft.public.data.ado)
  • Re: insert Q
    ... Create a connection object ... > select top 1 from MSysobjects ... > dim lrecs, cn ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: insert Q
    ... > RS_Insert.ActiveConnection = strCon ... You don't want to turn off connection pooling, ... dim lrecs, cn ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: performance difference between DSN and DSN-less?
    ... > I know it doesn't change the connection issue, ... In order to provide maximum scalability, sql statements should be used ... In a non-Web environment, such as a desktop application, where throughput is ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • Re: ADO Connection object in Session_OnEnd
    ... You can try disableing session pooling for this connection by adding ... Bob Barrows ... Agoston Bejo wrote: ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)