I'm getting the below error : Unable to Open Query Builder: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" I can able to open builder before running my query only after that it throwing the error. And if I close the Alteryx app and relaunch it then it's working that too before run only. I'm using ODBC drive 12.1 Could you help ?
Hello @KbsNaidu
This looks like an error on Microsoft's side.
I would check out the below article regarding this error message.
Also, I would recommend checking that your connection has been set up correctly.
https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Connect-to-an-OleDB-Data-Sou...
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connection-to-SQL-Server-DB-Error-IM00...
Thanks!
I've had the same error across multiple computers and multiple installs. Other people in my team have it as well.
I've never been able to work out a solution other than closing and restarting Alteryx, which can be very frustrating when I have a lot of data cached.