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 ASE drivers connected to a database throw password expired errors and suggest that the user change the password using isql. This feature allows users to change their expired passwords using the ASE ODBC Driver.
To change password, you have to set 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 new password entered by the user. If oldpassword does not exist or is null, pwd contains the value of the current password.
A change password dialog is activated when “SQLDriverConnect with SQL_DRIVER_PROMPT” is set to True. In this dialog, the user is prompted for the current password and the new password that will replace it.