>Are you sure that test1 is a linked server to VFP tables? It doesn't look this way based on the error message. Do you have VFP ODBC driver on the PC with SQL Server?
Yes, I have an ODBC driver and tables.
While VFPOLEDB, for example works ok:
select * from OpenRowset('VFPOLEDB.1','e:\sqltest' ; '' ; '' ,'select * from MyTable')
But this doesn't:
SELECT * FROM
OPENROWSET('MSDASQL','Driver={Microsoft Visual FoxPro Driver};
SourceDB=e:\sqltest;SourceType=DBF', 'SELECT * FROM MyTable')
and I get
[OLE/DB provider returned message: [Microsoft][ODBC Visual FoxPro Driver]Unrecognized command verb.]
OLE DB error trace [OLE/DB Provider 'MSDASQL' ICommandPrepare::Prepare returned 0x80040e14].
.Net SqlClient Data Provider: Msg 7321, Level 16, State 2, Line 1
An error occurred while preparing a query for execution against OLE DB provider 'MSDASQL'.