Hey Sergey,

"Connectivity error: [Microsoft][ODBC Visual FoxPro Driver]Not a table."

Any idea what would cause that??? Seems to be a table to me :-)


>Kevin,
>
>What ODBC error you get ( AERROR() ) ?
>
>>I am using the following code to connect to my DBC. Pretty straightforward....
>>
>>

>>
>>lcDB = "C:\TTS\DBFS\tts.dbc"
>>lcConnectString = "Driver={Microsoft Visual FoxPro Driver};" + ;
>>		  "SourceType=DBC;SourceDB=" + lcDB + ";" + ;
>>		  "Exclusive=No;NULL=NO;Collate=Machine;" + ;
>>		  "BACKGROUNDFETCH=NO;DELETED=NO"
>>
>>lnStringConnection = SQLStringConnect(lcConnectString, .T.)
>>?lnStringConnection  && returns 1
>>
>>lnConnection = SQLCONNECT(lnStringConnection)
>>?lnConnection && returns 2
>>
>>

>>
>>I have 3 tables that were added to the dbc a couple of months ago. If I try a SQLExec to one of these new tables, it will not connect. It will connect to any of the tables that were there previously:
>>
>>

>>* old table
>>lsSql = "SELECT * FROM employee"
>>lnSuccess = SQLExec(lnConnection, lsSql, "tProcess")
>>?lnSuccess  && returns 1
>>
>>* one of the new tables
>>lsSql = "SELECT * FROM reserve"
>>lnSuccess = SQLExec(lnConnection, lsSql, "tProcess")
>>?lnSuccess  && returns -1
>>