Connection Pool Problem

Question

Hi All Am facing a problem with SQL Connection.The Connection pool gets filled soon.Since the site is already liveno change can be done in code.Is there some solution which can be done in WEB.CONFIG file or the db[MS SQL Server 2005] that would help to solve the connection pool filling problem. Thank You Thomas

vijay kumar · Answer

increase the max pool size in config if there are more connections.......

Simon · Answer

Hello First make sure you close the connection as soon as you're done using it (consider using myConnection.Close() in the finally part of a try...finally block). Then there are some parameters which you can append to or modify in your connection string to control the connection pooling mechanism. You will find further information about how to solve your problem at this page : http://www.15seconds.com/Issue/040830.htm Simon