Re: [Firebird-odbc-devel] OdbcJdbc on linux

[Vladimir T. <pr...@hm...>]

Hello,

> SQL> select sname from supplier where sname like 'S%' order by sname=20
> descending;
> SQLRowCount returns 14
> 14 rows fetched
> SQL> show tables;
> Aborted
>
    I am using ASP Linux 7.3
see
     SQL> select * from country
+----------------+-----------+
| COUNTRY        | CURRENCY  |
+----------------+-----------+
| USA            | Dollar    |
| England        | Pound     |
...
| Fiji           | FDollar   |
+----------------+-----------+
14 rows affected
14 rows returned
SQL> q
[root@localhost !ODBCSNAPSHOT]# [root@localhost lib]# ldd IscDbc.so
        libcrypt.so.1 => /lib/libcrypt.so.1 (0x001a6000)
        libdl.so.2 => /lib/libdl.so.2 (0x001eb000)
        libgds.so => /usr/lib/libgds.so (0x001ee000)
        libstdc++-libc6.2-2.so.3 => /usr/lib/libstdc++-libc6.2-2.so.3
(0x00360000)
        libm.so.6 => /lib/i686/libm.so.6 (0x003a3000)
        libc.so.6 => /lib/i686/libc.so.6 (0x42000000)
        /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x80000000)

Others of ODBC drive work?

> I don't see any reference to the unixODBC libraries

    look OdbcJdbc\Builds\Gcc.lin\readme.linux :-)

==================
    The odbc-config-files in /etc shoud look like this:

odbcinst.ini:
--------------------
[Firebird]
Description     = InterBase/Firebird ODBC Driver
Driver          = /usr/lib/OdbcJdbc.so  <---------- reference to the
unixODBC libraries!!!
Setup           = /usr/lib/OdbcJdbcS.so
...
=============================

--
Best regards,
Vladimir Tsvigun