SqlConnection

  • Thread starter Thread starter Cwee
  • Start date Start date
C

Cwee

I do an "SqlConnection" open and then a close, but the
connection to the SQL server is not released. If I do a
SP_WHO on the server I still see the connection.

How to I get the connection to drop?

Thanks

-- CWee
 
Search down to the thread Connection Pool Exists After Program Ends.

Your close is working, but check out those posts, they go into it in depth.

HTH,

Bill
 
Connection pooling is on by default, add Pooling=false to your connection
string and the connection will be released on Close. Do a search for Pooling
in this newsgroup to get more information.
 
Back
Top