Connection pooling in SQL 2000

Hi,

I have some questions to be asked related to Connection pooling....

1)

I have enabled connection pooling and created a single connection to
SQL Server 2000 (SQLServer:General Statistics::User Connections = 1).
If I close the connection then the connection is placed back into the
pool (SQLServer:General Statistics::User Connections = 0) ? or the
value of the performance counter SQLServer:General Statistics::User
Connections remains 1 ?

2)

Suppose, I have enabled connection pooling and created a single
connection to SQL Server 2000. I closed the first connection and
immediately open another connection with the same connection string.
So, the first connection without being released is used or the new
connection is used from the connection pool?

3)

Suppose, I have enabled connection pooling and created a single
connection to SQL Server 2000. Now, immediately open another connection
with the same connection string. So, the first connection is used or
the new connection is used from the connection pool?

Please let me know ASAP.

Thanks,
Pramod

.

Relevant Pages

  • Re: Connection pooling in SQL 2000
    ... I have some questions to be asked related to Connection pooling.... ... I have enabled connection pooling and created a single connection to ... the new connection is used from the connection pool? ...
    (microsoft.public.data.ado)
  • Re: SQL Server does not exist or access denied.
    ... I checked my ODBC Admin screen and note that the "SQL Server" ... driver has enabled connection pooling. ...
    (microsoft.public.sqlserver.connect)
  • RE: Connection pooling
    ... Connection Pooling with SQL Server 2000 Analysis Services ... the Microsoft XML for Analysis Provider to develop scalable client and Web ... applications for Microsoft SQL Server 2000 Analysis Services. ... Balancing and Shrinking the Connection Pool ...
    (microsoft.public.sqlserver.programming)
  • Re: SQL Compact Edition - Connection Pool --> Slow!
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ... about the connection pool for Compact Edition 3.1. ...
    (microsoft.public.sqlserver.ce)
  • Re: SQL Compact Edition - Connection Pool --> Slow!
    ... Hitchhiker's Guide to Visual Studio and SQL Server ... and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook) ... mind (--> get a connection, use it and release it as soon as possible ... about the connection pool for Compact Edition 3.1. ...
    (microsoft.public.sqlserver.ce)