LeTay
asked on
Problem to connect to a firebird database
I use a firebird database for one of my delphi application
I also user SQL Manager to maintain it
I need to make changes to the database layout.
I have a copy of the "production" database in my delphi directory, and it is listed in the SQL Manager localhost but when I double click on it, it does not open it, I get the error :
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
SQL Code: -902
IB Error Number: 335544472
Well, I know the user is sysdba and password either sysdba or masterkey but none of them works.
How can I practically "reset" the password on that database ?
I also user SQL Manager to maintain it
I need to make changes to the database layout.
I have a copy of the "production" database in my delphi directory, and it is listed in the SQL Manager localhost but when I double click on it, it does not open it, I get the error :
Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
Your user name and password are not defined. Ask your database administrator to set up a Firebird login.
SQL Code: -902
IB Error Number: 335544472
Well, I know the user is sysdba and password either sysdba or masterkey but none of them works.
How can I practically "reset" the password on that database ?
ASKER
Yes firebird is installed on my machine
I can open the same (copy) dabatase when it is located at another place (known via alias)
I can open the same (copy) dabatase when it is located at another place (known via alias)
the directory that does not work - is this local or mapped from elsewhere? if mapped its not supposed to work
that error often just means "cannot connect to database" - so don't get locked into username/password issue
does the firebird user (owner of the background process) have permission to read & write in the not-working directory?
that error often just means "cannot connect to database" - so don't get locked into username/password issue
does the firebird user (owner of the background process) have permission to read & write in the not-working directory?
ASKER
Everything is local on my D: drive
ASKER
Hello,
I finally found what the problem is : the password was not the one I thought !
Can I ask you this to conclude : assuming I could not remember the password, what should I have done to fix it ?
Thanks
I finally found what the problem is : the password was not the one I thought !
Can I ask you this to conclude : assuming I could not remember the password, what should I have done to fix it ?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks !
passwords are per machine not per database