odbc error

[Netman]

Hello,

I have a single table in a large database which I can't access through odbc.
The error I get is "Microsoft ODBC ..... not a table". I also cannot access
this table using my old VFP 6 -- I must use VFP 8 to open it. I have looked
for an updated version of vfpodbc but I can't find one later than 6.1.8629.1

Thanks,

Ken

[Rick Bean]

Ken,
You'll have to use the MS VFP OLE DB client instead of ODBC to access any table that has any "new" VFP 7.0, 8.0 or 9.0 table or database features - including any of the newer field types. The current (latest and last?) ODBC driver was indeed released with VFp 6.0 SP 5, and it's just plain obsolete for many uses.

Rick

Post by Netman
Hello,
I have a single table in a large database which I can't access through odbc.
The error I get is "Microsoft ODBC ..... not a table". I also cannot access
this table using my old VFP 6 -- I must use VFP 8 to open it. I have looked
for an updated version of vfpodbc but I can't find one later than 6.1.8629.1
Thanks,
Ken