larrycjr
asked on
No Success with Linked Server to FoxPro 2.6 DOS data (yet).
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:
SELECT *
FROM TESTSVR01...Customer
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.
Thanks,
Larry
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:
SELECT *
FROM TESTSVR01...Customer
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.
Thanks,
Larry
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.