Time Out Problem Of Sqlcoonnection PoolVPViral Patel11yAsked Sep 1, 2015, 6:25 AM937Visual Basic .NETThe 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
Khan Abrar Ahmed11y agoPosted Sep 1, 2015, 7:30 AM Add the connection timeout in your connection string or add the timeout when you are creating the connection object. Connect Timeout=1000
Karthikeyan K11y agoPosted Sep 1, 2015, 6:54 AM Hi sir, Refer the link sir it may solve your problem 1.http://www.codeproject.com/Questions/423588/The-timeout-period-elapsed-prior-to-obtaining-a-co If it is useful then accept my answer
Manas Mohapatra11y agoPosted Sep 1, 2015, 6:45 AM1. Increase Max Pool Size in connection string <connectionStrings> <add name="sqlConnectionString" connectionString="Data Source=mySQLServer;Initial Catalog=myDatabase;Integrated Security=True;Connection Timeout=15;Connection Lifetime=0;Min Pool Size=0;Max Pool Size=500;Pooling=true;" /> connectionStrings> 2. Make sure that you are closing/disposing Database connection object so that it will go to connection pool for next database call.
Rajeesh Menoth11y agoPosted Sep 1, 2015, 6:33 AMHi, //This may have occurred because all pooled connections were in use and max pool size was reached.Set in Max Pool Size=500 or above;Eg :<add name="DbCon" connectionString="Data Source=.;Initial Catalog=ShaShib;Integrated Security=True;pooling='true'; Max Pool Size=6000; "/> Ref : https://rajeeshmenoth.wordpress.com/2014/06/10/timeout-expired-and-the-timeout-period-elapsed-prior-to-obtaining-a-connection-from-the-pool/
RKRavi Kumar11y agoPosted Sep 1, 2015, 6:31 AM hi your running application from IIS right then there go to advanced setting and give the physical crydentials
Khan Abrar AhmedPosted Sep 1, 2015, 7:30 AM
Karthikeyan KPosted Sep 1, 2015, 6:54 AM
Manas MohapatraPosted Sep 1, 2015, 6:45 AM
Rajeesh MenothPosted Sep 1, 2015, 6:33 AM
//This may have occurred because all pooled connections were in use and max pool size was reached.
Set in Max Pool Size=500 or above;
Eg :
<add name="DbCon" connectionString="Data Source=.;Initial Catalog=ShaShib;Integrated Security=True;pooling='true'; Max Pool Size=6000; "/>
Ravi KumarPosted Sep 1, 2015, 6:31 AM