>>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'.
>Neither of those is a linked server. What tool are you using to run queries?
--sb--