>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.Sergey,
Just as an FYI, OPENQUERY() is actually not the only way to get at an ODBC linked server. I was able to figure out a way to connect to an ODBC VFP linked server using the 4-part notation by using the linked server name for the first and second parts (e.g. VFPData.VFPData..Trades). Works like a charm.
The driving force for having figured this out was the need to use a declared script variable inside my SELECT statement. And yes, using OLE DB is just too slow.
Laterness,
Jon
Jon Rosenbaum
Devcon Drummer