Subject Re: [IBO] Two databases query
Author Helen Borrie

At 12:31 PM 3/12/2004 +0000, you wrote:

>In my BCB 6 project I must perform a query from 2 different databases
>( one firebird server and one MS SQL ). The query must mix both query
>in one query (matching key fields like 'left outer join'). I thought
>to put a TIBQuery with data from firebird and TADODataSet to MSSQL. Is
>there any IB component to perform the "join" with both datasets? Also,
>I thought add some extra fields in one query and then fill with data
>from the other query and match data by code ( it's cost expensive! ).
>Both queries are read-only, so data didn't take back to servers.

You are trying to do something that Firebird does not support. It does not
even support cross-database joins from one Firebird database to another.