Hi,
in my C# project it uses 24 sql connections, i am clearing all the
conncetions whenever an error occurs and when i see in the performance
monitor for that pool i can still see all those 24 connections sitting over
there. so i am wondering how to clear the connection pool in C#. can anyone
suggest me in this. i need to do that programmatically. thanks in advance.
srinivas

ADO.NET uses connection pooling so even if you're closing your connections
in the code, the framework will keep them open for a while (until the
connection lifetime ends). As far as I know, currently there's no way to
force closing of actual connections to the database (other than disabling
connection pooling totally which is not recommended). I believe next version
of ADO.NET will provide the ability to clear the connection pools.
-Amit

"Srinivas Kollipara" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> in my C# project it uses 24 sql connections, i am clearing all the
> conncetions whenever an error occurs and when i see in the performance
> monitor for that pool i can still see all those 24 connections sitting
over
> there. so i am wondering how to clear the connection pool in C#. can
anyone
> suggest me in this. i need to do that programmatically. thanks in advance.
> srinivas
>
>

Srinivas,

In .NET 1.1 you cannot clear the connection pool. And that is not such a big
deal because eventually they will close out or be reused per application
demands. The problem is when the SQL Server reboots and all your connections
that your side thinks are open and will throw weird errors now.

In .NET 2.0 however, the connection pool is cleared for you at the first
instance of such an error, so you do get this error once, but only once.
Alternatively, the SqlConnection object provides you with methods to clear
all connection pools or clear connection pool per connectionstring should
you choose to do so manually.

- Sahil Malik
http://dotnetjunkies.com/weblog/sahilmalik




"Srinivas Kollipara" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi,
> in my C# project it uses 24 sql connections, i am clearing all the
> conncetions whenever an error occurs and when i see in the performance
> monitor for that pool i can still see all those 24 connections sitting
> over
> there. so i am wondering how to clear the connection pool in C#. can
> anyone
> suggest me in this. i need to do that programmatically. thanks in advance.
> srinivas
>
>

thanks for your help
srinivas
"Amit" <(E-Mail Removed)> wrote in message
news:#(E-Mail Removed)...
> ADO.NET uses connection pooling so even if you're closing your connections
> in the code, the framework will keep them open for a while (until the
> connection lifetime ends). As far as I know, currently there's no way to
> force closing of actual connections to the database (other than disabling
> connection pooling totally which is not recommended). I believe next
version
> of ADO.NET will provide the ability to clear the connection pools.
> -Amit
>
> "Srinivas Kollipara" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> > in my C# project it uses 24 sql connections, i am clearing all the
> > conncetions whenever an error occurs and when i see in the performance
> > monitor for that pool i can still see all those 24 connections sitting
> over
> > there. so i am wondering how to clear the connection pool in C#. can
> anyone
> > suggest me in this. i need to do that programmatically. thanks in
advance.
> > srinivas
> >
> >
>
>

thanks for your help
srinivas

"Sahil Malik" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Srinivas,
>
> In .NET 1.1 you cannot clear the connection pool. And that is not such a
big
> deal because eventually they will close out or be reused per application
> demands. The problem is when the SQL Server reboots and all your
connections
> that your side thinks are open and will throw weird errors now.
>
> In .NET 2.0 however, the connection pool is cleared for you at the first
> instance of such an error, so you do get this error once, but only once.
> Alternatively, the SqlConnection object provides you with methods to clear
> all connection pools or clear connection pool per connectionstring should
> you choose to do so manually.
>
> - Sahil Malik
> http://dotnetjunkies.com/weblog/sahilmalik
>
>
>
>
> "Srinivas Kollipara" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > Hi,
> > in my C# project it uses 24 sql connections, i am clearing all the
> > conncetions whenever an error occurs and when i see in the performance
> > monitor for that pool i can still see all those 24 connections sitting
> > over
> > there. so i am wondering how to clear the connection pool in C#. can
> > anyone
> > suggest me in this. i need to do that programmatically. thanks in
advance.
> > srinivas
> >
> >
>
>