🚀 go-pugleaf

You may try to add linked server to MS SQL Server. Look sp_addlinkedserver
in BOL.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 +
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Patrick Wong" <patrickwong@computer.org> �������/�������� � ��������
���������: news:41bfa1cc$1@newsgroups.borland.com...
> Dear all,
>
> I don't know whether this is the right place to post this message, since
the
> problem is not specific to ADO.
>
> This is an existing application that requires data from two different
> databases, Informix and MSSQL Server.  Informix provides a view for MSSQL
> server to fetch required dataset.  MSSQL constructs its own records
>
> A new requirement is that based on the records in one of the MSSQL table,
I
> need to get extra data from Informix's view, which having matched fields
in
> two.  Since VCL data access components (TQuery, TADOQuery, etc.) have one
> database name only, how can I specify to join two tables in these
separated
> databases?
>
> Thanks for any kind advice.
>
> Best regards,
> Patrick
>
>