sql server connect: SQL 2000 SP4 on Server 2003 SP1 not dropping connections -- sql server connect

SQL 2000 SP4 on Server 2003 SP1 not dropping connections

Brad Martin
12/26/2006 6:24:00 PM

sql server connect: We recently upgraded our SQL 2000 SP3 instance (running on Windows 2000) to
SQL 2000 SP4 running on Windows Server 2003 SP1. The migration went fine
but we are now experiencing a problem where connections are not dropping
once the application is finished with it. The application is a COM+ app
making an ODBC connection, which then never closes. We are running a job
that cleans up the connections, but we can't seem to find the reason why SQL
is keeping the connections open in the first place. Any ideas or
suggestions?

Brad

Re: SQL 2000 SP4 on Server 2003 SP1 not dropping connections

Andrew J. Kelly
12/28/2006 8:47:44 AM

Sounds like you now using connection pooling which will always keep x many
connections to SQL Server even though the app closes the connection. This is
usually a desirable feature.

--
Andrew J. Kelly SQL MVP

[quoted text, click to view]