ODBC Driver for PostgreSQL

Enabling ODBC Tracing - ODBC Driver for PostgreSQL



Creating an ODBC Trace Log on Windows

When you start or stop tracing in the 64-bit ODBC Administrator, the tracing is also enabled or disabled in the 32-bit ODBC Administator, and vice versa.

If the ODBC client application you need to trace runs under Local System account or any other user login than your own, select Machine-Wide tracing for all user identities. For example, this option may be necessary for SSMS.

To generate a trace file using ODBC Source Administrator on Windows, follow the steps below:

  1. Type odbc into the Search box on your Windows 10 taskbar (in earlier versions of Windows, select ODBC Administrator (Start > Settings > Control Panel > Administrative Tools) and run the ODBC Data Sources application of the needed bitness.
  2. Select the Tracing tab.
  3. If necessary, change the default Log File Path. Make sure that the path is writable by the application, then select Apply.
  4. Select Start Tracing Now.
  5. Restart all application processes.
  6. Select Test Connection in the DSN settings to make sure the driver is able to connect.
  7. Reproduce the issue.
  8. Select Stop Tracing Now on the Tracing tab.
  9. Send us the obtained log file (for example, devart.log).

Creating an ODBC Trace Log on macOS

To enable the trace option on macOS, use the Tracing tab within ODBC Administrator.

  1. Open the ODBC Administrator.
  2. Select the Tracing tab.
  3. If necessary, change the default Log file path.
  4. Select All the time in the When to trace option.

Creating an ODBC Trace Log on Linux

To trace your application's ODBC behavior on Linux, set the Trace and TraceFile keyword/value pairs in the [ODBC] section of the odbcinst.ini file (/etc/odbcinst.ini), for example:

[ODBC]
Trace=Yes
TraceFile=/home/test/devart.log

Make sure to disable logging after obtaining a log file since it affects the read/write speed.

© 2015-2021 Devart. All Rights Reserved. Request Support ODBC Forum Provide Feedback