Timeout expired

[Stefan Landgraf]

Hi there,

since installing Windows XP Pro SP2 on my machine i get an error

InvalidOperationException: 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

from time to time ~ 1 out of 5 requests. The application worked perfectly fine under XP Pro SP1.
It is an ASP.NET application using Framework 1.1 and a SQL Server running on a remote machine
in the LAN.

This is driving me nuts, does anyone have a hint?

Stefan

 

[Kevin Spencer]

Are you closing/disposing your connections?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[Stefan Landgraf]

Kevin,
yes I am. The activity log in SQL Server Enterprise Manager doesn't show any open connections.
The application worked perfectly fine before installing SP 2, so the reason can only be SP 2.

Stefan