SqlConnection close

[Cwee]

I have a "SqlConnection" Object I do an open then a close.
This does not seem to release the connection. If I do a
SP_WHO on the SQL server the connection is still active.

What I am doing wrong?

Thanks

-- CWee

 

[Nicole Calinoiu]

Maybe nothing. The connection will remain open and available to the
connection pool until it times out or is used again. Unless you've changed
the connection timeout parameters, this will take 1 minute.

HTH,
Nicole