KNOWLEDGE BASE

Error "Driver's SQLAllocHandle on SQL_HANDLE_ENV failed" When Connecting to DB2


Published: 07 Sep 2018
Last Modified Date: 30 Apr 2019

Issue

When connecting to IBM DB2, the following error may occur:

[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed

Environment

  • Tableau Desktop 2018.2.0
  • Windows
  • IBM DB2

Resolution

The following options can be used to work around the issue:

Option 1 - Run Tableau Desktop as administrator
  1. Close all instances of Tableau Desktop.
  2. Right-click the Tableau Desktop icon and select Run as administrator.
Option 2 - Install the IBM DB2 driver provided on the Tableau Driver Download page.

Option 3 - Add the userid used to run Tableau Desktop to either the DB2ADMNS or DB2USERS group. For more information see SQLSTATE IM004, SQLAllocHandle on SQL_HANDLE_ENV failed, when connecting via an ODBC application.

 
Did this article resolve the issue?