Enable ODBC tracing on Linux

To enable tracing for all ODBC applications or specifically for Devart ODBC Driver for Oracle, edit the odbcinst.ini file.

Enable tracing for all ODBC applications

1. Open the odbcinst.ini file.

By default, the file is located at /etc/odbcinst.ini.

2. Under the [ODBC] section, add the following options:

  • Trace - Enables tracing when set to Yes.
  • TraceFile - The full path to the log file. For example: /home/jordansanders/odbc_trace.log.
[ODBC]
Trace = Yes
TraceFile = <filepath>

Enable tracing using driver for all ODBC apps

3. Once the issue is reproduced, disable tracing by setting Trace to No in the odbcinst.ini file.

Enable tracing for Devart ODBC Driver for Oracle

1. Open the odbcinst.ini file.

By default, the file is located at /etc/odbcinst.ini.

2. Under the [Devart ODBC Driver for Oracle] section, add the following options:

  • LogFileName - The full path to the log file. For example: /home/jordansanders/devart_sf.log.
  • Logging - Enables tracing when set to True.
[Devart ODBC Driver for Oracle]   
LogFileName = <filepath>   
Logging = True

Enable tracing using driver on Linux

3. Once the issue is reproduced, disable tracing by setting Logging to False in the odbcinst.ini file.