Subject | Two databases query |
---|---|
Author | yartax1 |
Post date | 2004-12-03T12:31:43Z |
Hi,
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.
Thanks!
Julian.
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.
Thanks!
Julian.