Site Search:
Sign in | Join | Help

This Blog

Syndication

ASP.NET

Notes, Tricks and Tips on ASP.NET Coding

Connection Pooling with the Microsoft Data Access Application Block

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

 I've been using the DAAB for some time with no issues at all, until today. I had a customer go live and within a few hours I had the above error.

 I fixed it by editing my connection string to explicitly specify connecion pooling, that fixed it.

   <add name="PHSB" connectionString="Pooling=yes;Max Pool Size=100;Min Pool Size=5;server=HS-GODZILLA;database=PHSB;Integrated Security=true" providerName="System.Data.SqlClient"/>

 

Comments

No Comments

About Steve Gray

Steve is a seasoned (translate: old) developer in VB and ASP.NET. He spends most of his time in Dynamics GP, writing custom mods for consulting firms. Crystal reports, eConnect, VS Tools for Dynamics... anything that comes along.