Subject RE: [firebird-support] Multiple Database Connection
Author Alan McDonald
> Hi,
> Configuration:
>
> - i have a four firebird database in my local/server computer.
> - In my Delphi program ,i used zeos component /other not important.
> - One database component and connected to only one database (such as db1)
> - In db1 database has some procedures,triggers & views
>
> * My question:
> - How can i connect to other databases (db2,db3, etc ) in Only SQL Query ?
> SELECT ........... FROM db1.table1, db2.table1 etc...????
>
> - How can call procedure,views and other dababase ddl functions
> SELECT ..........FROM db1.procedure1, db4.procedure1 ??????
>
> thanks.

you can't - put all the contents of the 4 dbs into one database. That's the
best way to handle it.
Alan