how to delete a connection pool?

  • Thread starter Thread starter Jason Collins
  • Start date Start date
J

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
 
Jason Collins said:
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?
Click to expand...
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?
Click to expand...
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

--
Click to expand...

W.G. Ryan, eMVP

http://forums.devbuzz.com/
http://www.knowdotnet.com/williamryan.html
http://www.msmvps.com/WilliamRyan/
 
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
 
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.

:-P

Jon
 
Back
Top