Enabling ODBC Tracing - ODBC Driver for PostgreSQL
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:
odbcinto 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 Sourcesapplication of the needed bitness.
Log File Path. Make sure that the path is writable by the application, then select
Start Tracing Now.
Test Connectionin the DSN settings to make sure the driver is able to connect.
Stop Tracing Nowon the
To enable the trace option on macOS, use the Tracing tab within ODBC Administrator.
Log file path.
All the timein the
When to traceoption.
To trace your application's ODBC behavior on Linux, set the
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.