Page 1 of 1

Connection Pool

Posted: Sat 09 May 2009 22:19
by Reginaldo
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

Posted: Tue 12 May 2009 07:26
by Plash
Our dbExpress driver does not allow to use the connection pooling.

Posted: Tue 12 May 2009 07:58
by Plash
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.

Posted: Tue 12 May 2009 15:57
by Reginaldo
Thanks, it run fine

Reginaldo