Re: Disable .Net Connection Pooling thru SQLDMO

From: oj (nospam_ojngo_at_home.com)
Date: 01/28/05 

Date: Fri, 28 Jan 2005 10:14:51 -0800

Rob,

Would you care to post some code. If you're using .NET you have full control
of how you want with pooling
(http://msdn.microsoft.com/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp?frame=true). 

-- 
-oj
"Rob Kraft" <robkraft@msn.com> wrote in message 
news:%23wPrVQVBFHA.2316@TK2MSFTNGP15.phx.gbl...
>I would like to disable the .Net connection Pooling.  I have a conversion
> pgm using SQLDMO and .Net that needs to kill its own connections, but 
> leave
> existing user connections, before continuing.  However, I don't see a way 
> to
> tell .Net to disable connection pooling when I create connections through
> SQLDMO.
>
> Is it possible?
>
> Rob Kraft
>
>

Relevant Pages

  • Re: Disable .Net Connection Pooling thru SQLDMO
    ... "Rob Kraft" wrote in message ... > and not the SQLDMO connections. ... But here is our SQLDMO code in .Net: ... >>>I would like to disable the .Net connection Pooling. ...
    (microsoft.public.sqlserver.programming)
  • Re: Question about Connection Pooling in ASP
    ... you almost have to deliberately turn off connection pooling in order ... As long as you are talking about storing a string in Application, ... pooling is used for all connections using that string. ... using connected recordsets, instead of utilizing GetString, GetRows ...
    (microsoft.public.inetserver.asp.db)
  • Re: How to close connection pool?
    ... Simply open connections with pooling disabled--or as suggested when ... Microsoft MVP ... pool preventing it until the user exits the application. ... so I need to set pooling to false for that action. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: How should I connect via DBD::Oracle to efficiently obtain 2000+ simultaneous connections?
    ... Here are a few options off the top of my head: ... Pooling via SQLRelay ... connections, just reduces the number of connections required. ... to take some load off of your database server. ...
    (perl.dbi.users)
  • Re: Global data concurrent access ?
    ... No pooling 1000 iterations. ... Elapsed time: 00:00:12.9217096 ... affects pooled connections (makes sense; ...
    (microsoft.public.dotnet.framework)