Re: ADO Connection object in Session_OnEnd

From: Aaron [SQL Server MVP] (ten.xoc_at_dnartreb.noraa)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 09:32:50 -0400

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.
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: ADO Connection object in Session_OnEnd
    ... > "Requested operation requires an OLE DB Session object, ... >> (Reverse address to reply.) ... >>> Sub Session_OnEnd ... >>> Dim Conn ...
    (microsoft.public.scripting.vbscript)
  • Re: ADO Connection object in Session_OnEnd
    ... > "Requested operation requires an OLE DB Session object, ... >> (Reverse address to reply.) ... >>> Sub Session_OnEnd ... >>> Dim Conn ...
    (microsoft.public.inetserver.asp.db)
  • Re: ADO Connection object in Session_OnEnd
    ... > "Requested operation requires an OLE DB Session object, ... >> (Reverse address to reply.) ... >>> Sub Session_OnEnd ... >>> Dim Conn ...
    (microsoft.public.inetserver.asp.general)
  • Re: Can you help me to improve this macro?
    ... Public Sub ReverseDictionary() ... Dim rngOriginal As Excel.Range ... I have a sheet where column A contains terms. ... I need to reverse dictionary ...
    (microsoft.public.excel.programming)
  • RE: Loop statements
    ... Private Sub ProduceReport_Click ... Dim sMsg As String, sFilePath As String ... For Each vItem In Me.ADname.ItemsSelected ... If you want to select ALL 120 items in the list box, click the REVERSE button. ...
    (microsoft.public.access.modulesdaovba)