Data Factory Redshift Dataset throws v2 Error when using v1

Question

Data Factory Redshift Dataset throws v2 Error when using v1

Clint Vallandingham 0

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.

Pilladi Padma Sai Manisha 5,240 Reputation points Microsoft External Staff Moderator

2026-03-06T20:56:26.0233333+00:00

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.
Pilladi Padma Sai Manisha 5,240 Reputation points Microsoft External Staff Moderator

2026-03-09T19:30:51.93+00:00

Hi Clint Vallandingham,
I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

1 answer

Your answer

Pilladi Padma Sai Manisha 5,240 Reputation points Microsoft External Staff Moderator

2026-03-06T20:56:26.0233333+00:00

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.
Pilladi Padma Sai Manisha 5,240 Reputation points Microsoft External Staff Moderator

2026-03-09T19:30:51.93+00:00

Hi Clint Vallandingham,
I hope you had a chance to review the information shared earlier, and I hope this information has been helpful! If you still have questions, please let us know what is needed in the comments so the question can be answered.

Answer 1

Clint Vallandingham 0

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.

Pilladi Padma Sai Manisha 5,240 Reputation points Microsoft External Staff Moderator

2026-03-11T01:40:21.6566667+00:00

Hi Clint Vallandingham
Thank you for sharing the update and confirming the resolution.

The issue occurred because the Self-Hosted Integration Runtime (SHIR) auto-update installed the Amazon Redshift V2 ODBC driver, but the required dependency Microsoft Visual C++ Redistributable was not installed on the machine. As a result, Windows was unable to load the driver module (rsodbc.dll), which triggered the ODBC IM003 / system error 126.

After manually installing the latest Microsoft Visual C++ Redistributable (x64), the missing dependency was resolved and the Redshift driver loaded successfully. This restored functionality for the existing Redshift V1 connection, and the V2 connection also works correctly now.

Thank you for confirming the fix, this information will be helpful for others encountering the same issue with SHIR updates and Redshift ODBC drivers.

Share via

Data Factory Redshift Dataset throws v2 Error when using v1

1 answer

Your answer