i said "my local/server computer." server means anywhere.!

duplication/replication is real solution ?

i know in MySQL, SELECT .......... FROM db1.table1,db2.table1 etc..
i think its best solution but mysql not really RDMS.! except 5 version.

it is a firebird problem multiple connection or not?

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


>> It's not solution and basic..:(
>>
>> like that, db1 one in paris, db2 in bonn, db3 in london, db4 in
>> tokyo etc..
>>
>> Niko
>>
>
> you said below that they are all on your local computer....
> well anyway...
> duplicate the contents of each into the others, then replicate the data if
> required.
> Alan
>
>>
>> >> 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
>> >
>> >
>>
>>
>>
>>
>> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>>
>> 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
>>
>>
>>
>>
>>
>>
>>
>
>
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> 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
>
>