>I have naturally tried this simple solution. But it does not provide usage of indexes of tables FoxPro at their joining with SQL tables.
The OPENQUERY() is the only way to use Linked Server with ODBC connection. You can create Linked Server using VFP OLE DB provider. In this case you can use four part name to reference tables of Linked server: LinkedServer.DataBase.Owner.Table.
--sb--