Error im004 microsoft odbc driver manager driver s sqlallochandle on sql_handle_env failed

 · Unable to Open Query Builder: ERROR [IM] [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 Estimated Reading Time: 2 mins.  · ERROR [IM] [Microsoft] [ODBC Driver Manager] Driver's SQLAllocHandle on SQL_Handle_ENV failed. Can someone help me to resolve this error? Trying to make connection with Oracle Database 12c Release 2 () on Windows Server using below connection details. Connection String: “Driver= {Microsoft ODBC for Oracle};Server= .  · ERROR [IM] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed. ssis sql-serverr2 oracle10g bit. Share. Improve this question. Follow edited Apr 16 '14 at Peter Campbell. asked Apr 16 '14 at Peter Campbell Peter Campbell.

SQLAllocHandle is the first call when using ODBC. The most likely cause for this problem is an architecture mismatch. Meaning you have installed the 32bit version of Oracle client and are trying to use with a 64bit application or your app is 32bit and are trying to use the 64bit version of the Oracle client. ERROR [IM] [Microsoft] [ODBC Driver Manager] Driver's SQLAllocHandle on SQL_Handle_ENV failed. Can someone help me to resolve this error? Trying to make connection with Oracle Database 12c Release 2 () on Windows Server using below connection details. Connection String: “Driver= {Microsoft ODBC for Oracle};Server= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=x.x.x.x) (PORT=)));Uid=USERID;Pwd=PASSWORD;”. ERROR [IM] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed. ssis sql-serverr2 oracle10g bit. Share. Improve this question.

Sept Issue. When connecting to IBM DB2, the following error may occur: [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV. I get the above error message when trying to test an ODBC connection to an Oracle database using an OraClient g 10g driver. Apr "ERROR [IM] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed". 2. could you please point me in right.