Devart Forums

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

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 .