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

[KbsNaidu]

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 ?

[TrevorS]

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-h...

https://social.microsoft.com/Forums/en-US/95b6fdf0-3239-4d80-972d-0694909bb27c/suddenly-getting-odbc...

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!

[JamieHankins]

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.