unixODBC giving error while running isql [Vertica]

Question

Hi I have configured the DSN settings for vertica in Ubuntu 10.10 32 bit version machine. The settings are all fine and I have cross checked them.

Here is my odbc.ini file:

 [VerticaDSN]
  Description = VerticaDSN ODBC driver
  Driver = /opt/vertica/lib/libverticaodbc_unixodbc.so
  Servername = myservername
  Database = mydbname
  Port = 5433
  UserName = myuname
  Password = *******
  Locale = en_US

Similarly I have a odbcinst.ini file.

when I run the command: isql -v VerticaDSN I get the following error:

 [S1000][unixODBC][DSI] The error message NoSQLGetPrivateProfileString could not be found    in the en-US locale. Check that /en-US/ODBCMessages.xml exists.
[ISQL]ERROR: Could not SQLConnect.

I have tried everything but I am not able to decipher this error.

Any help will be greatly appreciated.

Answer 1

You may be missing the Driver configuration section. Edit or create the file /etc/vertica.ini with the following content:

[Driver]
DriverManagerEncoding=UTF-16
ODBCInstLib=/usr/lib64/libodbcinst.so
ErrorMessagesPath=/opt/vertica/lib64
LogLevel=4
LogPath=/tmp

More information can be found in the Vertica Programmer's Guide in the section "Location of the Additional Driver Settings".