how to delete a connection pool?

[Jason Collins]

Is there a way that a connection pool can be explicitly deleted? E.g., using
the connection string, call some method that will close all the connections
in the pool?

Is there anyway to achieve this?

j

 

[William Ryan eMVP]

Is there a way that a connection pool can be explicitly deleted? E.g., using
the connection string, call some method that will close all the connections
in the pool?

You can specify that Pooling is turned off in the connection string.
However the "pool" is different from all of the users logged in in that
regard. You could have pooling turned off and still have X users. Is the
end goal to kick everyone out of the DB? Is so you can write a proc to
handle it

Is there anyway to achieve this?

This http://www.knowdotnet.com/articles/killallconnections.html will walk
you through writing a procedure to kick everyone out of the db if that's
what you want to do. If not, let me know.

j

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/

 

[Jason Collins]

I need to call that sproc from code (I need to do this work in my unit
test) - presumably this call would dump the connection I'm calling with too?

This will likely work, but I'd prefer to find an ado.net mechanism, if one
exists.

j

 

[Jon Davis]

You can unplug the drain ... it depends on how big your pool is, though. If
it's underground you should have a valve that drains straight to the sewage
line? If it's above ground, easiest way is to just tip it over.



Jon

 

[William Ryan eMVP]

AFAIK, there isn't any way to do it locally other than calling something
that's going to run on the server, so the end result is the same either way.

--

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/