[unixODBC-support] Unable to get isql working on AIX 7.1

Sundar Mahadevan sundarmahadevan82 at gmail.com
Thu Jan 21 20:51:24 GMT 2016

Hi All,
I am trying to setup oracle database to connect to db2 to pull data using
dblink using oracle dg4odbc that comes as part of enterprise edition. My
oracle database is on 11gR204 hosted on AIX 7.1 while DB2 is on version
10.5 hosted on RHEL 5.11. I am an oracle dba with limited systems
administration knowledge looking for assistance in getting my setup
working. I installed db2 client which comes with odbc driver and i also
installed unix odbc driver manager (both of them installed as OS user
dbclient). When i try to execute isql, i am getting the error below. Any
help is greatly appreciated.

dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> ls -ld
drwxrwxr-x    7 oracle   dba             256 Jan 21 14:01

I have the following in my .profile.

export LIBPATH=$LIBPATH:/home/oracle/bin/UnixOdbcDriverManager/lib

dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> which isql
dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)> isql
exec(): 0509-036 Cannot load program isql because of the following errors:
        0509-022 Cannot load module
        0509-150   Dependent module /usr/lib/libiconv.a(libiconv.so.2)
could not be loaded.
        0509-152   Member libiconv.so.2 is not found in archive
        0509-022 Cannot load module isql.
        0509-150   Dependent module
/home/oracle/bin/UnixOdbcDriverManager/lib/libodbc.a(libodbc.so.2) could
not be loaded.
        0509-022 Cannot load module .
dbclient at omsa4103:SUPCON(/u13/app/DBCLIENT)>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.unixodbc.org/pipermail/unixodbc-support/attachments/20160121/03caca91/attachment.html>

More information about the unixODBC-support mailing list