i developed my app using Asp.net and it hosting iis.After running App i Click sub menu pages more than 20 times then i am geeting
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
please reply As soon As possible
Thanks in Advance .
regards
venkatesh
Arunava BhattacharjeePosted Sep 26, 2014, 6:59 AM
You can set Max Pool Size in your connection string. By default probably it supports 100 as I remember. But you don't have to worry about it. You need to close your connection in the finally block or you can use the using block to open your connection. That's enough.
Mark this as accepted answer if you are satisfied.
venkatesh vPosted Sep 26, 2014, 5:56 AM
Arunava BhattacharjeePosted Sep 26, 2014, 5:41 AM
You missed it somewhere for sure if you are not "using()"
venkatesh vPosted Sep 26, 2014, 5:07 AM
regards
venkatesh v
Ck NitinPosted Sep 26, 2014, 3:41 AM
using (SqlConnection connection = new SqlConnection(connectionString))
{
connection.Open();
command.ExecuteNonQuery();
}