No Success with Linked Server to FoxPro 2.6 DOS data (yet).
Posted on 2003-11-05
I've tried to 'get at' some FoxPro 2.6 DOS data through SQL's Linkded Servers feature. MS Access seems to work okay. As well as MS Excel. When I try to use OLE DB for ODBC data sources, ... not so much.
I create an ODBC system DSN to FoxPro data with the Visual FoxPro driver version 6.xx.xxxx. This seems to work well for MS Access databases that link to external data. In Enterprise Manager, I can create the Linked Server, and when I click on 'Tables', all of the table names appear in the browse window.
If I start up Query Analyzer, then run a statement such as:
I get an error message:
Server: Msg 7313, Level 16, State 1, Line 1
Invalid schema or catalog specified for provider 'MSDASQL'.
I suspect that the driver is too old/inadequate... or something. If anyone can help, I would appreciate it.