Vertica 32bit odbc client on Linux

Hi Vertica Users,

Would like to ask for assistance regarding the Vertica 32bit client driver. We are connecting our Cognos Linux server to the Vertica database as data source.

As of now 64bit client can connect but 32bit client is not able to connect. Cognos only supports 32bit odbc client for Vertica. Would like to know why my 32bit client is not able to connect.

Thanks,
Ervin

Tagged:

Comments

  • skeswaniskeswani - Select Field - Employee

    I went to the vertica download site. The tarball has both 32 and 64 bit odbc clients

    9.2.x (TAR) ODBC, JDBC, Python, and vsql Package contains both 32 and 64-Bit versions

  • skeswaniskeswani - Select Field - Employee
    edited August 2019

    skeswani@skeswani-laptop:~/Downloads/opt/vertica$ file lib/libverticaodbc.so
    lib/libverticaodbc.so: ELF 32-bit LSB shared object, Intel 80386, version 1 (SYSV), >dynamically linked, > BuildID[sha1]=7b60501cb112b0f86440e7cd23d0e8fda1411872, with debug_info, not stripped
    skeswani@skeswani-laptop:~/Downloads/opt/vertica$ file lib64/libverticaodbc.so
    lib64/libverticaodbc.so: ELF 64-bit LSB shared object, x86-64, version 1 (SYSV), dynamically linked, BuildID[sha1]=8254674b1641b83cfa49c28e3bfd05decc8a7a41, with debug_info, not stripped

  • Hi @skeswani ,

    Yes I was able to see the 32bit and 64bit drivers. I can connect using 64bit but the 32bit client driver is not able to connect.

    total 7848
    drwxr-xr-x 2 1016 200 4096 Jul 23 2018 ./
    drwxr-xr-x 9 1016 200 4096 Jul 23 2018 ../
    -rwxr-xr-x 1 1016 200 4201960 Jul 23 2018 vsql*
    -rwxr-xr-x 1 1016 200 3822580 Jul 23 2018 vsql32*
    cognos-sa@cognos11:~/opt/vertica/bin$ pwd
    /home/cognos-sa/opt/vertica/bin

    64bit client
    cognos-sa@cognos11:~/opt/vertica/bin$ /home/cognos-sa/opt/vertica/bin/vsql -h 192.168.16.8 -U dbadmin
    Password:
    Welcome to vsql, the Vertica Analytic Database interactive terminal.

    Type: \h or \? for help with vsql commands
    \g or terminate with semicolon to execute query
    \q to quit

    dbadmin=>

    32bit client

    cognos-sa@cognos11:~/opt/vertica/bin$ /home/cognos-sa/opt/vertica/bin/vsql32 -h 192.168.16.8 -U dbadmin
    -bash: /home/cognos-sa/opt/vertica/bin/vsql32: No such file or directory
    cognos-sa@cognos11:~/opt/vertica/bin$

    ISQL
    cognos-sa@cognos11:~/opt/vertica/bin$ isql -v verticadb32
    [IM002][unixODBC][Driver Manager]Data source name not found and no default driver specified
    [ISQL]ERROR: Could not SQLConnect
    cognos-sa@cognos11:~/opt/vertica/bin$

    This is my odbc.ini file

    cognos-sa@cognos11:~$ cat odbc.ini
    [ODBC Data Sources]

    VerticaDSN = "verticadb32"

    [verticadb32]
    Description = Vmart Database
    Driver = /home/cognos-sa/opt/vertica/lib/libverticaodbc.so
    Database = nexusbi
    Servername = 192.168.16.8
    UID = dbadmin
    PWD = *******
    Port = 5433
    ConnSettings =
    AutoCommit = 0
    Locale = en_US@collation=binary

    Thanks,
    Ervin De Guzman

  • Bryan_HBryan_H Vertica Employee Administrator

    I'm not sure that we ship a 32-bit version of vsql. However, ODBC driver will only work with applications compiled to same architecture, that is, 32-bit ODBC with only work with 32-bit isql/Cognos/etc. Most Linux distros only include 64-bit builds now, see for example:
    $ file /bin/isql
    /bin/isql: ELF 64-bit LSB executable, x86-64
    You would need to install the 32-bit version of unixODBC in order to test the 32-bit driver.

  • skeswaniskeswani - Select Field - Employee
    edited August 2019

    The linux 32 bit vsql is certainly available in the client tarball

    skeswani@skeswani-laptop:~/Downloads$ file ./opt/vertica/bin/vsql
    ./opt/vertica/bin/vsql: ELF 64-bit LSB executable, x86-64, version 1 (SYSV), dynamically linked, interpreter /lib64/l, for GNU/Linux 2.6.18, BuildID[sha1]=68d2f7ef9fc4c7743838fb0e0fcf5c350f2cd6f4, not stripped
    skeswani@skeswani-laptop:~/Downloads$ file ./opt/vertica/bin/vsql32
    ./opt/vertica/bin/vsql32: ELF 32-bit LSB executable, Intel 80386, version 1 (SYSV), dynamically linked, interpreter /lib/ld-, for GNU/Linux 2.6.18, BuildID[sha1]=fcaf52eba8be0b4ed2e6c56ca9eac8fac8ec519f, not stripped

    skeswani@skeswani-laptop:~/Downloads$ ./opt/vertica/bin/vsql32
    Welcome to vsql, the Vertica Analytic Database interactive terminal.

    Type: \h or \? for help with vsql commands
    \g or terminate with semicolon to execute query
    \q to quit

    skeswani=>

  • Hi Skeswani,

    I have the vsql32. But when i run the executable file, it is not located.

    cognos-sa@cognos11:~/opt/vertica/bin$ ./vsql32
    -bash: ./vsql32: No such file or directory
    cognos-sa@cognos11:~/opt/vertica/bin$

    cognos-sa@cognos11:~$ cd opt/vertica/bin
    cognos-sa@cognos11:~/opt/vertica/bin$ ll
    total 7848
    drwxr-xr-x 2 1016 200 4096 Jul 23 2018 ./
    drwxr-xr-x 9 1016 200 4096 Jul 23 2018 ../
    -rwxr-xr-x 1 1016 200 4201960 Jul 23 2018 vsql*
    -rwxr-xr-x 1 1016 200 3822580 Jul 23 2018 vsql32*
    cognos-sa@cognos11:~/opt/vertica/bin$

    do you have any idea why it was not located even the file is visible.

    Thanks,
    Ervin De Guzman

  • Hi Bryan,

    I have installed /unixODBC-2.3.7.

    cognos-sa@cognos11:/bin$ /home/cognos-sa/unixODBC/unixODBC-2.3.7/exe/isql -v verticadb32
    [IM002][unixODBC][Driver Manager]Data source name not found and no default driver specified
    [ISQL]ERROR: Could not SQLConnect
    cognos-sa@cognos11:/bin$

    When I am trying to run the isql it gets an error that the data source name is not found even i have configured the odbc.ini and vertica.ini files.

    do you have any idea why i got this error even i have configured the required configurations?

    Thanks,
    Ervin De Guzman

  • skeswaniskeswani - Select Field - Employee

    This is strange
    -bash: ./vsql32: No such file or directory

    can you do
    file ./vsql32
    and see what you get. The failure is not because the client is not working, its because its not getting executed. Do you have vertica support. If you open a case, someone can assist you with this.

  • Hi Skeswani,

    my.vertica.com is not working any more. Do you have any idea where i can file support now?

    Thanks,
    Ervin De Guzman

  • SruthiASruthiA Vertica Employee Administrator

    Please use the below link to open a support case with Vertica. Click on Service Requests and login to support portal.

    https://softwaresupport.softwaregrp.com/

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file