Bob - Right, I use GetRows to grab the information, then close things out. If one normally looped through the records, but placed the beginning of their loop before the connection, then that would cause a problem.
Cheers - george --- In [EMAIL PROTECTED], "BobFilipiak" <[EMAIL PROTECTED]> wrote: > It is not the looping through the records I was talking about. I meant > having a loop that keeps opening the connection to the database. I use .Net > and SQL and my sub routines open the connect to database and retrieve > whatever data I need and then close the connection before I do anything with > the records. Some folks have a habit of opening the connection getting data > and then calling another routine based on the data retrieved leaving the > connection open. > > Bob Filipiak > A question not asked > is a lost opportunity to learn. > ----- Original Message ----- > From: "GLSmyth" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, May 14, 2004 10:11 AM > Subject: Re: [ASP] Can I Crash A Server > > > > Bob - > > > > We use SQL Server, but I assume that that would be the same thing. I > > was thinking of that - looping connections without closing them - and > > am actually in the process of seeing if there are any programs where I > > forgot to close the connection (none found yet). That would involve > > some backwards code (you normally open the connection, then loop > > through the records) but I guess that is something that could cause > > problems. > > > > Thanks - > > > > george > > ------------------------ Yahoo! Groups Sponsor ---------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM ---------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
