Connection Pool bug?

[Thomas]

Hello gurus!

I get some very weird error messages from my server after a few days of
uptime. The server is a collection of .NET remoting singlecall objects which
calls stored procedure in our SQL Server 2000. The error messages I receive
is as follow:

System.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.
at
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec
tionString options, Boolean& isInTransaction)
at System.Data.SqlClient.SqlConnection.Open()
at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String
connectionString, CommandType commandType, String commandText,
SqlParameter[] commandParameters) in C:\Program Files\Microsoft Application
Blocks for .NET\Data Access
v2\Code\CS\Microsoft.ApplicationBlocks.Data\SQLHelper.cs:line 881
at GP.Services.DB.ComputerDB.SayHello(...) in
e:\_projects\gp\server\gpservices\dbproxy\computerdb.cs:line xxx

If anyone has ran into this before and possibly could point me in the right
direction for solving this issue, I would be very grateful. It sure looks
lika som connectionpooling issues, and as you can see I tried with the Data
ApplicationBlock from microsoft but no difference. I close all my
connections in a finally block. Thanks in advance

// Thomas Örnmarker
Gamers Paradise

 

[William \(Bill\) Vaughn]

I would search the archives of this list (google groups) for a discussion of
connection pools. I have commented any number of times on this issue. You
might also benefit from my whitepaper on the connection pool (see
www.betav.com\articles.htm)
If you still can't get this resolved, come back here and I'll explain what's
happening. I suspect that you ARE leaking connections or your system is
getting overloaded...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
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.
__________________________________