clearing connection pool

[Srinivas Kollipara]

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

[Amit]

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" <sk********@stratasolutions.com> wrote in message
news:uY**************@TK2MSFTNGP14.phx.gbl...

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

[Sahil Malik]

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" <sk********@stratasolutions.com> wrote in message
news:uY**************@TK2MSFTNGP14.phx.gbl...

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 Kollipara]

thanks for your help
srinivas
"Amit" <re***********@hotmail.com> wrote in message
news:#k**************@TK2MSFTNGP14.phx.gbl...

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" <sk********@stratasolutions.com> wrote in message
news:uY**************@TK2MSFTNGP14.phx.gbl...

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 Kollipara]

thanks for your help
srinivas

"Sahil Malik" <co*****************@nospam.com> wrote in message
news:uc**************@tk2msftngp13.phx.gbl...

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" <sk********@stratasolutions.com> wrote in message
news:uY**************@TK2MSFTNGP14.phx.gbl...

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