Vertica 32bit odbc client on Linux

ervinDG22

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

skeswani

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

skeswani

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

ervinDG22

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_H

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.

skeswani

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=>

ervinDG22

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

ervinDG22

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

skeswani

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.

ervinDG22

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

SruthiA

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/