Enabling ODBC debug logging (Windows)

ODBC debug logging is a method of tracking system activity. By default, debug logging is disabled because enabling it can degrade performance.


  1. Open the ODBC Data Source Administrator window by clicking Start > Settings > Administrative Tools > Data Sources (ODBC).
  2. In the ODBC Data Source Administrator window, click the System DSN tab.
  3. Select the NZSQL system data source and click Configure.
  4. Click the Driver Options tab.
  5. Select the Enable Debug Logging check box.
  6. Specify the log file path where the ODBC log file is saved.
    The log file name is nzodbc_userpid.log.
  7. Save your settings by clicking OK.

What to do next

Disable logging after troubleshooting because logging can degrade performance.