Self Hosted Integration Runtime

[halll_sc]

Have a flow that has been copying data from Redshift to an Azure SQL database for some time now. This flow has been working since its inception but today it started to fail and in looking at the reason the copy activity linked service to Redshift is failing with the following error. 

ERROR [IM003] Specified driver could not be loaded due to system error 126: The specified module could not be found. (Microsoft Amazon Redshift ODBC Driver_1.5.14.1017, C:\Program Files\Microsoft Integration Runtime\5.0\Shared\ODBC Drivers\Microsoft Amazon Redshift ODBC Driver_1.5.14.1017\lib\AmazonRedshiftODBC_sb64.dll).

I logged into the remote VM running the agent and from what I can tell the agent is running as expected and the above mentioned file is in the directory specified in the error. 

Just wanted to see if anyone has dealt with a similar issue. 

[Anonymous]

Hi @halll_sc ,

Based on the error message, the problem may be related to a gateway upgrade. It may be worth checking if any recent updates or changes have triggered the issue.

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[halll_sc]

Update: I went as far as  uninstalling and reinstalling the integration runtime agent on the VM and still getting the same error regarding not being able to locate the ODBC driver.