Re: How to clear connection pool?

Srinivas:

This feature may or may not be configurable based on your back end
database.

For instance, in the example I gave, modifying the connect string used by
SQLConnection (SQL Server database), the pool size can be configured. It
can be turned on/off (Pooling), as well as controlled by 'Max Pool Size'
and 'Min Pool Size' attributes. For the SQL Server example, see
SQLConnection.ConnectionString within .Net Help.

HTH
Jeff Clausius
SourceGear


"=?Utf-8?B?YWU=?=" <ae@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:2D43745D-0D8F-4448-A70D-1903CC891609@xxxxxxxxxxxxx:

> 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: My Book is Incomplete Regarding SQL Commands ;-(
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... Create a Connection object and pass in a ConnectionString to ... manage the database table you reference. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: (Newbie)Application Roles
    ... level: the database itself. ... SQL Server accommodates these needs through the use of application ... the user's connection through a specific application. ... the connection permanently loses all permissions applied to ...
    (microsoft.public.sqlserver.security)
  • Re: Help! Set up Windows Group to access application
    ... The connection string for a trusted connection is: ... --add login as database user ... SQL Server MVP ... If you have troubles with finding your ways in Crystal Reports, ...
    (microsoft.public.sqlserver.security)
  • Re: My Book is Incomplete Regarding SQL Commands ;-(
    ... Visual Studio but not to VS 2003. ... Create a Connection object and pass in a ConnectionString to address ... manage the database table you reference. ... Yep, my latest book can help too, but mostly if you're targeting SQL Server ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Logging in in background
    ... wold take all kinds of modifictions as I'd need to be checking that each SQL ... my database and all have connection strings associated with them. ... I suspect that there is also an issue on the SQL Server side as I keep ...
    (microsoft.public.access.modulesdaovba)