The CData ODBC Driver targeting Linux distributions is based off of JNI. The JNI layer has its own separate logging implementation which differs from the standard driver logs. It allows you to capture more detailed information on the ODBC Wrapper layer for advanced troubleshooting when dealing with errors of this nature.
To enable this separate logging, you will need to set the CDATA_ODBC_LOG environment variable.
If you would like to log to a specific location, say /var/odbcwrapper.log, you can follow the listed instructions:
-
In your Linux distro run the terminal
-
Use the ‘export’ command to set the CDATA_ODBC_LOG environment variable
-
$export CDATA_ODBC_LOG=”FILE:///var/odbcwrapper.log|DEBUG"
After the Pipe character you can specify the level of detail you require in the desired log.
Possible values are: FATAL, ERROR, WARNING, INFO, DEBUG.
In case there is trouble generating the log check for write permissions in the directory you chose to write the log into.
