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#.

 

[Scott Allen]

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

See:
http://msdn.microsoft.com/library/d...nectionpoolingforsqlservernetdataprovider.asp

 

[Jon Skeet [C# MVP]]

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.