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

Last Reply on Apr 23, 2013 01:36 AM By Mudassar

Posted on Apr 23, 2013 01:34 AM

Hi,

 

        I tried to insert 3 xml files into database.But while i am trying to insert half of the value gets inserted after that i am getting error like

"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 Help me to how to resolve this error

Posted on Apr 23, 2013 01:36 AM

This is because the Open connections have reached the maximum limit. And this happened because you are not closing the database connection after operation is completed

 

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html