[mdb-dev] ODBC parse error

[<tro...@mu...>]

I downloaded and installed the RPMs vers. 0.5-1 following the instructions =
on=20
the Installation Guide.

The first problem I found was a dependency problem during the installation =
of=20
"mdbtools-0.5-1.i386.rpm". Although the library "libreadline.so.4" was=20
installed in the directory "/lib", I got the error message "libreadline.so.=
4=20
is needed by mdbtools-0.5-1". I even upgraded from "readline-4.3-4mdk" to=20
"libreadline4-4.3-7mdk", but I got the same error. So, in the end, I=20
installed the RPM with the "--nodeps" option.

I checked the installation making an SQL query with "mdb-sql", which worked=
=20
fine. Then I had no trouble at all installing "mdbtools-devel-0.5-1.i386.rp=
m"=20
and "mdbtools-odbc-0.5-1.i386.rpm". I then configured my "odbc.ini" file.

The second and main problem appeared when testing the ODBC connection. I=20
always got a "parse error". For example:

        [jose@localhost jose]$ isql biblio
        +---------------------------------------+
        | Connected!                            |
        |                                       |
        | sql-statement                         |
        | help [tablename]                      |
        | quit                                  |
        |                                       |
        +---------------------------------------+
        SQL> select version();
        Error at Line : parse error near (
        [ISQL]ERROR: Could not SQLExecute
        SQL>

I get similar errors when trying to access the database through ODBC from=20
other applications, such as DataManager or OpenOffice.org. I also tried=20
building and installing the source, but I still had the same problem with t=
he=20
ODBC driver. I also upgraded the unixODBC packages.

My system has a Pentium III at 600Mz, 128MB RAM and Mandrake 9.1.

Any ideas?=20
Thanks a lot,
Jos=E9 Troncoso