WOO HOO! Thanks Sergey!
>>We want to get access to FoxPro data (2.6 actually, but we can possibly get to VFP) through our SQL Server. This is just a stop-gap measure until all apps that use the dbfs can be upgraded, then all data will reside on the SQL Server.
>>We used OLE DB for ODBC and we could see the tables from management console, but we can't get to the data itself.
>>
>>We have defined an DSN, jmwebvacs, and we use the ole db for odbc provider, linked name JMDATA, and we get schema/catalog errors when we try to query the tables that show up in enterprise manager. Also, from query analyzer, we use select * from JMDATA.[\\our\data\ats].[ ].[jmdebug.dbf] and various permutations and it complains.
>>
>>It is worse when we try an actual VFP container.
>>
>>Any ideas?
>
>You have to use OPENQUERY
>SELECT * FROM openquery([LinkServerName], 'select * from mytable')
>ISERT INTO openquery([LinkServerName], 'select * from mytable') (...) VALUES (...)