Driver s sqlallochandle on sql_handle_env failed excel

 · The diagnostic data structure contains SQLSTATE IM (Driver's SQLAllocHandle failed). The error is returned on a connection handle. For more information about the flow of function calls between the Driver Manager and a driver, see SQLConnect Function. Diagnostics.  · ERROR [IM] [Microsoft] [ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.  · "ODBC: ERROR [IM] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" “ ODBC：错误[IM] [Microsoft] [ODBC驱动程序管理器] SQL_HANDLE_ENV上的驱动程序的SQLAllocHandle失败” So now I'm a litte confused and don't understand what this means and what I've done wrong.

The diagnostic data structure contains SQLSTATE IM (Driver's SQLAllocHandle failed). The error is returned on a connection handle. For more information about the flow of function calls between the Driver Manager and a driver, see SQLConnect Function. Diagnostics. Driver's SQLAllocHandle on SQL_HANDLE_ENV failed (DM) During SQLDriverConnect, the Driver Manager called the driver's SQLAllocHandle function with an fHandleType of SQL_HANDLE_ENV and the driver returned an error. IM Driver's SQLAllocHandle on SQL_HANDLE_DBC failed. [IM][unixODBC][Driver Manager]Driver's SQLAllocHandle on SQL_HANDLE_HENV failed [ISQL]ERROR: Could not SQLConnect In my case the issue is related with wrong installation path of the sqlncli dll. when we were trying to connect to SQL from Linux the application is trying to get the dll from a different path.

I am trying to connect Excel with DB2 database trough ADODB [ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed. Using an Excel data source, and receiving an error that says you need to install 32 Bit Excel/Office ODBC Drivers on each machine with a. 03 Sept "ODBC: ERROR [IM] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed". Update: When running Excel as an.