QVConnect logging for troubleshooting ODBC/OLEDB
Article Number: 000040748 | Last Modified: 2018/06/12
There are specific log settings that can be turned on to enable logging from QVConnect. This can be useful when troubleshooting generic ODBC/OLEDB connection issues.
QlikView any version
The following options should be set in the Settings.ini for QlikView desktop (or the QVB). Verbosity can also be set to 900 for debug level.
This will result in a QlikViewError.Log being created in the User Document folder. After reload, it will contain lines like:
Info General GenericConnect.cpp 582 [0X00000868] GetNextReply(1) reply: (res: 11) msg: 'SQL##f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified