Board index » off-topic » Querying tables on 2 serveurs IB

Querying tables on 2 serveurs IB


2004-07-27 04:47:39 PM
off-topic10
Hello,
I need to make queries that links tables from IB Server1 to tables from IB
Server2, with BDE (Delphi 7) or ADO (Delphi 7).
I need also to insert data into IB Server2 from data in IB Server1.
But it doesn't work because I use 2 TDatabases... Tquery hangs.
Is there a way to do it ?
Thank you
Jean-Michel
 
 

Re:Querying tables on 2 serveurs IB

is it possible with ADO or IBX technologies ?
Thank you
Jean-Michel
"Bill Todd (TeamB)" < XXXX@XXXXX.COM >a écrit dans le message de
Quote
See Heterogeneous Joins in the BDE help file in your BDE directory.
Note that the BDE performs the query by fetching all of the data from
all of the tables to the local PC and executing the query there using
Local SQL so the performance is poor if the tables are large.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
 

Re:Querying tables on 2 serveurs IB

No.
Note that most reporting tools do allow you to query across databases.
JMG wrote:
Quote
is it possible with ADO or IBX technologies ?

Thank you

Jean-Michel

"Bill Todd (TeamB)" < XXXX@XXXXX.COM >a écrit dans le message de
news: XXXX@XXXXX.COM ...

>See Heterogeneous Joins in the BDE help file in your BDE directory.
>Note that the BDE performs the query by fetching all of the data from
>all of the tables to the local PC and executing the query there using
>Local SQL so the performance is poor if the tables are large.
>
>--
>Bill (TeamB)
>(TeamB cannot respond to questions received via email)



 

{smallsort}

Re:Querying tables on 2 serveurs IB

OK
This is logical.
Thank you
"Bill Todd (TeamB)" < XXXX@XXXXX.COM >a écrit dans le message de
Quote
On Wed, 28 Jul 2004 16:43:19 +0200, "JMG" < XXXX@XXXXX.COM >wrote:

>is it possible with ADO or IBX technologies ?

No. IB does not support joining tables from two databases so any tool
that does this will have to bring the data to the workstation and
execute the query there.

--
Bill (TeamB)
(TeamB cannot respond to questions received via email)