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

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

Solution 3

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" />
  Permalink  

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

  Print Answers RSS
0 George Jonsson 215
1 Kornfeld Eliyahu Peter 169
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342


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