Pooling

From: Danny Kellett (DannyKellett_at_@hotmail..com)
Date: 05/27/04 

Date: 27 May 2004 14:46:24 -0700

Hi,

Im delevoping a 3 tier app using Indy components as the middleware and
ADO as the connection to the RDBMS. At the moment I have an ADO
connection for every client connection. What I want is to be able to
set a connecton value, say 5 in an ini file and then whent the server
starts, it opens all 5 ADO conections to the RDBMS and then the clients
use whatever connection it can or wait until the next on is available.
Has anyone got any ideas or example code on how to go about this please?

I have thought of having a TThreadlist with the open connections but Im
not sure how to write the actual pooling or load balancing of it.

Im sure someone out there has implemented something like it... I hope ;)

Any examples would be fantastic.
Thanks and kind regards
Danny

Relevant Pages

  • Re: C++ support for ADO
    ... TESTHR(pConn.CreateInstance(__uuidof(Connection))); ... In answer to your question I'm interested in ADO not the ADO.net. ... data classes for working with ADO/OLE DB. ... You can also use the OLE SDK. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.oledb)
  • Re: How to make the app run?????
    ... throwing an error if the connection never was opened, ... How can i tell if i'm using ADO as in VB or .Net ADO ?? ... First of all, it was not shown to my customer, I took it to a very nice ... How do you get in "installed" on client computer? ...
    (microsoft.public.dotnet.general)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.ado)