You cannot access VFP7 and later tables through VFP ODBC driver. Consider using CA with ADO (VFP OLE DB provider).
>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?
--sb--