Time Out Problem Of Sqlcoonnection Pool

Question

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

Khan Abrar Ahmed · Answer

Add the connection timeout in your connection string or add the timeout when you are creating the connection object. Connect Timeout=1000

Karthikeyan K · Answer

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 Mohapatra · Answer

1. 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 Menoth · Answer

Hi //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/

Ravi Kumar · Answer

hi your running application from IIS right then there go to advanced setting and give the physical crydentials