Unable to connect Alteryx with ODBC

Question

I am getting below error while configuring Alteryx input tool with Oracle ODBC data source

ODBC 64 bit connection working as expected : test connection is successful.

---------------------------
Alteryx Designer x64
---------------------------
Connection Error :
ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
---------------------------
OK
---------------------------
 I am using Oracle client 19c 64 bit

Elias_Nordlinder · Answer

Hello @Avishek1,

This looks like a common problem with the Windows ODBC drivers, that seems to have to be reinstalled.
There have been some questions regarding this on the Alteryx forum before.

Look at this thread and the linked threads in the first comment for more information:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Unable-to-Open-Query-Builder-ERROR-IM004-Microsoft-ODBC-Driver/td-p/735016

//Regards
Elias