Subject | Re: [firebird-support] Multiple Database Connection |
---|---|
Author | Nihat Tunali |
Post date | 2006-07-03T10:55:31Z |
It's not solution and basic..:(
like that, db1 one in paris, db2 in bonn, db3 in london, db4 in tokyo etc..
Niko
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
>
>