IBM DB2 ODBC Connection Error

Question

Hi,

I created a system DSN for IBM DB2 ODBC connection and tested successfully. But when use the DSN to input data in Alteryx Designer, I got the following error:

The DB2 ODBC driver version is 11.05.00.1077. I would appreciate it very much if anyone can help. Thank you!

Hans020 · Answer

Hi,

I'm experiencing the exact same error. Were you able to fix it?

Regards,

Hans

TrevorS · Answer

Hello @pxs132 
I looked up the error message you posted and found some documents that may help you out.
https://stackoverflow.com/questions/63911262/microsoft-access-driver-specified-driver-could-not-be-loaded-due-to-system-erro

Additionally, I would recommend you check to make sure that you are using the correct driver for the Designer version you have installed. https://www.alteryx.com/data-sources

Thanks,
Trevor