Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: Win2003 IIS6 .NET3.5 ASP.NET , +
We have deployed 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.
Posted 12-Jan-12 0:11am
Edited 12-Jan-12 0:18am
B Birajdar at 12-Jan-12 10:38am
Have you tried setting the timeout in IIS?
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

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
NandaKumer at 13-Jan-12 1:27am
good one
Rate this: bad
Please Sign up or sign in to vote.

Solution 3

Add Max Pool Size in your connection string
<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" />

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

Advertise | Privacy | Mobile
Web01 | 2.8.150302.1 | Last Updated 6 Jan 2014
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100