Re: connection pooling

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Connection Pooling is implemented by the .NET provider or the OLEDB provider. AFAIK, the OLEDB provider turns this on by itself. My question is: why are you using OLE DB to access SQL Server?

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Andy" <kc2ine@xxxxxxxxx> wrote in message news:eEXb6EPIIHA.4296@xxxxxxxxxxxxxxxxxxxxxxx
Hi,
Is there a way to enable connection pooling with SQL Server 2005 with ADO, OLEDB ? (from c++, not .net)
If client is connecting with the same connection string pooling is automatically created?
thanks


.

Relevant Pages

  • Re: There is already an open DataReader associated with this Comma
    ... Is there something to configure in SQL Server? ... connection pooling does not work with Table Adapters? ... SQL Server 2005 Profiler shows "Audit Login" then the whole 100 records to ... DBA and have he or she help you. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: There is already an open DataReader associated with this Comma
    ... TestTableAdapter ta_Test = new TestTableAdapter; ... SQL Server 2005 Profiler shows "Audit Login" then the whole 100 records to ... As far as you trying to test the connection pooling, you should get with a DBA and have he or she help you. ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: There is already an open DataReader associated with this Comma
    ... You are saying very HARD words here and very scorn ones. ... Is there something to configure in SQL Server? ... connection pooling does not work with Table Adapters? ...
    (microsoft.public.dotnet.framework.webservices)
  • Re: .ldb file stays when connection is closed
    ... I'm questioning whether the JET OLEDB Provider needs to support ... in connection pooling just as all others in ADO.NET do. ... .NET managed code wrappers, connection pooling is still determined by the capability of the database ... even if ADO.NET and the native OLEDB provider library *did* support connection pooling ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Application Roles and ASP.NET web apps...
    ... need to turn off connection pooling to get them to work properly. ... >trusted connections and database roles for application access to SQL Server. ... >2) Any other issues to consider using Application Roles with IIS apps? ...
    (microsoft.public.sqlserver.programming)