Password Expiration Handling

Every company has a specific set of password policies for its database system. Depending on the policies, the password expires at a specific date and time.

Unless the password is reset, the Adaptive Server ODBC Driver connected to a database throws password expired errors and suggests that the user change the password using isql. The password expiration handling feature allows users to change their expired passwords using the Adaptive Server ODBC Driver.

Changing the Password Through the Connection String Properties

Set these two connection string properties:

OldPassword – the current password. If OldPassword contains a value that is not null or an empty string, the current password is changed to the value contained in PWD.
PWD – contains the value of the password. If OldPassword is not null, PWD contains the value of the current password. If OldPassword does not exist, or is null, PWD contains the value of the new password.

Changing the Password Through a Dialog Box

A change password dialog is activated when SQLDriverConnect with SQL_DRIVER_PROMPT is set to true. In this dialog, enter the current password and the new password.