What you'll need to do is to download the firebird embedded edition and unzip it into a folder. If you are going to try to change the password from the command prompt you'll need to copy the isql.exe file from your original installation into the folder where you unzipped the embedded version. If you are going to use a tool like flamerobin copy the fbemded.dll to its folder. I'm not sure but you may need to rename it to fbclient.dll for flamerobin to use it. If you are using a tool like IBExpert or DBWorkbench then were it ask for the client dll point it to the firebird embeded client. You'll then be able to connect to the security database and issue the commands to change the password.
---In firebird-support@yahoogroups.com, <Emendez001@...> wrote : Hi, What the person meant was that if a database is opened using a firebird server process, that process looks for a valid password for the sysdba user. This is the situation you are in now. But, If you take that Database and open it in embedded mode, meaning that it isn’t using the server process. The Embedded mode only looks for the user to exist. It doesn’t care about the password. Once you connect, you can then issue the appropriate command to change the password. Thanks, Ed Mendez From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, March 23, 2017 1:05 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] reset sysdba password without loose existing users Hi, Thanks for your reply, I don't understand what you mean....sorry As i said, i don't have sysdba password....and i don't want to loose all existing users account Regards -----Message d'origine----- De : firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com] Envoyé : jeudi 23 mars 2017 17:29 À : firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com Objet : Re: [firebird-support] reset sysdba password without loose existing users 23.03.2017 17:27, startx252000@... mailto:startx252000@... [firebird-support] wrote: > Anybody can help me to reset SYSDBA without loose all existing users in Firebird Attach in embedded mode with SYSDBA name and you can change the password with ALTER USER command. -- WBR, SD. ------------------------------------ ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ http://www.ibphoenix.com/resources/documents/ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ ------------------------------------ Yahoo Groups Links
