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…
xBase ODBC Driver error with PHP
Re: xBase ODBC Driver error with PHP
We have answered you by e-mail.