Issue
When connecting to IBM DB2, the following error may occur:
[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed
Last Modified Date: 30 Apr 2019
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- Close all instances of Tableau Desktop.
- Right-click the Tableau Desktop icon and select Run as administrator.
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.
Additional Information
SQLSTATE IM004, SQLAllocHandle on SQL_HANDLE_ENV failed, when connecting via an ODBC applicationThank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials