Re: How to clear connection pool?

Srinivas:

I can see where some people would *think* you are losing connections, but
from your description, that does not seem to be the case. One possible
solution is controlling the max size of your pool through the connect
string.

For instance, we have some customers using Vault server for about 150-200
users. In a couple instances, there have been pool connection problems
when 100+ people have been connecting to the database within the same
time frame. There are no connection leaks in the server. This was just
an instance of a large amount of users accessing the database.

HTH
Jeff Clausius
SourceGear

"Srinivas Kollipara" <skollipara@xxxxxxxxxxxxxxxxxxx> wrote in
news:OpuGn7pcFHA.2760@xxxxxxxxxxxxxxxxxxxx:

> Hello all,
> I am wondering how to clear the connection pools from C# program,
> because my program everytime it runs , it needs 70 connections... so
> whenever my project fails i wanted to reset connection pools, or else
> after 3 to 4 runs, i am getting an error "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". then if i reboot it will be ok, i dont want to rebbot
> machine for this reason.. i heard a while back that this feature is
> included in .NET 2.0, can any one knows that it has that feature. can
> some one help me on this, how to do it.
>
> Thanks
> Srinivas
>
.

Relevant Pages

  • Re: Where is the database connection pool locating?
    ... authentication. ... Pool Fragmentation Due to Integrated Security ... Connections are pooled according to the connection string plus the user ... Although this improves the performance of subsequent database ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: How to clear connection pool?
    ... SQLConnection (SQL Server database), the pool size can be configured. ... >> connection problems when 100+ people have been connecting to the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Oracle Connectivity/Windows Service
    ... OracleConnection probably maintains a connection pool, ... When you restart the database server, ... Does restarting your Windows Service machine help? ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)
  • Re: Max pool size reached exception when trying to open a new connection
    ... Private Function GoodDataReaderCode(ByVal dataReader As IDataReader) ... 'The underlying connection to the database remains open and ... prior to obtaining a connection from the pool. ...
    (microsoft.public.dotnet.framework)
Loading