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.


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"


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