Data Factory Redshift Dataset throws v2 Error when using v1

Question

Our Redshift Copy Pipelines recently stopped working with the error that they cannot locate a V2 ODBC DLL file. We did not change any settings and are still using V1 for Redshift. We attempted to update the Linked Service to use v2 but still receive the below error.

ERROR [IM003] Specified driver could not be loaded due to system error 

126: The specified module could not be found. (Microsoft Amazon Redshift

V2 ODBC Driver, C:\Program Files\Microsoft Integration

Runtime\5.0\Shared\ODBC Drivers\Microsoft Amazon Redshift V2 ODBC

Driver_2.1.10.1\lib\rsodbc.dll).

We have verified that this file does existing on our SHIR server and we are running the latest version of the SHIR.

Answer 1

Hi Clint Vallandingham
Thankyou for reaching microsoft Q&A!
This error usually indicates that the Self-Hosted Integration Runtime (SHIR) is attempting to load the Amazon Redshift V2 ODBC driver, but Windows cannot load the required driver module or one of its dependencies.

Even if rsodbc.dll exists in the path, ODBC error IM003 with system error 126 typically occurs when a dependent library is missing or the driver is not properly registered on the SHIR machine.

Please try the following checks:

Verify that the Microsoft Amazon Redshift V2 ODBC Driver appears in ODBC Data Sources (64-bit) → Drivers on the SHIR server.

Reinstall or repair the Redshift V2 ODBC driver to ensure all dependencies are installed correctly.

Ensure Microsoft Visual C++ 2015–2022 Redistributable (x64) is installed, as it is required by many ODBC drivers.

After making changes, restart the Microsoft Integration Runtime service.

Even if the pipeline was previously configured with V1, newer SHIR versions may attempt to validate or load the V2 driver, which can trigger this error if the driver or its dependencies are not correctly installed.

Answer 2

Per the comment from @Pilladi Padma Sai Manisha . The issue was the C++ Redistributable. The SHIR was set to auto-update and applied the latest version which also installs the Redshift v2 ODBC but did not install the latest C++ Redistributable which is a requirement for the Redshift install. Manually installing the latest C++ Redistributable corrected the issue with the Redshift v1 connection and we also verified the v2 connection now works.