Unable to create a connection from QlikView/ Qlik Sense to DB2 using the Qlik ODBC Connector Package. Connection creation fails with error message "ERROR [HY000] [Qlik] [ODBC DB2 Wire Protocol driver]Specified security mechanism, (Unknown), is not supported by server
This error is usually observed when the ODBC connection is configured with an authentication method that is not supported by the DB2 database server. More details about this error can be found on IBM support site at http://www-01.ibm.com/support/docview.wss?uid=swg21641494
To resolve the issue:
- Contact the database administrator to understand which authentication method is currently set up on the server
- Set advanced parameter AuthenticationMethod with value from 0 to 8 in the connector configuration dialog, depending on the current authentication method.