Re: Connection pooling

From: Michael D. Long (michael.d.long-nospam_at_comcast.net)
Date: 08/26/04 

Date: Wed, 25 Aug 2004 20:37:20 -0400

Obviously what you want to do can be done - look at how MTS/COM+ objects
interoperate with the connection pool. It really sounds like what you are
trying to accomplish is already available with little or no effort on your
part other than to make ADO open and close calls appropriately. The
connection pooling algorithm is fairly simplistic, but it will maintain a
pool of connections as long as at least one connection remains open in your
process. 

-- 
Michael D. Long
Microsoft MVP - Windows SDK
"Jim Cutler" <JimCutler@discussions.microsoft.com> wrote in message
news:655B5B83-18D0-46A0-999E-274BE2FB8AAA@microsoft.com...
> I am using C++ 6.0.  I am writing a DLL to be called by another app.  That
> app currently creates a pool of connections during initialization and then
> temporarily handing out connections to worker threads (which come and go).
> Are there any issues involved in using an ADO connection from a thread
that
> did not actually open the connection?  In other words, does the process of
> opening the connection configure the thread in some way that will be
missing
> if another thread tries to use the connection?

Relevant Pages

  • Re: Connection pooling
    ... Each message spawns a new instance of a C# dll via COM. ... | I have only tested the dll's being created via a Console app, ... | use that pool. ... transaction, you close the connection. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Close and Dispose argument
    ... > fact that even Microsoft is not clear on the issue. ... > connections from the pool is still a debate. ... > method removes the conneciton from the connection pool". ... > Your issue was forwarded to us here at Microsoft Courseware Support. ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Internal connection fatal error
    ... It's just the nature of the app... ... > 80 connections in the pool tells me this is a heavily loaded system. ... > Yes, if an operation fails at the server, the connection can be broken. ...
    (microsoft.public.dotnet.framework.adonet)
  • Close and Dispose argument
    ... here is an email conversation between me and Microsoft ... connections from the pool is still a debate. ... Programming with Microsoft ADO.NET" module 2, p 18: "Calling the Dispose ... method removes the conneciton from the connection pool". ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: too many cursors open
    ... Is the app java? ... This usually means you are not closing callable statements and result ... instrument it and instrument where you get the connection from the pool ...
    (comp.databases.oracle.misc)