Password change dialog DBISQL

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

password server

asked 15 May '19, 04:57

Robert Krats...
116●6●7●15
accept rate: 0%

flat view

One Answer:

active answers oldest answers newest answers popular answers

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

permanent link

answered 15 May '19, 05:49

Volker DB-TecKy
545●3●7●15
accept rate: 25%

edited 15 May '19, 07:25

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?

(15 May '19, 08:23) Robert Krats...

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

server ×37
password ×15

question asked: 15 May '19, 04:57

question was seen: 1,251 times

last updated: 15 May '19, 08:35

SAP SQL Anywhere

Password change dialog DBISQL

Follow this question

Related questions