SqlConnection close

[Cwee]

I have a "SqlConnect ion" 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]

Re: SqlConnection close

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" <cwee@ev1.net > wrote in message
news:09fd01c37b 99$5f0a2920$a30 1280a@phx.gbl.. .[color=blue]
> I have a "SqlConnect ion" 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[/color]