E-AD: "Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" received when running Application Designer on Windows Server 2008 R2 on DB2 LUW

(Doc ID 1529542.1)

Last updated on FEBRUARY 04, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
Information in this document applies to any platform.

Goal


Installing PeopleTools 8.52 Client on Windows Server 2008 R2 operating system.
The database platform is DB2 LUW on a different server. ODBC sources are configured and test OK.

* When running Application Designer, attempting to log on to database shows:
"File: SQL Access ManagerSQL error. Stmt #: 2  Error Position: 0  Return: 8600 - [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed (SQLSTATE IM004) 0"


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms