Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.

Question

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.

whenever i load my project on explorer sometime i meet with an error. can any1 help me to solve this time out error

Don't forget to close your connections. – L.B Aug 14 '12 at 16:43 — L.B, Aug 14 '12 at 16:43

score 2 · Answer 1 · answered Aug 14 '12 at 16:54

2

This usually happens when connections are not closed after they are used. Are you using a DataReader? If so make sure it is closed.

answered Aug 14 '12 at 16:54

LOZ

1,169
2
16
43

yes m using datareader bt after they are used i closed the connection. – Vinay Arora Aug 14 '12 at 20:00
What is your connect_timeout number? – LOZ Aug 14 '12 at 20:29
i had set connection timeout=200 and pool size=100 – Vinay Arora Aug 18 '12 at 06:21
now i had dispose all the command, reader, adapter, connection. – Vinay Arora Aug 18 '12 at 06:21
Future readers: Be sure to see [What are the uses of "using" in C#](https://stackoverflow.com/questions/75401/what-are-the-uses-of-using-in-c) – John Saunders Aug 28 '20 at 21:02

score 1 · Answer 2 · answered Oct 30 '17 at 13:00

This exception can also arise when same SQL query string is run over and over again several times e.g. inside a loop.

For a work-around try modifying connection string that is used in web service with the attributes like Connect Timeout , Max Pool Size.

"Integrated Security=True;Server=ServerName;Initial Catalog=DatabaseName;Connect Timeout=20000; pooling='true'; Max Pool Size=20000"

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool.

2 Answers2