Page 1 of 1

xBase ODBC Driver error with PHP

Posted: Mon 08 Jan 2018 14:22
by paparupps
I am having trouble using your trial xBase ODBC driver in our PHP application accessing Foxpro DBFs.

Here is the connection string I am using :

$conn = odbc_connect('Driver={Devart ODBC Driver for xBase};Database=C:\pako\vfp\common\systdata\;DBF Format=VisualFoxPro;Code Page=UnitedStatesOEM;Connect', '', '');

Below is the query and error message (including the first query attempted by the application) that I am getting.

$GetModQuery = "SELECT sysinfo.userid, sysinfo.empno FROM sysinfo WHERE !(sysinfo.lockout) AND sysinfo.passexpire >= {".$today."} " ;
$GetModResult = odbc_exec($PAKO_conn, $GetModQuery);

odbc_exec(): SQL error: [Devart][ODBC][xBase]vtable constructor failed: spectbls, SQL state S1000 in SQLExecDirect.

Actually, this query has been modified as to be as simple as possible. It was originally a join query between 2 tables in different folders.

Any help you could give me on why this isn’t working would be appreciated…

Re: xBase ODBC Driver error with PHP

Posted: Tue 09 Jan 2018 15:04
by azyk
We have answered you by e-mail.