Jim,
The VFP ODBC driver has not been updated since VFP6SP5. It doesn't support any new table and DBC feature introduced in VFP7 and later. You can use VFP OLE DB provider which is up to date.
>I am trying to insert/update a row on a VFP table using the VFP ODBC driver from VFP9. I make the connection to the database (.DBC) and get back a handle of 1. I can then query the target table and get data back with no problem. But when I submit a SQL UPDATE or INSERT command against the same table SQLEXEC() returns a value of -1. Using AERROR() it is shows me that the ODBC error returned to me is:
>
>AODBCERROR Pub A
> ( 1, 1) N 1526 ( 1526.00000000)
> ( 1, 2) C "Connectivity error: [Microsoft][ODBC Visual F
> oxPro Driver]Not a table."
> ( 1, 3) C "[Microsoft][ODBC Visual FoxPro Driver]Not a t
> able."
> ( 1, 4) C "S0002"
> ( 1, 5) N 123 ( 123.00000000)
> ( 1, 6) N 1 ( 1.00000000)
> ( 1, 7) C .NULL.
>LCERROR Pub C "Connectivity error: [Microsoft][ODBC Visual F
> oxPro Driver]Not a table."
>
>My VFP ODBC driver is version 6.00.8167.00 dated 7/28/2004.
>
>In case you're wondering why I'd want to access a VFP table from VFP via ODBC it's because I'm working on a data manager that my application can switch between a VFP database and a MS SQL Server database without having to change my application.
>
--sb--