Click here to Skip to main content
13,054,779 members (64,968 online)
Rate this:
Please Sign up or sign in to vote.
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 11-Jan-12 23:11pm
Updated 11-Jan-12 23:18pm
B Birajdar 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 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)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web01 | 2.8.170713.1 | Last Updated 6 Jan 2014
Copyright © CodeProject, 1999-2017
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