Connection Pool

Reginaldo · Post by **Reginaldo** » Sat 09 May 2009 22:19

Hi, does anybody know how to set up a connection pool using DBX Driver for InterBase/Firebird (via dbxconnections.ini + dbxdrivers.ini or via code)?
I'm using Delphi 2009 + Devart InterBase/Firebird DBX4 Driver (sigle developer licence) + Firebird 2.1 and I have 1 TSQLConnection per remote server, but if I have dozens of client apps connected to the server, I think I should have to pooling my SQLConnection.

Thanks in advance,
Reginaldo Francisco - |Brasil

Plash · Post by **Plash** » Tue 12 May 2009 07:26

Our dbExpress driver does not allow to use the connection pooling.

Plash · Post by **Plash** » Tue 12 May 2009 07:58

The driver does not include the code for connection pooling. But you can use the connection pooling support in dbExpress 4.

Set the Driver property for TSQLConnection component in Object Inspector. Click on the plus sign beside the Driver property. You will see two subproperties: DelegateName and DelegateConnection. Select DBXPool for the DelegateConnection property. This will enable pooling. Then you can open subproperties for DelegateConnection, and edit properties of the connection pool.

Reginaldo · Post by **Reginaldo** » Tue 12 May 2009 15:57

Thanks, it run fine

Reginaldo