KB44674: "Unexpected Error. Database error Connect Failed: Command Not Supported" error message appears when connecting to an IBM DB2 v9.7 database in MicroStrategy 9.x

SYMPTOM:
 
When connecting to an IBM DB2 v9.7 database, users get the error below:
 

Unexpected Error. Database error Connect Failed.
Error Type: ODBC error
Command Not Supported.

 
Tyring to connect to the same database through IBM Data Studio using the same connection information works fine.
 
CAUSE:
 
This is an issue with IBM DB2 as the database user account does not have the authority to bind a package. This permission is required for the ODBC connection to be established.
 
ACTION:
 
The service account used to create access to the database must have the BINDADD permission granted in order to be able to create the packages necessary for the ODBC connection. The DB2 administrator should grant this permission to the service account. For more infromation on this topic, review the links shown below:
 
http://www-01.ibm.com/support/docview.wss?uid=swg21617594
http://knowledgebase.progress.com/articles/Article/8430
 
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability