database connection reached max pool

Question

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
Raghvendra

Posted 13-Jan-11 22:14pm

Raghvendra Kumar Roy

Updated 14-Jan-11 0:20am

Dalek Dave

v2

Add a Solution

Comments

Dalek Dave 14-Jan-11 6:20am

Edited for Grammar and Readability.

2 solutions

Add a Solution

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

E.F. Nijboer · Answer 1 · 2011-01-13T22:18:00

Solution 1

Do you call the Dispose method after closing the connection?

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

XML

<httpRuntime executionTimeout="300"/>

Good luck!

This link might help you out:
http://www.eggheadcafe.com/software/aspnet/31039592/timeout-expired--the-timeout-period-elapsed-prior-to-completion-of-the-operation-or-the-server-is-not-responding.aspx[^]

http://social.msdn.microsoft.com/Forums/en/adodotnetdataproviders/thread/c57c0432-c27b-45ab-81ca-b2df76c911ef[^]

Posted 13-Jan-11 22:18pm

E.F. Nijboer

Updated 13-Jan-11 23:01pm

v3

Comments

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.

Husain Ahmad Khalid · Answer 2 · 2011-01-14T17:49:00

Solution 2

Do add this to your connection string, I had also the same problem.

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

Thanks

Posted 14-Jan-11 17:49pm

Husain Ahmad Khalid

database connection reached max pool

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

database connection reached max pool

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us