Easysoft ODBC-ODBC Bridge

Why do I get "IM004, Driver's SQLAllocHandle on SQL_HANDLE_HENV failed" connecting to DB2?

Article:
00106
Last Reviewed:
19th July 2005
Revision:
1

This error generally occurs in UNIX because the environment variable DB2INSTANCE is not set and exported before the OOB Server is started. You need to either:

[1] edit /usr/local/easysoft/oob/server/server and add
DB2INSTANCE=xyz
export DB2INSTANCE
before the cd at the end of the file or
[2] defined DB2INSTANCE and export it before starting esoobserver
standalone.

Alternatively, if you are using the unixODBC driver manager you can use SQL_ATTR_UNIXODBC_ENVATTR in the odbc.ini file (see elsewhere in this FAQ) to set environment variables per DSN.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.