Timeout expired connection

Ihave an application (.Net 1.1, wi2k3 SP1, SQL 2005) that works fine after
severalminutes of browsing then I start to get the following error :

Servor Error in '/myVirtualServer'
Timeout expired. The timeout period elapsed prior to obtaining a connection
from the pool. Thismay have occured because all pooled connections were in
use and max pool size was reached.

I have several connections opened/closed that use the same connection string

What might be the issue? Is there a parameter to fine tune the number of
connection allowed. Thanks

William
Sun Oct 01 20:54:00 CDT 2006

Take a look at my article on Drowning in the Connection Pool on my website.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
Between now and Nov. 6th 2006 you can sign up for a substantial discount.
Look for the "Early Bird" discount checkbox on the registration form...

"SalamElias" <eliassal@online.nospam> wrote in message
news:EF7E88CB-1CA6-4DA5-B14C-9C624F468862@microsoft.com...
> Ihave an application (.Net 1.1, wi2k3 SP1, SQL 2005) that works fine after
> severalminutes of browsing then I start to get the following error :
>
> Servor Error in '/myVirtualServer'
> Timeout expired. The timeout period elapsed prior to obtaining a
> connection
> from the pool. Thismay have occured because all pooled connections were in
> use and max pool size was reached.
>
> I have several connections opened/closed that use the same connection
> string
>
> What might be the issue? Is there a parameter to fine tune the number of
> connection allowed. Thanks

v-kevy
Sun Oct 01 23:45:30 CDT 2006

Hi Salam,

You can specify the maximum pool size in the connection string using Max
Pool Size = XXX. However, before setting the maximum pool size, I suggest
you try to check if you have closed each connection after using. You don't
need to dispose it. Calling Close on it will make it return to the pool.

Kevin Yu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

(This posting is provided "AS IS", with no warranties, and confers no
rights.)