Re: Fun with unixODBC on Fedora

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Wed, 18 Jan 2012 01:54:16 +0000 (UTC)
Message-ID: <pan.2012.01.18.01.54.16_at_gmail.com>

On Tue, 17 Jan 2012 19:33:36 +0100, Gerard H. Pille wrote:

> Mladen Gogala wrote:

>> strace -e trace=file isql local scott tiger
>>
>> It turns out that ODBC was complaining about the libodbcinst.so.1
>> library:
>>
>>

> $ ls -l $(locate libodbcinst)
> -rwxr-xr-x 1 oracle dba 1724441 Sep 17 08:28
> /home/oracle/product/11.2.0/tg_1/dg4msql/driver/lib/libodbcinst.so
> -rw-r--r-- 1 root root 182856 Apr 4 2010 /usr/lib32/libodbcinst.a
> -rw-r--r-- 1 root root 968 Oct 1 16:41 /usr/lib32/libodbcinst.la
> lrwxrwxrwx 1 root root 20 Oct 1 16:41 /usr/lib32/libodbcinst.so
> -> libodbcinst.so.1.0.0 lrwxrwxrwx 1 root root 20 Oct 1 16:41
> /usr/lib32/libodbcinst.so.1 -> libodbcinst.so.1.0.0 -rw-r--r-- 1 root
> root 56424 Apr 4 2010 /usr/lib32/libodbcinst.so.1.0.0 -rw-r--r-- 1
> root root 844110 Apr 4 2010 /usr/lib32/libodbcinstQ.a -rw-r--r-- 1
> root root 976 Oct 1 16:41 /usr/lib32/libodbcinstQ.la lrwxrwxrwx 1
> root root 21 Oct 1 16:41 /usr/lib32/libodbcinstQ.so ->
> libodbcinstQ.so.1.0.0
>
> $ dpkg -S /usr/lib32/libodbcinst.so.1.0.0 ia32-libs:
> /usr/lib32/libodbcinst.so.1.0.0
>
>
> Can you find a ia32-libs for your F-distribution?

Yes, not a problem:

[root_at_medo tmp]# rpm -ql unixODBC

/etc/odbc.ini
/etc/odbcinst.ini
/usr/bin/dltest
/usr/bin/isql
/usr/bin/iusql
/usr/bin/odbc_config
/usr/bin/odbcinst
/usr/lib/libboundparam.so.2
/usr/lib/libboundparam.so.2.0.0
/usr/lib/libesoobS.so.2
/usr/lib/libesoobS.so.2.0.0
/usr/lib/libgtrtst.so.2
/usr/lib/libgtrtst.so.2.0.0
/usr/lib/libmimerS.so.2
/usr/lib/libmimerS.so.2.0.0
/usr/lib/libnn.so.2
/usr/lib/libnn.so.2.0.0
/usr/lib/libodbc.so
/usr/lib/libodbc.so.2
/usr/lib/libodbc.so.2.0.0
/usr/lib/libodbccr.so.2
/usr/lib/libodbccr.so.2.0.0
/usr/lib/libodbcdrvcfg1S.so.2
/usr/lib/libodbcdrvcfg1S.so.2.0.0
/usr/lib/libodbcdrvcfg2S.so.2
/usr/lib/libodbcdrvcfg2S.so.2.0.0
/usr/lib/libodbcinst.so
/usr/lib/libodbcinst.so.2
/usr/lib/libodbcinst.so.2.0.0
/usr/lib/libodbcminiS.so.2
/usr/lib/libodbcminiS.so.2.0.0
/usr/lib/libodbcmyS.so
/usr/lib/libodbcmyS.so.2
/usr/lib/libodbcmyS.so.2.0.0
/usr/lib/libodbcnnS.so.2
/usr/lib/libodbcnnS.so.2.0.0
/usr/lib/libodbcpsqlS.so
/usr/lib/libodbcpsqlS.so.2
/usr/lib/libodbcpsqlS.so.2.0.0
/usr/lib/libodbctxtS.so.2
/usr/lib/libodbctxtS.so.2.0.0
/usr/lib/liboplodbcS.so.2
/usr/lib/liboplodbcS.so.2.0.0
/usr/lib/liboraodbcS.so.2
/usr/lib/liboraodbcS.so.2.0.0
/usr/lib/libsapdbS.so.2
/usr/lib/libsapdbS.so.2.0.0
/usr/lib/libtdsS.so.2
/usr/lib/libtdsS.so.2.0.0
/usr/lib/libtemplate.so.2
/usr/lib/libtemplate.so.2.0.0
/usr/share/doc/unixODBC-2.2.14
/usr/share/doc/unixODBC-2.2.14/AUTHORS
/usr/share/doc/unixODBC-2.2.14/COPYING
/usr/share/doc/unixODBC-2.2.14/ChangeLog
/usr/share/doc/unixODBC-2.2.14/NEWS
/usr/share/doc/unixODBC-2.2.14/README
/usr/share/doc/unixODBC-2.2.14/doc
/usr/share/doc/unixODBC-2.2.14/doc/AdministratorManual
/usr/share/doc/unixODBC-2.2.14/doc/AdministratorManual/index.html
/usr/share/doc/unixODBC-2.2.14/doc/AdministratorManual/odbcinst.html
/usr/share/doc/unixODBC-2.2.14/doc/AdministratorManual/php3.html
/usr/share/doc/unixODBC-2.2.14/doc/AdministratorManual/unixODBC.gif
/usr/share/doc/unixODBC-2.2.14/doc/AdministratorManual/unixODBCsetup.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/close.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/conne.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/dsn.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/gloss.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/index.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/intro.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/navi.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/odbc.css
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/query.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/Tutorial/resul.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/index.html
/usr/share/doc/unixODBC-2.2.14/doc/ProgrammerManual/unixODBC.gif
/usr/share/doc/unixODBC-2.2.14/doc/UserManual
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/Figure1.gif
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/Figure2.gif
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/Figure3.gif
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/Figure4.gif
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/Figure6.gif
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/My.sql
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/StarOfficeDataGrid.gif
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/index.html
/usr/share/doc/unixODBC-2.2.14/doc/UserManual/unixODBC.gif
/usr/share/doc/unixODBC-2.2.14/doc/index.html
/usr/share/doc/unixODBC-2.2.14/doc/lst
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure.vsd
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure2.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure2.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure3.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure3.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure4.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure4.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure5.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure5.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure6.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure6.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure7.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure7.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure8.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure8.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure9.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/InternalStructure9.html
/usr/share/doc/unixODBC-2.2.14/doc/lst/back.gif
/usr/share/doc/unixODBC-2.2.14/doc/lst/next.gif
/usr/share/doc/unixODBC-2.2.14/doc/smallbook.gif
/usr/share/doc/unixODBC-2.2.14/doc/unixODBC.gif

[root_at_medo tmp]#

I am using 32 bit architecture because I have only 4G RAM and I don't want to waste it needlessly. Libraries are there, only the versions are incorrect. It's nothing that a symbolic link cannot fix. On MS-Windows, ODBC drivers work out of the box. Linux keeps my knowledge of methodology and debugging tools current, which is a good thing.

-- 
http://mgogala.byethost5.com

Received on Tue Jan 17 2012 - 19:54:16 CST