Required ODBC Driver Configuration Settings for Linux and UNIX

In addition to DSN settings, Vertica provides additional ODBC client driver configuration parameters. These settings control the following:

  • The text encoding used by the driver manager (for example, UTF-8 or UTF-16).
  • The location of the directory containing the Vertica ODBC driver's error message files.
  • Whether and how the ODBC driver logs messages.

On Linux and UNIX platforms, you must provide these additional settings manually so that the ODBC driver can function properly. To do so, edit the vertica.ini file to supply the necessary additional configuration settings. You specify where the ODBC driver can find the vertica.ini file using an environment variable named VERTICAINI. See Setting ODBC Driver Settings on Linux and UNIX-Like Platforms.