I'm in trouble with using mdbtools and unixODBC. I'm trying to read a mdb-Accessdatabase with php on my Raspberry Pi, but get an Error like this:
"Warning: odbc_exec(): SQL error: [unixODBC]Couldn't parse SQL , SQL state 08001 in SQLExecDirect" as soon as I use a SQL statement with more than SELECT, for example ORDER BY or INNER JOIN in it...
This means "SELECT * FROM table" works perfectly, but "SELECT * FROM table ORDER BY column" produces this error.
Hey,
I'm in trouble with using mdbtools and unixODBC. I'm trying to read a mdb-Accessdatabase with php on my Raspberry Pi, but get an Error like this:
"Warning: odbc_exec(): SQL error: [unixODBC]Couldn't parse SQL , SQL state 08001 in SQLExecDirect" as soon as I use a SQL statement with more than SELECT, for example ORDER BY or INNER JOIN in it...
This means "SELECT * FROM table" works perfectly, but "SELECT * FROM table ORDER BY column" produces this error.
Someone had the same problem in 2005, you can read this in the unixODBC forum here:
http://mailman.unixodbc.org/pipermail/unixodbc-support/2005-January/000353.html
What are you thinking, is that a problem from unixODBC or from the ODBCdriver from mdbtools?
If desired I can post the configuration of unixODBC.
Has somebody successfully read a Accessdatabase with php on a Linuxserver?
Thanks in advance
Greetings from Germany
Dominik