Click here to Skip to main content
15,667,540 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Dear all,

I am facing a problem.

I published a web application on windows server 2003, but when a user logs in 3-4 times it disconnects with database and shows a message that it has reached max pool size.

I am using Microsoft.Practices.EnterpriseLibrary.Data.Sql.
What is solution>

Please Help Me.

Thanks and regards
Updated 14-Jan-11 0:20am
Dalek Dave 14-Jan-11 6:20am    
Edited for Grammar and Readability.

Do you call the Dispose method after closing the connection?

Also, try to add this to your web.config:

<httpRuntime executionTimeout="300"/>

Good luck!

This link might help you out:[^][^]
Share this answer
Raghvendra Kumar Roy 14-Jan-11 4:37am    
thanks Dear
as I say I am using Microsoft.Practices.EnterpriseLibrary.Data.Sql. so there is no option of closing database connection. Problem is here but after 3-4 execution it gives time out expired. But if I published on another computer then it runs fine. Now I want to know that is this because of IIS?
E.F. Nijboer 14-Jan-11 5:02am    
I added some links that hopefully can help you out.
Dalek Dave 14-Jan-11 6:20am    
Good Answer.
Do add this to your connection string, I had also the same problem.

Min Pool Size=5; Max Pool Size=500;

Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900