Re: How to clear connection pool?

Jeff, how does one control the max size of a pool are you saying limit the
output results? Also, is there a max of results that can be returned? How do
I measure that if so.

"Jeff Clausius" wrote:

> 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: 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)
  • Close and Dispose argument
    ... here is an email conversation between me and Microsoft ... connections from the pool is still a debate. ... Programming with Microsoft ADO.NET" module 2, p 18: "Calling the Dispose ... method removes the conneciton from the connection pool". ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: MinPoolSize behaviour
    ... Min Pool Size, The first time you open a connection we will open the 1 ... > Is the pool created forever? ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Q:Multithreaded ADO.Net Connections Are Non Pooled?
    ... different you get a new pool. ... > the process/app domain differences, does running on a thread created by ... If you're using SSPI, each connection must be ... >> connect to the SQL Server machine, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connection pooling and changed password issue
    ... There is no "clear the pool" or "drop the pool" until ADO.NET 2.0. ... > Hi - so a previously made connection with the old credentials will still ... > "William Vaughn" wrote: ... >>> username/password then the connection pool will be used and the same ...
    (microsoft.public.dotnet.framework.adonet)
Loading