The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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 Employee 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 Employee Employee
    edited August 14

    [email protected]:~/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
    [email protected]:~/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*
    [email protected]:~/opt/vertica/bin$ pwd
    /home/cognos-sa/opt/vertica/bin

    64bit client
    [email protected]:~/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

    [email protected]:~/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
    [email protected]:~/opt/vertica/bin$

    ISQL
    [email protected]:~/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
    [email protected]:~/opt/vertica/bin$

    This is my odbc.ini file

    [email protected]:~$ 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 = [email protected]=binary

    Thanks,
    Ervin De Guzman

  • Bryan_HBryan_H Employee Employee

    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 Employee Employee
    edited August 9

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

    [email protected]:~/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
    [email protected]:~/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

    [email protected]:~/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.

    [email protected]:~/opt/vertica/bin$ ./vsql32
    -bash: ./vsql32: No such file or directory
    [email protected]:~/opt/vertica/bin$

    [email protected]:~$ cd opt/vertica/bin
    [email protected]:~/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*
    [email protected]:~/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.

    [email protected]:/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
    [email protected]:/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 Employee 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 Employee Employee

    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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.