If you have any new features used in your tables, then ODBC would not work for you. Do you use new field types or AutoIncrement fields?
>I have a VFP database that I am trying to access with a SQLStringConnect(). My connection handle seems to get created but the SQLEXEC() returns a -1 and AERROR() says 'Connectivity error, Not a Table'.
>
>Here are the commands I am using:
>
>lc_ConnectionString = ;
> "Driver={Microsoft Visual FoxPro Driver};SourceType=DBC;SourceDB=C:\mydir\mydatabase.dbc;Exclusive=No; NULL=NO;Collate=Machine;BACKGROUNDFETCH=NO;DELETED=NO;"
>lc_sql = "SELECT * FROM mytable"
>ln_results = SQLEXEC(ln_conn, lc_sql, [c_results])
>
>
>How can I get this to work?
>
>Thanks,
>
>Jerry
If it's not broken, fix it until it is.
My Blog