kenshaw
asked on
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.