Timeout expired. 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

Question

0.00/5 (No votes)

See more:

Win2003

.NET3.5

, +

We have deployed Asp.net Application in Windows 2003 R2 server 64 bit and IIS 6.0.

The user login this application after 10 min, he is getting below mentioned error.

"Timeout expired. 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."

In application side, We have increased connection pool Min size = 200 and Max size = 50000.

System side, we executed below script.

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1

Please suggest me to over come this issue.
thanks.

Posted 11-Jan-12 23:11pm

Mohanraj Selvarathinam

Updated 11-Jan-12 23:18pm

Rajesh Anuhya

v2

Add a Solution

Comments

bbirajdar 12-Jan-12 10:38am

Have you tried setting the timeout in IIS?

3 solutions

Add a Solution

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

dk.dk000 · Answer 1 · 2014-01-06T00:30:00

Add Max Pool Size in your connection string

ex:-
<add name="entityConnection" connectionstring="metadata=res://*/EntityDB.csdl|res://*/EntityDB.ssdl|res://*/EntityDB.msl;provider=System.Data.SqlClient;provider connection string="Data Source=ServerName;Initial Catalog=DB_Name;Persist Security Info=True;User ID=sa;Password=password;<b>Max Pool Size=500</b>; MultipleActiveResultSets=True"" providername="System.Data.EntityClient" />

NandaKumer · Answer 2 · 2012-01-12T18:56:00

Solution 2

check these blogs
http://forums.asp.net/t/903456.aspx/1[^]
http://www.codeguru.com/csharp/.net/net_asp/article.php/c19395[^]
--NDK

Posted 12-Jan-12 18:56pm

NandaKumer

sriman.ch · Answer 3 · 2012-01-12T15:46:00

Solution 1

Hi,

The error is due to the retrieval of data from database

Try setting the connectiontimeout property in your connection string

Also increase the time out in IIS

Fine tune your db queries

Hope this helps

Posted 12-Jan-12 15:46pm

sriman.ch

Comments

NandaKumer 13-Jan-12 1:27am

good one

Timeout expired. 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

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Timeout expired. 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

3 solutions

Solution 3

Solution 2

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us