Thanks, that fixed it, I don't know how it got
shutdown, but thanks.

Michael

> -----Original Message-----
> From: Thomas Steinmaurer [mailto:ts@...]
> Sent: Tuesday, October 28, 2003 1:40 PM
> To: firebird-support@yahoogroups.com
> Subject: RE: [firebird-support] User/Password not working ???
>
>
> > Just a few days ago, a program that was working
> > stopped being able to connect to the test DB on
> > my computer. With further testing I found that
> > the only user that could connect to a DB on
> > my computer was SYSDBA.
> >
> > It is strange what happens also.
> >
> > 1. Connect with SYSDBA/MASTERKEY - works fine
> >
> > 2. Connect with User1/Pass1x - a invalid pass
> > response of: "your username and password are
> > not defined..."
> >
> > 3. Connect with User1/Pass1 - a valid user/pass
> > response of: "database TestDB shutdown"
> >
> > -------
> > Things I have tried:
> > 1. This was working 4 days ago.
> > 2. Uninstalled all firebird, deleted isc4.gdb...
> > 3. reboot
> > 4. Installed newest version of firebird
> > 5. Can connect fine with sysdba
> > 6. Added new users tried to connect - same problem as above
> > 7. Tried using gfix to test this incase it was
> > a problem with the program I was using to connect:
> >
> > gfix -validate c:\test\testdb.gdb -user sysdba -password masterkey
> > ---- works fine
> >
> > gfix -validate c:\test\testdb.gdb -user user1 -password pass1x
> > ---- Your user name and password are not defined.
> > Ask your database administrator to set up a Firebird login.
> >
> > gfix -validate c:\test\testdb.gdb -user sysdba -password masterkey
> > ---- database c:\test\testdb.gdb shutdown
> >
> >
> > I don't know where to go from here, any ideals.
>
> Your database is in shutdown mode. You have to bring the
> database back online with using gfix.exe or any third-
> party tool which is capable to do so.
>
> With gfix.exe you can do that by using the -o switch.
> For example:
>
> gfix -o db_name
>
>
>
> HTH,
> Thomas Steinmaurer
>
> The IB LogManager Product Family
> Logging/Auditing Suite for InterBase/Firebird
> http://www.iblogmanager.com
>
>
>
>
> To unsubscribe from this group, send an email to:
> firebird-support-unsubscribe@yahoogroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>