I setup a system DSN and the Test Connection is successful.
I setup linked server in SQL and it is able to enumerate the tables, however it can't read the schema of the tables.
If I run: select * from openquery(DSNNAME, 'select * from tablename')
I get: OLE DB provider "MSDASQL" for linked server "DSNNAME" returned message "[Devart][ODBC][xBase]vtable constructor failed: IDCOUNT".
If I run this query:
SELECT * FROM OPENROWSET('MSDASQL',
'DRIVER={Devart ODBC Driver for xBase};Database=C:\apps\dbffolder\;DBF Format=VisualFoxPro;Code Page=UnitedStatesOEM;Connect Mode=Exlusive',
'SELECT * FROM tablename')
I get: OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Devart][ODBC][xBase]vtable constructor failed: IDCOUNT".
SQL has permissions on the files and I can see successful reads in processor monitor.
Any thoughts?
Thx -K
SQL 2008 64 bit Visual Foxpro Linked Server error
Re: SQL 2008 64 bit Visual Foxpro Linked Server error
Please send us a table files (tablename.*) with test data, on which the issue is reproduced. You can send it via the contact form at our site: https://www.devart.com/company/contactform.html .