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
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$
Code: Select all
-bash-4.2$ odbcinst -q -d
[Vertica]
Ideas anyone?
Thanks
Tomer