SYMPTOM:
When attempting to connect to a DB2 database from Strategy 9.4.1 using the Strategy Driver for DB2 Wire Protocol, the following error occurs:
Sample Code/Error
Connect failed.
Error type: Odbc error. Odbc operation attempted: SQLDriverConnect.
<USERID> DOES NOT HAVE PRIVILEGE TO PERFORM OPERATION BIND
CAUSE:
This error occurs because the user attempting to connect to the DB2 database does not have the proper privileges in place. In order to connect, the user must have the BINDADD and GRANT privileges on the database side.
ACTION:
To resolve this issue, apply the appropriate privileges on the database side. For more information on configuring DB2 privileges to allow successful connection using the Strategy Driver for DB2 Wire Protocol, see the following technical note:
KB19382 - Information regarding package creation and binding for the Strategy ODBC Driver for DB2 Wire Protocol
