Connection Pool and Connection time out

[Guest]

Hi all,
i am using Sql Connection with SqlHelper class;
it is working fine with windows xp and MSDE; when i developed the
application and tried it with Sql server200+ windows 2003 it gives Error
message
"The timeout period elapsed prior to obtaining a connection from the pool.
This may have occurred because all pooled connections were in use and max
pool size was reached. "
i have given the MAX pool size =75
i have no clue to this problem , i want to know what is the possible
resoultions
with regards!
Anupam

 

[Miha Markic [MVP C#]]

Is it possible that you are not closing connections?

 

[William \(Bill\) Vaughn]

This has been discussed many (many) times on this list. I suggest searching
the archives (google groups) or my web site for an article I wrote on
handling the connection pool.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Sahil Malik [MVP C#]]

Bad conn. pooling architecture.

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________

 

[Skanda Subramanian]

Hello Anupam:

Ensure that no codepaths in the application are leaking connections.
You would have to explicitly call the conn.Close() method.
Reduce the 'Connection LifeTime' paramter in your connection string.
Also check the number of the connections that your application is
using, probable increasing the Max Pool Size may be the answer.

HTH!
Skanda