Error at Line : syntax error near exec

Szilagyi Szilveszter <[email protected]>
Newsgroups gmane.comp.db.mdb-tools.devel
Message-ID <[email protected]>
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



-------------------------------------------------------
All the advantages of Linux Managed Hosting--Without the Cost and Risk!
Fully trained technicians. The highest number of Red Hat certifications in
the hosting industry. Fanatical Support. Click to learn more
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=107521&bid=248729&dat=121642
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.