Subject | Multiple Database Connection |
---|---|
Author | Nihat Tunali |
Post date | 2006-07-03T10:32:52Z |
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.
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.