Originally posted by: AnuRaja

Hi,

I am trying to configure unixODBC on my AIX 7.1 server for connecting SAP HANA Database. 

Installed unixODBC  from AIX toolbox site using yum. 

But it is not working out, getting error like below...I checked all things and looks good. Pls help how to check further. 

Does unixODBC (from AIX toolbox) support 64 bit drivers ?

------------------------------------------------------------------------------------------------------------------------------------------------------

root@ddb2:/opt/freeware/etc>isql -v SD0

[01000][unixODBC][Driver Manager]Can't open lib '/usr/sap/hdbclient/libodbcHDB.so' : file not found

---------------------------------------------------------------------------------------------------------------------------------------------------------

/>oslevel -s
7100-04-03-1642

-----------------------------------------------------------------------------------------------------------------------------------------

root@ddb2:/opt/freeware/etc>ls -l /usr/sap/hdbclient/libodbcHDB.so
-r-xr-xr-x    1 root     system     45288207 May  2 10:51 /usr/sap/hdbclient/libodbcHDB.so

---------------------------------------------------------------------------------------------------------------------------------------
root@cddb2:/opt/freeware/etc>ldd /usr/sap/hdbclient/libodbcHDB.so
/usr/sap/hdbclient/libodbcHDB.so needs:
         /usr/lib/libpthread.a(shr_xpg5_64.o)
         /usr/lib/libC.a(shr_64.o)
         /usr/lib/libC.a(shr2_64.o)
         /usr/lib/libC.a(shr3_64.o)
         /usr/lib/libC.a(ansi_64.o)
         /usr/lib/libc.a(shr_64.o)
         /unix
         /usr/lib/libC.a(shrcore_64.o)
         /usr/lib/libC.a(ansicore_64.o)
         /usr/lib/libcrypt.a(shr_64.o)

-------------------------------------------------------------------------------------------------------------------------------------------------------
root@ddb2:/opt/freeware/etc>file /usr/sap/hdbclient/libodbcHDB.so
/usr/sap/hdbclient/libodbcHDB.so: 64-bit XCOFF executable or object module not stripped
-----------------------------------------------------------------------------------------------------------------------------------------------
root@ddb2:/opt/freeware/etc>file /usr/bin/isql
/usr/bin/isql: executable (RISC System/6000) or object module
root@ddb2:/opt/freeware/etc>

----------------------------------------------------------------------------------------------------------------------------
root@ddb2:/opt/freeware/etc>odbcinst -j
unixODBC 2.3.5
DRIVERS............: /opt/freeware/etc/odbcinst.ini
SYSTEM DATA SOURCES: /opt/freeware/etc/odbc.ini
FILE DATA SOURCES..: /opt/freeware/etc/ODBCDataSources
USER DATA SOURCES..: //.odbc.ini
SQLULEN Size.......: 4
SQLLEN Size........: 4
SQLSETPOSIROW Size.: 2

-----------------------------------------------------------------------------------------------------------------------

root@ddb2:/opt/freeware/etc>echo $LIBPATH
:/usr/lib64:/usr/sap/hdbclient:/opt/freeware/lib64
root@ddb2:/opt/freeware/etc>

---------------------------------------------------------------------------------------------------------------------

Originally posted by: AyappanP

Use the 64bit binary "/usr/bin/isql_64". We will make it as the default one in the future releases.

Originally posted by: AnuRaja

Thanks Ayappan...

It works....