xBase ODBC Driver error with PHP

Discussion of open issues, suggestions and bugs regarding usage of ODBC Drivers
Post Reply
Posts: 1
Joined: Mon 08 Jan 2018 14:17

xBase ODBC Driver error with PHP

Post by paparupps » Mon 08 Jan 2018 14:22

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…

Devart Team
Posts: 1001
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: xBase ODBC Driver error with PHP

Post by azyk » Tue 09 Jan 2018 15:04

We have answered you by e-mail.

Post Reply