PWDialog

Description

Controls whether a Password Expired dialog box displays in an application at runtime if a user’s password has expired.

When PWDialog is set to 1, the Password Expired dialog box prompts users to change their passwords if they attempt to log in to the database with an expired password. By default, PWDialog is set to 0 to specify that the Password Expired dialog box does not display in your application at runtime.

The setting of PWDialog affects applications only at runtime. It has no effect in the development environment because, regardless of the PWDialog setting, the Change Password dialog box displays in the development environment to prompt users to change an expired password.

NoteWhen to specify PWDialog You must specify a value for PWDialog before connecting to the database.

Applies to

Syntax

PWDialog=value

Parameter

Description

value

Specifies whether the Password Expired dialog box displays in an application at execution time to prompt the user to change an expired login password. Values are:

Default

PWDialog=0

Usage

When to use Setting PWDialog to 1 to display the Password Expired dialog box in your application provides a convenient way for you to notify your users that a password has expired and allow them to change it.

What happens When the Password Expired dialog box displays in your application at runtime, it notifies users that the password for their login ID has expired and prompts them to supply a new password. For example, for Adaptive Server Enterprise, the sp_password system stored procedure runs to set the new password. Once the password has been changed, the database connection succeeds.

If the user clicks Cancel to close the Password Expired dialog box without changing the password, the database connection fails and a message displays indicating that the password has expired.

Examples

Example 1

To display the Password Expired dialog box when needed in your application: