[mdb-dev] Error at Line : syntax error near exec

[Szilagyi S. <szi...@in...>]

Dear All!

I use unixODBC with mdbtools
unixODBC works good, mdbtools works good BUT together...
So what can I do?

---unixODBC& MDBTOOLS---
isql -v Cats myuser mypassword
[...]
SQL> help
Error at Line : syntax error near exec
[08001][unixODBC]Couldn't parse SQL

[ISQL]ERROR: Could not SQLTables

---mdb-tables---
$ mdb-tables /home/user/Acc.mdb
Account Types Accounts Reports Transactions

----with MySQL---
isql -v MySQL1 myuser mypassword
works great* with MySQL
[...]
*works great mean SQL>help gives the table names back


#################################
INI:
/etc/odbc.ini
--->8----
[Cats]
Description = Microsoft Access Database of Dogs
Driver = MDBToolsODBC
Trace = No
TraceFile =
Database = /home/user/Acc.mdb
Servername = 192.168.2.234
UserName = myuser
Password = mypassword
Port = 5432

[MySQL1]
Description = MySQL test database
Driver = MySQL
Trace = No
TraceFile =
Servername = 192.168.2.234
UserName = myuser
Password = mypassword
PORT = 3306
Database = test
--->8---

/etc/odbcinst.ini
--->8---
[MySQL]
Description     = Myodbc driver for MySQL
Driver          = /usr/local/lib/libmyodbc3.so
Setup           = /usr/local/lib/libmyodbc3S.so

[Default]
Driver          = /usr/local/lib/libmdbodbc.so.0
FileUsage               = 1
UsageCount              = 2

[MDBToolsODBC]
Description             = MDB Tools ODBC drivers
Driver          = /usr/local/lib/libmdbodbc.so.0
Setup           =
FileUsage               = 1
CPTimeout               =
CPReuse         =
Driver          = /usr/lib/libmyodbc3.so
UsageCount              = 1
--->8---

CONFIGURED:
=====================================================
/mdbtools-0.6pre1$ ./configure --with-unixodbc=/usr/local
make; su -c "make install"
[...]
Libraries have been installed in:
   /usr/local/lib
====================================================
/unixODBC-2.2.11$ ./configure --sysconfdir=/etc --enable-gui=no 
--enable-shared --with-odbc --with-msql-lib
make; su -c "make install"
[...]
Libraries have been installed in:
   /usr/local/lib
====================================================

TABLE SOURCE
kexi-project.org/download/tests/msa_templates.tar.gz  ~5MB
there is 'Accounts ledger.mdb' in it