Connection Pool

Connection Pool

Postby 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
Reginaldo
 
Posts: 7
Joined: Sat 09 May 2009 21:46

Postby Plash » Tue 12 May 2009 07:26

Our dbExpress driver does not allow to use the connection pooling.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby Reginaldo » Tue 12 May 2009 15:57

Thanks, it run fine

Reginaldo
Reginaldo
 
Posts: 7
Joined: Sat 09 May 2009 21:46


Return to dbExpress driver for InterBase & Firebird