http://www.learnasp.com/learn/dbpooling.asp has great info on this and links
--- In [EMAIL PROTECTED], "Rajendra Appalla" <[EMAIL PROTECTED]> wrote: > After closing the connection, it gets added to connection pool. If you > do not want the closed connection to be pooled, then dispose the > connection immediately after you close it. > > sqlConn.Dispose(); > would do it. > > Raj. > > -----Original Message----- > From: Mechzen [mailto:[EMAIL PROTECTED] > Sent: Tuesday, July 13, 2004 4:01 AM > To: ASP.NET > Subject: [AspNetAnyQuestionIsOk] database connection .. pls help > > Hi all, > When V connect 2 database we use the connectionstring > and do it also V always create the connection/command object and then > work with it and free it...immediately...rt?? 'cos ours(.NET) is > disconnectecd a rchitecture.... > But, the problem is since V make soo much dynamic connection > and free it..they R not getting actually freed...i.e THey R maintained > in a POOL which is getting accumulated...That is a problem/.... > Can U tell how is database connection done there???? It will be > very helpful...waiting... ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/ <*> 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/
