> There is no Firebird provider for the DBD yet, so I will be writing
> one to suit my needs.
>
> The default behavior for the DBD is one and only one connection to one
> DB. The one connection is setup in the apache configuration file and
> then connection pooling is used to manage the collection of connections.
>
> I am sure I can implement a custom Firebird provider that allows
> multiple connections. I am simply hoping for a way to "attach" to a
> second Firebird DB through a SQL statement using the initial connection.
> It will make my life much easier in implementing a DBD for Firebird.

Hi Sam!

EXECUTE STATEMENT ... ON EXTERNAL DATA SOURCE is available from Firebird 2.5 (release notes page 67ff). Have never used it myself and don't know whether it is powerful enough to suit your needs (it connects inside one statement), but it does imply connecting to other databases.

Moreover, I think QLI can connect to several databases. QLI is an old InterBase tool with a strange syntax (I think QLI was made before SQL became a standard) that only a handful of people know how to use. For Windows, it is in the BIN folder, same place as gbak and gfix, don't know if or where it is for DBD.

HTH,
Set