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/
