Connections are not clearing when users exit SQL 
Author Message
 Connections are not clearing when users exit SQL

Users seem to be disconnecting from SQL without their connection count
being cleared.  Is there a setup option that need to be set in order to
clear connections?



Tue, 21 Sep 1999 03:00:00 GMT
 Connections are not clearing when users exit SQL

I've also heard of this when you're using sql 4.2 clients against a 6.0 or
6.5 server.  Make sure you're using the matching releases of db-lib and the
networking software for sqlserver on the clients and the server.
--
Richard Waymire, MCT, MCSE, MVP
Principal Engineer, ARIS Corp.
Visit us at http://www.aris.com



Quote:
> In most cases, this is because the custom front-end application they are
> using is not explicitly closing the connection.  Check the application
> if that's what they are using.

> Chris Stamey


> > Users seem to be disconnecting from SQL without their connection count
> > being cleared.  Is there a setup option that need to be set in order to
> > clear connections?

> --
> ------------------------
> Network Engineer
> Datatrace Information Services Company Inc.


> http://www.shortpump.com/nt

> I'm not a pessimist, I'm a "Realistic Optomist". I still see the glass
> as half full, I just want to know who the hell's been drinking out of
> it.
> -Don't remember the comedian's name.



Fri, 24 Sep 1999 03:00:00 GMT
 Connections are not clearing when users exit SQL

In most cases, this is because the custom front-end application they are
using is not explicitly closing the connection.  Check the application
if that's what they are using.

Chris Stamey

Quote:

> Users seem to be disconnecting from SQL without their connection count
> being cleared.  Is there a setup option that need to be set in order to
> clear connections?

--
------------------------
Network Engineer
Datatrace Information Services Company Inc.


http://www.shortpump.com/nt

I'm not a pessimist, I'm a "Realistic Optomist". I still see the glass
as half full, I just want to know who the hell's been drinking out of
it.
-Don't remember the comedian's name.



Fri, 24 Sep 1999 03:00:00 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. SQL 6.5 not clearing connections

2. User is not a Valid user of a trusted SQL Connection

3. HELP- User Not defined as valid user of trusted SQL Server connection

4. User does not exit?!?

5. Sleeping Users - Log not clearing

6. Connections not cleared from vb4 app

7. ADODB.Connection.Errors.Clear does not work...

8. Honestly, I am not insane...ODBC timeouts when no internet connection

9. Why Am I Not Releasing Connections???

10. Honestly, I am not insane...ODBC timeouts when no internet connection

11. How can i clear the MSHFLEXGRID without CLEAR - Como limpar a GRID sem usar CLEAR

12. User not associated with a trusted SQL connection


 
Powered by phpBB® Forum Software