How can I Reverse Engineer a MS Visual FoxPro db into a Visio ERD

[Jberton]

I am trying to Reverse Engineer a set of MS Visual FoxPro tables into a Visio
2003 database ERD but cannot seem to find the right Visio driver to use. I
keep getting a message that says that I am using an incompatible driver and
that catalog information retrieved will be incomplete. I have tried ODBC
Generic (after setting up an DSN on my machine using the FoxPro driver there)
and have tried Generic OLE db provider as well and in both cases I get a
message after I select the tables I want to include that says "Invalid Column
Number" and then nothing is reverse engineered. I have only used the Reverse
Engineer one other time in Visio but with a SQL Server 2000 database and that
worked just great. I just can't seem to have the same success with Visual
FoxPro. Any ideas?

 

[paul nash]

Hope you still need this info,
Had the same problem trying to Reverse Engineer VFP 6 Database from VISIO.

Decided there must be a problem with the driver. Amazingly Microsoft provide
a new ODBC driver here: - (as an MSI)

http://msdn.microsoft.com/vfoxpro/downloads/updates/odbc/default.aspx

I wonder why... Anyway I installed this MSI, rebooted, recreated my DSN and
bob's your uncle everything worked fine no errors.

NOTE: I've only tried using a free table directory. I was however getting
the same error.

Cheers,

Paul