At 12:50 PM 30-01-01 -0800, you wrote:

>Michael L. Horne wrote:
>
> > Using IBO, how do I setup a query that will combine
> > data from 2 different DBs?
> >
> > 1. Setup Components?
> > 2. Write the SQL?
>
>There's no good way to do this with InterBase. You'll need two
>TIB_Connections, two TIB_Transactions, and two TIB_Queries. You'll have to
>do the joins, filters, whatever, on the client side.

Not quite right - IBO supports 2-phase commit. Please see my post - use a
single transaction for both connections.

H.

>Art Metz
>AMetz@...
>
>

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________