Subject | Re: [firebird-support] Multiple Database Connection |
---|---|
Author | Johannes Pretorius |
Post date | 2006-07-03T12:55:23Z |
What I can suggest , maybe not the best.
Is we used Microsoft Acccess. Made ODBC connections to the db's and used that in the queries to combine.
Then access will do the combination etc. But I did this long ago. certain there are oaks with more experience than can give
tips on this.
Hope it helps
Johannes
At 12:55 PM 03/07/2006, you wrote:
Is we used Microsoft Acccess. Made ODBC connections to the db's and used that in the queries to combine.
Then access will do the combination etc. But I did this long ago. certain there are oaks with more experience than can give
tips on this.
Hope it helps
Johannes
At 12:55 PM 03/07/2006, you wrote:
>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
>>
>>
>
>
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>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
>
>
>
>