Subject Re: [firebird-support] Multiple Database Connection
Author Nihat Tunali
It's not solution and basic..:(

like that, db1 one in paris, db2 in bonn, db3 in london, db4 in tokyo etc..

Niko

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <firebird-support@yahoogroups.com>
Sent: Monday, July 03, 2006 1:40 PM
Subject: RE: [firebird-support] Multiple Database Connection


>> 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
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
>
> __________ NOD32 1.1627 (20060627) Information __________
>
> This message was checked by NOD32 antivirus system.
> http://www.nod32.com
>
>