Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 771
  • Last Modified:

Turn off connection pooling for client applications connecting to SQL Server 2k

We are running an ASP.net application on .net 1.1 running on IIS 6 on Windows Server 2003.

We are connecting back to a SQL Server 2000 box.

We want to turn off all connection pooling between the webserver and the SQL server.  We would prefer to do this with one central setting.  We do not want to specify it in the connection string as we have very many web.config files throughout the server that we would have to update.

Can it be done centrally on the webserver or on the DB server?
0
kenshaw
Asked:
kenshaw
2 Solutions
 
Daniel WilsonCommented:
I hesitate to absolutely say something can't be done ... but I really don't think it can.  Sorry!
0
 
Ted BouskillSenior Software DeveloperCommented:
Do you realize you will lose performance if you remove the connection pooling?  Establishing a connection with a database is time consuming.  Connection pooling was added to alleviate that problem.
0
 
QlemoC++ DeveloperCommented:
I'm pretty sure that this option exists only on the client side. You can't set a "default connection string" with some options on server.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now