Qlik ODBC drivers may fail to load with the error:
Error: Connector connect error: SQL##f - SqlState: IM003, ErrorCode: 160, ErrorMsg: Specified driver could not be loaded due to system error 126: The specified module could not be found. (Qlik-redshift, C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage
edshift\lib\AmazonRedshiftODBC_sb64.dll).
ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (Qlik-redshift, C:\Program Files\Common Files\Qlik\Custom Data\QvOdbcConnectorPackage
edshift\lib\AmazonRedshiftODBC_sb64.dll).
The error persists even if the specified "*.dll" exists in the path mentioned in the error description.
More information about the logs can be found in Locate the log files for ODBC connectors Or How To Collect Logs From Qlik ODBC Connector Package
Resolution
The problem is caused by a compatibility issue with the installed ODBC drivers and the installed Microsoft Visual C++ version. Verify that the correct Microsoft Visual C++ version for your ODBC driver version.
Take a backup of Qlik Sense and Qlik ODBC connectors folders.
To solve this, download and install the Microsoft Visual C++ Redistributable Packages from here or install Latest Supported Microsoft Visual C++ Redistributable Package
Ensure you restart the Qlik Sense services or reboot the affected Qlik Sense Windows machine if necessary. If it is a multi-node environment, these changes should be applied to all affected nodes.
The information in this article is provided as-is and is to be used at your own discretion. Depending on the tool(s) used, customization(s), and/or other factors ongoing support on the solution below may not be provided by Qlik Support.
Related Content
Qlik ODBC connectors may not work as expected after a Qlik Sense Enterprise on Windows upgrade
Environment
