1218187 - Option removed to change user's password with ODBC connection to DB2 in CR

SAP Knowledge Base Articles - public

1218187 - Option removed to change user's password with ODBC connection to DB2 in CR


When creating a report in Crystal Reports 8.5, the 'Connect to DB2' dialog box contains a 'Change Password' check box. The report is using the IBM DB2 drivers (db2cli.dll, v. to establish an ODBC connection to an IBM DB2 database. When creating the same report in Crystal Reports 9 and later, the dialog box is now called 'ODBC (RDO)' and the 'Change Password' check box has been removed.

Why has the dialog box changed?

How can you change the user's database password?


The dialog box has changed by design. In CR 9 and later, regardless of database type, the 'ODBC (RDO)' dialog box appears when 'ODBC' is selected as a data source. In Crystal Reports 9 and later, the ODBC entry is a uniform layout so that all ODBC drivers appear to have the same input values.

To change the user's database password, open the Data Source Name (DSN) in the Microsoft ODBC Data Source Administrator and change the value manually before making a connection to DB2 within Crystal Reports. For assistance with DSN modification, contact your Database Administrator or refer to the database documentation.

See Also

Business Object Customer Support is not responsible for creating or modifying an ODBC DSN connection to your database. However, for suggestions about configuring DSNs, refer to Note 1214244.


DB2 ODBC CRYSTAL LOGIN DATA SOURCE DSN CHANGE PASSWORD Crystal Reports Crystal Reports 9 and DB2 ODBC DB2 ODBC Data Source with Crystal Change password when connecting , c2016751 , KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem


SAP Crystal Reports 8.0