SQL 2008 64 bit Visual Foxpro Linked Server error
Posted: Wed 28 Feb 2018 16:54
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
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