Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. READ MORE

ODBC connectors stopped working after a Qlik Sense upgrade

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Rakesh_HB
Support
Support

ODBC connectors stopped working after a Qlik Sense upgrade

Last Update:

Jul 7, 2024 6:59:13 AM

Updated By:

Rakesh_HB

Created date:

Jul 8, 2024 8:25:24 AM

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

 

Labels (1)
Contributors
Version history
Last update:
2 weeks ago
Updated by: