Re: connection in connection pool with pooling=false

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 06/22/04 

Date: Tue, 22 Jun 2004 12:21:55 GMT

Hi Jason,

Thanks for your additional information!

Based on my research, SqlXmlCommand uses connection pooling by default as
ADO does. That might be the cause that there is always a connection remain
to the server.

Since SqlXml uses OleDb provider for SQL Server to connection, we cannot
use pooling=false to disable pooling. Instead, we can add "OLE DB
Services=-4;" in the connection string to disable connection pooling.
Please try it in your application to see if it works. HTH.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: ado connection object in vb6
    ... "Global connection objects are bad in so many ways. ... The key is that ADO uses 'connection pooling'. ... "Pooling in the Microsoft Data Access Components" ...
    (microsoft.public.vb.database.ado)
  • Re: SQL Resets
    ... When we turn on connection pooling, it loads up pretty fast to throw the ... I tend to believe it has something to do with the connection pooling. ... Have you had a look at the SQL Server ... Have you tested the development environment with MaxUserPort=64534, ...
    (microsoft.public.sqlserver.connect)
  • Re: MDAC question
    ... The MDAC downloads are labeled by the ... I suggested that the ADO data library is ... He simply created a connection object and set its connection time ... Connection pooling is just the kind of 'hidden' ...
    (microsoft.public.data.ado)
  • Re: MDAC question
    ... The MDAC downloads are labeled by the ... I suggested that the ADO data library is ... He simply created a connection object and set its connection time ... Connection pooling is just the kind of 'hidden' ...
    (microsoft.public.vb.database)
  • Re: Connection issues
    ... Connection pooling will have no impact on performance in a Windows Forms ... Test for errors on the server by checking @@Error. ... > one SP inserts a row with an identity column. ...
    (microsoft.public.dotnet.framework.adonet)