Home All Groups Group Topic Archive Search About

Closing sqlconnection question

Author
20 Aug 2006 5:35 PM
Mark
Hello,

Why when I close a sqlconnection in VB.NET does the connectionnot logout in
sqlserver?  The sqlsever connection still remains but in a sleeping state.

Any help would be greatlly appreciated!
Thanks in advance

Author
20 Aug 2006 5:59 PM
Jared
Do you have connection pooling enabled?

Show quoteHide quote
"Mark" wrote:

> Hello,
>
> Why when I close a sqlconnection in VB.NET does the connectionnot logout in
> sqlserver?  The sqlsever connection still remains but in a sleeping state.
>
> Any help would be greatlly appreciated!
> Thanks in advance
>
Author
20 Aug 2006 6:11 PM
Mark
Yes.  I disabled it and that fixed the problem.  Thanks for you help!

Show quoteHide quote
"Jared" wrote:

> Do you have connection pooling enabled?
>
> "Mark" wrote:
>
> > Hello,
> >
> > Why when I close a sqlconnection in VB.NET does the connectionnot logout in
> > sqlserver?  The sqlsever connection still remains but in a sleeping state.
> >
> > Any help would be greatlly appreciated!
> > Thanks in advance
> >