Chudin Ilya


The bug is: driver doesn't support autoincrement fields: while trying to use any table, contains autoincrement fileld, the exception "Not a table." is thrown.


Re: BUG: Microsoft Visual Fox Pro ODBC Driver (6.1.8630.1)

CetinBasoz


It is not a bug. ODBC driver is documented not to support versions later than VFP6 (and won't be updated - latest was MDAC2.5 or 2.6). Use VFPOLEDB driver instead.




Re: BUG: Microsoft Visual Fox Pro ODBC Driver (6.1.8630.1)


Re: BUG: Microsoft Visual Fox Pro ODBC Driver (6.1.8630.1)

AndyKr

>>The bug is: driver doesn't support autoincrement fields

As Cetin says, this is not a bug!

The ODBC Driver is only valid for tables that use features available in Visual FoxPro Version 6.0. If a table (or DBC) uses features introduced later it is not readable by the ODBC driver.

The VFP ODBC driver is not being updated because the preferred methodology for accessing data in a Microsoft environment is to use OLEDB. Since VFP cannot be run outside of windows there is no need to support installations on a non-Microsoft platform, so there is no need for an ODBC driver. The OLEDB Provider for Visual FoxPro is fully compatible with VFP Version 9/0 and introduces many useful features not available to the ODBC driver. Check the help files for details under the topic:

How to: Access Visual FoxPro Data in Visual Studio

Which includes a lot of good examples