>>>I’m accessing some VFP data from SQL server using a linked server. It takes 6 seconds to pull a single row from a small table using an indexed field. The same query within Fox is instantaneous.
>>>I had thought that the OLEDB driver would make use of Fox indexes. That doesn't seem to be happening. The data is local to everything.
>>>What kind of performance are others seeing?
>>
>>In my tests VFP linked server that uses OLE DB over ODBC was much faster than one that uses VFP OLE DB provider.
>
>Sergey,
>I'm not sure I understand.
>Are you saying that I should try setting up an odbc source and see how that goes?
Yes, try to use VFP ODBC for linked server. Remember that you'll have to us OPENQUERY() instead of four part name to access VFP data.
--sb--