Configuring Logging Options

To help troubleshoot issues, you can enable logging in the connector.

Important:

  • Only enable logging long enough to capture an issue. Logging decreases performance and can consume a large quantity of disk space.
  • The settings for logging apply to every connection that uses the Simba Couchbase ODBC Driver, so make sure to disable the feature after you are done using it.

Logging is configured through connector-wide settings in the simba.couchbaseodbc.ini file, which apply to all connections that use the connector.

To enable logging:

  1. Open the simba.couchbaseodbc.ini configuration file in a text editor.
  2. To specify the level of information to include in log files, set the LogLevel property to one of the following numbers:
  3. LogLevel Value Description

    0

    Disables all logging.

    1

    Logs severe error events that lead the connector to abort.

    2

    Logs error events that might allow the connector to continue running.

    3

    Logs events that might result in an error if action is not taken.

    4

    Logs general information that describes the progress of the connector.

    5

    Logs detailed information that is useful for debugging the connector.

    6

    Logs all connector activity.

  4. Set the LogPath key to the full path to the folder where you want to save log files.
  5. Set the LogFileCount key to the maximum number of log files to keep.
  6. Note:

    After the maximum number of log files is reached, each time an additional file is created, the connector deletes the oldest log file.

  7. Set the LogFileSize key to the maximum size of each log file in bytes.
  8. Note:

    After the maximum file size is reached, the connector creates a new file and continues logging.

  9. Save the simba.couchbaseodbc.ini configuration file.
  10. Restart your ODBC application to make sure that the new settings take effect.

The Simba Couchbase ODBC Driver produces the following log files at the location you specify using the LogPath key:

  • A simbacouchbaseodbcdriver.log file that logs connector activity that is not specific to a connection.
  • A simbacouchbaseodbcdriver_connection_[Number].log file for each connection made to the database, where [Number] is a number that identifies each log file. This file logs connector activity that is specific to the connection.

To disable logging:

  1. Open the simba.couchbaseodbc.ini configuration file in a text editor.
  2. Set the LogLevel key to 0.
  3. Save the simba.couchbaseodbc.ini configuration file.
  4. Restart your ODBC application to make sure that the new settings take effect.