can't link to foxpro tables

  • Thread starter jamie considine
  • Start date
J

jamie considine

For some reason, the odbc driver does not work with visual
foxpro tables. updated to mdac 2.8. keep getting
message "unknown error". Any ideas?
 
C

Cindy Winegarden

In
jamie considine said:
For some reason, the odbc driver does not work with visual
foxpro tables. updated to mdac 2.8. keep getting
message "unknown error". Any ideas?
Click to expand...

Hi Jaime,

The last MDAC with the FoxPro and Visual FoxPro ODBC driver was version 2.5.
You can download it from
http://msdn.microsoft.com/vfoxpro/downloads/updates/default.aspx.

Over the years there have been some features added to FoxPro tables. When a
table has features that were added in VFP7 or VFP8 then it can't be read
using the ODBC driver. (A table created in VFP7 or 8 but not having any of
the new features will be readable.)

To read tables with the newer features, as well as tables in older formats,
use the OLE DB provider, downloadable from the above link.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing FoxPro 2.6 DBF Into Access 2007 1
Problem Linking Foxpro 9 .DBC in Access 2003 7
Link Visual Fox Pro 8.1 to Access 2003 2
Error Linking to VFP Tables 3
ODBC link to Visual Foxpro leaves some tables not visible 8
Linking Access 2003 to Vis. FoxPro w/ODBC 2
Linking Visual Foxpro tables to Access 2003 1
Linking foxpro tables in access 2003 2

Top