New server, new error...

Moderator: NorbertKrupa

Post Reply
tomersagi
Newbie
Newbie
Posts: 5
Joined: Wed Apr 15, 2015 9:14 am

New server, new error...

Post by tomersagi » Mon Jun 15, 2015 4:13 pm

Hi,
I moved my client application to a new server and again facing issues connecting using ODBC:

Code: Select all

-bash-4.2$ isql -v Vertica
[S1000][unixODBC][Vertica][ODBC] (11560) Unable to locate SQLGetPrivateProfileString function.
[ISQL]ERROR: Could not SQLConnect
Here are my config files:

Code: Select all

-bash-4.2$ cat /etc/odbc.ini
[ODBC Data Sources]
Vertica = "ALP2 DB"
[Vertica]
Description = HP Vertica DSN ODBC driver for ALP2
Driver = /opt/vertica/lib64/libverticaodbc.so.7.1.1
Database = ALP2
Servername = vertica-ha02.labs.hpl.hp.com
UserName = ***
Password = ***
Port = 5433
ErrorMessagesPath=/opt/vertica/lib64/en-US
LogLevel=4
LogPath=/tmp

-bash-4.2$ cat /etc/odbcinst.ini
[Vertica]
Description = HP Labs VMart database
Driver = /opt/vertica/lib64/libverticaodbc.so.7.1.1
[ODBC]
Threading = 1
-bash-4.2$ cat /etc/vertica.ini
[Driver]
DriverManagerEncoding=UTF-16
ODBCInstLib=/usr/lib64/libodbc.so.2.0.0
ErrorMessagesPath=/opt/vertica/lib64
LogLevel=4
LogPath=/tmp
-bash-4.2$
VERTICAINI is set and seems that unixodbc is finding the DSN:

Code: Select all

-bash-4.2$ odbcinst -q -d
[Vertica]

Ideas anyone?
Thanks
Tomer

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: New server, new error...

Post by NorbertKrupa » Mon Jun 15, 2015 4:22 pm

Did you get the latest driver? Did you change Vertica versions?
Checkout vertica.tips for more Vertica resources.

tomersagi
Newbie
Newbie
Posts: 5
Joined: Wed Apr 15, 2015 9:14 am

Re: New server, new error...

Post by tomersagi » Mon Jun 15, 2015 11:36 pm

Just changed OS from Ubuntu 15 to RHEL 7. Other than that, no changes.

Post Reply

Return to “ODBC”