AIX Open Source

AIX Open Source

Share your experiences and connect with fellow developers to discover how to build and manage open source software for the AIX operating system

 View Only
Back to discussions
Expand all | Collapse all

Does unixODBC supprt 64 bit Drivers ?

  • 1.  Does unixODBC supprt 64 bit Drivers ?

    Posted Fri June 15, 2018 06:37 AM

    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>

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

     

     

     

     



  • 2.  Re: Does unixODBC supprt 64 bit Drivers ?

    Posted Fri June 15, 2018 07:20 AM

    Originally posted by: AyappanP


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



  • 3.  Re: Does unixODBC supprt 64 bit Drivers ?

    Posted Fri June 15, 2018 08:06 AM

    Originally posted by: AnuRaja


    Thanks Ayappan...

    It works....