Password change dialog DBISQL

[robert_kratschmann]

After creating an user with "FORCE PASSWORD CHANGE ON" or using dual control to change the DBA password I get in DBISQL or SQL Central a dialog window asking me for the old and new password.

Using isql, "DBISQL -nogui" (, or SQuirreL SQL) I only get a message that the password has expired but no dialog (). Is there a possibility to change the password with another tool or must I use DBISQL with gui or SQL Central?

Many thanks

[former_SQLA_member1694885 · Accepted solution]

with "-nogui" obviously you won't get a dialog. You should be able to use the "newpassword" / "newpwd" connection parameter to specify the new password on the cmd line.
For SQuirreL SQL, I'd expect a dialog to pop up if you use the JNI JDBC driver aka iAnywhere JDBC driver or a JDBC-to-ODBC bridge. I doubt that jConnect supports this. This, however, is educated guessing, I can't currently verify or falsify it.

HTH

Volker

[robert_kratschmann · Accepted solution]

Hi Volker,

many thanks "newpwd" works fine with DBISQL and also in SQuirrel SQL.

Additional information: I did a test with dual control and offline DBA password reset...

It works too but you have to change the password twice:

...
CONNECT TO test USER U1 IDENTIFIED BY sybase;
ALTER USER DBA IDENTIFIED FIRST BY part11;
CONNECT TO test USER U2 IDENTIFIED BY sybase;
ALTER USER DBA IDENTIFIED LAST BY part22;
STOP SERVER UNCONDITIONALLY;

--U:\\>"%SQLANY17%\\bin64\\dbeng17.exe" -orp "UID=DBA;NEWPWD=newpassword;AUTHUID=DBAReset;AUTHPWD=sybase" d:\\dualcontrol.db
--Password for user 'DBA' is reset sucessfully

START SERVER AS test STARTLINE 'C:\\\\Program Files\\\\SQL Anywhere 17\\\\bin64\\\\dbeng17.exe -c 10M d:\\dualcontrol.db';
CONNECT USING 'UID=DBA;PWD=newpassword;NEWPWD=sybase;Server=test';
CONNECT TO test USER DBA IDENTIFIED BY sybase;
select * from sysusers;--OK

Maybe it would be better if offline DBA password reset is not allowed if dual control is used?