Subject | RE: [firebird-support] Multiple Database Connection |
---|---|
Author | Alan McDonald |
Post date | 2006-07-03T11:08:19Z |
> It's not solution and basic..:(you said below that they are all on your local computer....
>
> like that, db1 one in paris, db2 in bonn, db3 in london, db4 in
> tokyo etc..
>
> Niko
>
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
>
>
>
>
>
>
>