Unable to Open Query Builder: ERROR [IM004] [Microsoft][ODBC Driver Manager] Dri

Question

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 ?

ERROR.PNG

JamieHankins · Answer

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.

TrevorS · Answer

Hello @KbsNaidu

This looks like an error on Microsoft's side.

I would check out the below article regarding this error message.

https://forum.uipath.com/t/error-im004-microsoft-odbc-driver-manager-drivers-sqlallochandle-on-sql-handle-env-failed/79288

https://social.microsoft.com/Forums/en-US/95b6fdf0-3239-4d80-972d-0694909bb27c/suddenly-getting-odbc-error-after-i-run-the-latest-windows-update?forum=Offtopic

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-Source/ta-p/442847

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Connection-to-SQL-Server-DB-Error-IM004/td-p/427017

Thanks!