Re: ADO Connection object in Session_OnEnd

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

Date: Fri, 24 Sep 2004 15:25:23 +0200

"Roji. P. Thomas" <lazydragon@nowhere.com> wrote in message
news:e%23QppljoEHA.3428@TK2MSFTNGP11.phx.gbl...
> >A Conn object is created the same way in Session_OnStart and is used
> >throughout the application

>
> O, Boy thats a bad idea

Yeah, yeah, I think I know what you mean, but as far as I know, it's not
that bad idea if you close the connection at the end of every asp page and
reopen it at the beginning of them.

>
> --
> Roji. P. Thomas
> Net Asset Management
> https://www.netassetmanagement.com
>
>
> "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: Testosterone is anabolic or not?
    ... All i got were stupid remarks like "stick to your own KIND" Yeah, ... Turkish and Moroccon girls can be very pretty, but thats a nono. ... I had this African girlfriend 3 years ago. ... doesnt trust me near the presence of black women. ...
    (misc.fitness.weights)
  • Re: AVLV Photos need updating
    ... Yeah, go figure. ... What does Grammer, Indiana have to do with grammar and spelling? ... Racked up over 120 quarters with the SSA and thats ...
    (alt.vacation.las-vegas)
  • Re: UK faction: Kano?
    ... > yeah there has been a fair bit of that in Hampshire as well I think. ... > as I can be without being in London area. ... > really do some server side stuff like apache as well. ... i would like to learn .php though, thats looks useful. ...
    (rec.music.hip-hop)
  • Re: How the GOP Lost Its Way
    ... Yeah the two names are, by common consent and legally, considered to be the ... Thats what you get when you have one country with two official languages. ... Yeah still up and running. ... Check out the second picture down the page, yes folks, thats a ...
    (rec.knives)
  • Re: Couple of questions for the group.
    ... Yeah, I meant increase, got it arse about. ... The Dean Markleys maybe are less dense? ... thats all about we can say without some direct facts or ... but discernable differences in tension between different brands. ...
    (alt.guitar)