You have to use OPENQUERY
SELECT * FROM openquery([LinkServerName], 'select * from mytable')
ISERT INTO openquery([LinkServerName], 'select * from mytable') (...) VALUES (...)
See BOL for details.
>Microsoft SQL-server 2000
>I have created the Linked server with the database on VFP (6.0 SP5) with usage ODBC and Microsoft Visual FoxPro driver (6.01). But I can not query to FoxPro tables. Query: Select * From myfox...adr gives an error:Invalid schema or catalog specified for provider 'MSDASQL'. That should be schema and catalog with reference to Visual FoxPro
--sb--