469,610 Members | 1,853 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,610 developers. It's quick & easy.

SqlConnection close

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
Jul 21 '05 #1
1 2091
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
"Cwee" <cw**@ev1.net> wrote in message
news:09****************************@phx.gbl...
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

Jul 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Donnie Darko | last post: by
1 post views Thread by huzz | last post: by
3 posts views Thread by sevenfifteen | last post: by
4 posts views Thread by The Coolest Dolphin | last post: by
13 posts views Thread by MuZZy | last post: by
4 posts views Thread by Steve Richter | last post: by
4 posts views Thread by Victor | last post: by
5 posts views Thread by fniles | last post: by
reply views Thread by devrayhaan | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.