SqlConnection

[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

 

[William Ryan]

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

 

[Angel Saenz-Badillos[MS]]

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.