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.
ASE, SYC Sybase Adaptive Server Enterprise
O90 Oracle9i
O10 Oracle 10g
ORA Oracle 11g
PWDialog=value
PWDialog=0
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.
To display the Password Expired dialog box when needed in your application:
Database profile Although the setting of PWDialog has no effect in the development environment, you might want to set it in your database profile to generate connection syntax on the Preview page that you can copy into your code. Select the Display Runtime Dialog When Password Expires check box (for ASE or SYC connections) or the Password Expiration Dialog check box (for Oracle connections) on the Connection page in the Database Profile Setup dialog box.
Application Type the following in code:
SQLCA.DBParm="PWDialog=1"
