sql server connection pooling

[Green]

Hi,
I has a web application which execute lots of query and store procedure
from the sql server 2000. I want to have a central controlled connection
pool so as to all the connection will get the connection from this pool and
return to this pool. How can i do this. Is there any article recommended?

Appreciate in advance!

[Green]

By the way, i am using ASP.Net and C#.

"Green" <so*****@yahoo.com> wrote in message
news:OX**************@TK2MSFTNGP15.phx.gbl...

Hi,
I has a web application which execute lots of query and store procedure
from the sql server 2000. I want to have a central controlled connection
pool so as to all the connection will get the connection from this pool and return to this pool. How can i do this. Is there any article recommended?

Appreciate in advance!

[Scott Allen]

The SQL Data Provider in .NET has built-in pooling functionality for
you to use.

See:
http://msdn.microsoft.com/library/de...taprovider.asp

--
Scott
http://www.OdeToCode.com

On Mon, 20 Sep 2004 15:25:33 -0400, "Green" <so*****@yahoo.com> wrote:

Hi,
I has a web application which execute lots of query and store procedure
from the sql server 2000. I want to have a central controlled connection
pool so as to all the connection will get the connection from this pool and
return to this pool. How can i do this. Is there any article recommended?

Appreciate in advance!

[Jon Skeet [C# MVP]]

Green <so*****@yahoo.com> wrote:

I has a web application which execute lots of query and store procedure
from the sql server 2000. I want to have a central controlled connection
pool so as to all the connection will get the connection from this pool and
return to this pool. How can i do this. Is there any article recommended?

You don't need to do anything special in your own code - just create
new instances of SqlConnection and call Dispose as soon as you've
finished with them (the using statement is handy here) - the data
provider will do appropriate pooling.

--
Jon Skeet - <sk***@pobox.com>
http://www.pobox.com/~skeet
If replying to the group, please do not mail me too