Forum Discussion
Advocate ICopy Data activity from Amazon Redshift via VNet Gateway fails with ODBC Driver Error
Solution:
Deploy a self-hosted IR inside your VNet.
Install the Amazon Redshift ODBC driver on that IR machine.
Configure your Copy Data activity to use this IR.
This will fix the driver error and let Copy Data connect via VNet.
Hi rldekkers,
Thanks for reaching out to the Microsoft fabric community forum. The failure is happening on the source side with an ODBC Driver Manager error (IM002: Data source name not found and no default driver specified). That means the runtime used by Copy Data doesn’t have the Amazon Redshift ODBC driver available. As Shahid12523 has already responded to your query, kindly go through his response and check if the issue can be resolbed.
I would also take a moment to thank Shahid12523, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Hi rldekkers,
As we haven’t heard back from you, so just following up to our previous message. I'd like to confirm if you've successfully resolved this issue or if you need further help.
If yes, you are welcome to share your workaround so that other users can benefit as well. And if you're still looking for guidance, feel free to give us an update, we’re here for you.
Best Regards,
Hammad.
Hi rldekkers,
Hope everything’s going smoothly on your end. As we haven’t heard back from you, so I wanted to check if the issue got sorted.
Still stuck? No worries just drop us a message and we can jump back in on the issue.Best Regards,
Hammad.
Hi rldekkers,
We noticed there hasn’t been any recent activity on this thread. If you still need support, just drop a reply here and we’ll pick it up from where we left off.Best Regards,
Hammad.