Re: ADO Connection object in Session_OnEnd

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

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

Agoston Bejo wrote:
> "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,

Maybe you do, but your next statement makes me doubt it.

> 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.
>
Then what's the point of opening it in Session_OnStart? Maybe you misspoke
in your earlier message. When you said " ... and is used throughout the
application", were you talking about the connection object (bad) or the
connection string (good)?

Bob Barrows 

-- 
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: ADO Connection object in Session_OnEnd
    ... Boy thats a bad idea ... > Yeah, yeah, I think I know what you mean, ... > not that bad idea if you close the connection at the end of every asp ... This email account is my spam trap so I ...
    (microsoft.public.scripting.vbscript)
  • Re: ADO Connection object in Session_OnEnd
    ... Boy thats a bad idea ... > Yeah, yeah, I think I know what you mean, ... > not that bad idea if you close the connection at the end of every asp ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.db)
  • Re: ADO Connection object in Session_OnEnd
    ... Boy thats a bad idea ... > Yeah, yeah, I think I know what you mean, ... > not that bad idea if you close the connection at the end of every asp ... This email account is my spam trap so I ...
    (microsoft.public.inetserver.asp.general)
  • 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: WMP9 for PPC2003 video viewing problem
    ... Yeah, I tried it prior to even syncing it the first time. ... for the cradle connection (Dell TM1200 WLAN Module, ...
    (microsoft.public.pocketpc.multimedia)