The ASE ODBC Driver and ASE OLE DB Provider introduce two connection string properties to support the password change feature:
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.