SQL 2008 64 bit Visual Foxpro Linked Server error

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
kdc415
Posts: 1
Joined: Wed 28 Feb 2018 16:43

SQL 2008 64 bit Visual Foxpro Linked Server error

Post by kdc415 » 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

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: SQL 2008 64 bit Visual Foxpro Linked Server error

Post by azyk » Thu 01 Mar 2018 09:33

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 .

Post Reply