Additional parameter settings

The following parameters can be set for the Vertica client drivers.

Logging settings

These parameters control how messages between the client and server are logged. None of these settings are required. If they are not set, then the client library does not log any messages. They apply to both ADO.NET and ODBC.

• LogLevel—The severity of messages that are logged between the client and the server. The valid values are:

  • 0—No logging

  • 1—Fatal errors

  • 2—Errors

  • 3—Warnings

  • 4—Info

  • 5—Debug

  • 6—Trace (all messages)

  The value you specify for this setting sets the minimum severity for a message to be logged. For example, setting LogLevel to 3 means that the client driver logs all warnings, errors, and fatal errors.

  Note

  On a Windows client, you have the option of directing ODBC or OLE DB log entries to Event Tracing for Windows (ETW). Once set, ODBC log entries appear in the Windows Event Viewer. See Diverting ODBC log entries to ETW. for ODBC, or Diverting OLE DB log entries to ETW for OLE DB.

• LogPath—The absolute path of a directory to store log files . For example: /var/log/verticaodbc

• LogNamespace—Limits logging to messages generated by certain objects in the client driver.

ODBC-specific settings

The following settings are used only by the Vertica ODBC client driver.

• DriverManagerEncoding—The UTF encoding standard that the driver manager uses. This setting needs to match the encoding the driver manager expects. The available values for this setting are:

  • UTF-8

  • UTF-16 (usually used by unixODBC)

  • UTF-32 (usually used by iODBC)

  See the documentation for your driver manager to find the correct value for this setting.

  Note

  While both UTF-16 and UTF-8 are valid settings for DataDirect, Vertica recommends that you set the DataDirect driver manager encoding to UTF-16.

  If you do not set this parameter, the ODBC driver defaults to the value shown in the following table. If your driver manager uses a different encoding, you must set this value for the ODBC driver to be able to work.

  Client Platform	Default Encoding
  Linux 32-bit	UTF-32
  Linux 64-bit	UTF-32
  Linux Itanium 64-bit	UTF-32
  OS X	UTF-32
  Windows 32-bit	UTF-16
  Windows 64-bit	UTF-16

• ErrorMessagesPath—The absolute path to the parent directory that contains the Vertica client driver's localized error message files. These files are usually stored in the same directory as the Vertica ODBC driver files.

• ODBCInstLib—The absolute path to the file containing the ODBC installer library (ODBCInst). This setting is required if the directory containing this library is not set in the LD_LIBRARY_PATH or LIB_PATH environment variables. The library files for the major driver manager are:

• UnixODBC: libodbcinst.so

• iODBC: libiodbcinst.so (libiodbcinst.2.dylib on OS X)

• DataDirect: libodbcinst.so

ADO.NET-specific settings

This setting applies only to the ADO.NET client driver:

C#PreloadLogging—Tells the Vertica ADO.NET driver to begin logging as soon as possible, before the driver has fully loaded itself. Normally, logging only starts after the driver has fully loaded. Valid values for this setting are:

• 0—Do not start logging before the driver has loaded.

• 1—Start logging as soon as possible.