Re: ADO Connection object in Session_OnEnd

From: Agoston Bejo (gusz1_at_freemail.hu)
Date: 09/24/04 

Date: Fri, 24 Sep 2004 15:37:35 +0200

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

Relevant Pages

  • Re: Slow connection to Oracle 9i
    ... If your server is memory and/or CPU ... I just tested it on two oracle instances on identical ... Connecting to one with MTS took 0.059 seconds, ... Other delays could be in finding the database and authenticating the ...
    (perl.dbi.users)
  • Catastrophic Failure (8000ffff)
    ... We have a Windows 2003 Server acting as a web server and connected using an ... ODBC to a Windows 2000 server with an Oracle DB. ... The ODBC connecting is using ...
    (microsoft.public.data.odbc)
  • ASP and Oracle 9i
    ... I have just started test our website against Oracle 9i ... problems connecting to the database. ... I thought maybe server not configured properly, ...
    (microsoft.public.inetserver.asp.db)
  • Re: ADO Connection object in Session_OnEnd
    ... I'm connecting to an Oracle 8.1.7 server. ... > (Reverse address to reply.) ...
    (microsoft.public.inetserver.asp.db)
  • Re: ADO Connection object in Session_OnEnd
    ... I'm connecting to an Oracle 8.1.7 server. ... > (Reverse address to reply.) ...
    (microsoft.public.inetserver.asp.general)