Subject How do you change the SYSDBA Password
Author dkoder2
I swear I am about ready to go back to stone tablets and a chisel. I
finally gave up on getting the embedded database to work and now I
having trouble changing the SYSDBA password. I have searched the docs,
the net, and this forum and not one of the examples seem to work.

My programming environment:
W2K (SP4).
Visual Basic 6.0 (SP6)
Firebird 2.0

Firebird Registry Entry
DefaultInstance: C:\Program Files\Firebird_2_0\
Database Type: Client\Super

Most successful attempts:

C:\Program Files\Firebird\bin\>gsec -database "localhost:C:\Program
Files\Firebird_2_0\Security2.fdb -modify sysdba -pw masterkey -user
sysdba -pw abcdefgh
WARNING - maximum 8 significant bytes of password used
password already specified

C:\Program Files\Firebird\bin\>gsec -database "localhost:C:\Program
Files\Firebird_2_0\Security2.fdb" -modify sysdba -pw masterkey -user
sysdba -pw abcdefgh

The command to change the SYSDBA password and the results:
C:\>gsec -modify sysdba -pass masterkey -user sysdba -pass abcdefgh
database administrator password already specified

C:\>gsec -display -user SYSDBA -pass masterkey
Show list of user as expected but proves password has not been changed

I have tried every iteration conceivable using -d, database, -pw,
-pass, -password, etc. and still cannot modify the SYSDBA password. I
single quoted, double quoted and no quotes. I don't have a clue about
what to do next.

TIA dkoder2