Connection Pool Issue

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Guadala Harry (ChipsNSalsa_at_gh.com)
Date: 06/11/04 

Date: Fri, 11 Jun 2004 10:37:22 -0700

I have an ASP.NET/C# app that connects to SQL Server 2000. I recently
started getting the following error message during development (i.e., when
launching the app from the VS.NET 2003 IDE):

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 found that closing and re-opening VS.NET clears things up. What's
going on? What can I do to prevent this? Am I doing something bad? I thought
the connection pool manages itself and recycles connections as necessary.

Thanks,

GH

Relevant Pages

  • Re: Connection pooling
    ... Each message spawns a new instance of a C# dll via COM. ... | I have only tested the dll's being created via a Console app, ... | use that pool. ... transaction, you close the connection. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: ADO Connection.Execute Method leaves Open SQL Process
    ... Have the App create a single ADODB.Connection object, ... requesting only one connection from a single ADO Connection ... Pool, thus if all requests are sequenced and not over-lapping ...
    (microsoft.public.vb.database.ado)
  • Re: Internal connection fatal error
    ... It's just the nature of the app... ... > 80 connections in the pool tells me this is a heavily loaded system. ... > Yes, if an operation fails at the server, the connection can be broken. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: too many cursors open
    ... Is the app java? ... This usually means you are not closing callable statements and result ... instrument it and instrument where you get the connection from the pool ...
    (comp.databases.oracle.misc)
  • Re: Close and Dispose argument
    ... > fact that even Microsoft is not clear on the issue. ... > connections from the pool is still a debate. ... > method removes the conneciton from the connection pool". ... > Your issue was forwarded to us here at Microsoft Courseware Support. ...
    (microsoft.public.dotnet.framework.adonet)