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])   &&Returns a -1

How can I get this to work?

Thanks,

Jerry