ODBC Server Reference Manual

Changing Passwords in a Three-Tier Environment
HP NonStop ODBC Server Reference Manual—429151-002
E-2
Possible values for the Suppress CHANGEPASSWORD View attribute are:.
This NonStop ODBC driver attribute is found in the ODBC.INI file, associated with one
or more datasource definitions. The attribute name in the Windows NT registry is
SQL_CHANGEPASSWORD_NO_GUI, and it takes values of YES and NO.
If a password error is returned, it is necessary for the change password operation to
complete successfully before the client can successfully log in and execute SQL. If a
password warning is returned, the current session is valid and statements can be
executed.
To use this facility, the user configuration must also be configured for change password
on the server where NonStop ODBC Server is running. The username alias
configuration attribute CHANGE_PASSWORD_OPTION must have a value of 1 or 2.
Refer to the description of the ADD ALIAS statement in Section 7, Managing
Customized Catalogs, for information about setting this attribute.
NO Specifies that detection of an expired password by the NonStop ODBC
Server is reported to the user on the same platform where the NonStop
ODBC/MP driver is being executed. The user is asked if they wish to change
the password by using a popup menu.
YES Specifies that detection of an expired password by the NonStop Server is
returned as a SQLSTATE error or warning. The application server in the
middle tier may use secure means to report and solicit a new password. The
application server then creates a second connection to complete the change
of password before proceeding with normal ODBC session activities.