ASP - the timeout period elapsed prior to obtaining a connection from the pool

Question

I'm having Trouble with the following 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."

It seems that the error is in the following code block:

da = new SqlDataAdapter(command);
command.CommandTimeout = 100;
da.Fill(dt);
conn.Close();
return dt;

Probably should wrap the command and the connection in a using statement. That could help with your connections leaking. — Kevin Up

jonaglon jonaglon · Accepted Answer · 2016-07-06T10:16:05

It's hard to say with such a small amount of code in your question but this error can occur when you're not disposing of your db connection objects properly. The "using" statement may help you out of this problem. There is a SO issue with the same error message and code examples here: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. which may help.

ASP - the timeout period elapsed prior to obtaining a connection from the pool

2 Answers