"William Vaughn" wrote:

> This question has been asked and answered a thousand times so there are lots
> of other sources to draw upon.
> I also answered it so often I wrote a whitepaper on the subject and included
> it in my book. See
> http://betav.com/blog/billva/2007/05/managing_and_monitoring_net_co.html
>
> --
> ____________________________________
> William (Bill) Vaughn
> Author, Mentor, Consultant, Dad, Grandpa
> Microsoft MVP
> INETA Speaker
> www.betav.com
> www.betav.com/blog/billva
> Please reply only to the newsgroup so that others can benefit.
> This posting is provided "AS IS" with no warranties, and confers no rights.
> __________________________________
> Visit www.hitchhikerguides.net to get more information on my latest book:
> Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
> and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
> -----------------------------------------------------------------------------------------------------------------------
>
> "ads" <ads@discussions.microsoft.com> wrote in message
> news:65247081-B0BD-476E-B717-DF5F2BC02BA3@microsoft.com...
> > im experiencing connection timeout in SQLSERVER2000 when using my web
> > application. It seems the database connection pool has been reached. Im
> > using
> > microsoft application block sqlhelper to connect to the database. A
> > temporary
> > solution is to increase the connection timeout and/or increase the
> > database
> > pool but i want to understand the root of the problem. This problem maybe
> > due
> > to many sql connection not being closed in the web app or there is an
> > error
> > in the sql query.
> >
> > Is it true that sqlhelper.executereader doesnt close sql connection?
> >
> > What about sqlhelper.executescalar ,executenonquery,executedataset?
> >
> > Whenever i insert this code: SqlConnection conn = new
> > SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connectionString"])
> > to pages which need to connect to database, does this add a connection to
> > the
> > database pool whenever the page load is executed?
> >
> > i want to keep sql connection object minimum as possible so the database
> > pool will not be reached.
> >
> > Please point me to the right direction.
> >
> > Thanks,
> > Ads
> >