Hi Salim,

Well, finally got things so I can connect to server again...

Now trying to fix old database which I saved off. I ran the gfix command
you suggested below, but I get the following error:

database file appears corrupt ()
-bad checksum
-checksum error on database page 36609

Don't know much about gfix. Should I try the -ignore option too, to ignore the checksum error?

Is there any detailed documentation for gfix anywhere?

Many thanks,

David




"Salim Naufal" <salim.naufal@...> on 03/11/2003 06:22:59 PM

Please respond to firebird-support@yahoogroups.com

To: <firebird-support@yahoogroups.com>
cc:
Subject: RE: [firebird-support] HELP! Unavailable database whatever I
do!


David,

There are several things you could do to figure out what is going on.
1) Check your Win XP application and system event logs for anything
abnormal.
2) If you cannot connect, there can be only two possibilities, either
Firebird is not working properly as a result of the crash or the database
is
corrupt.

To check if Firebird is working, create another database and try to access
it. If that fails, then the try reinstalling Firebird on that PC.
If you succeed in creating the database, you can assume that your Database
is corrupt. Back it up then restore it. In most of the cases, the problem
gets fixed: For that procedure, do the following:
gfix -mend -user sysdba -password <sysdba's pwd> <database>
gback -B -g -v -user sysdba -password <sysdba's pwd> <database> <backup>
gback -R -user sysdba -password <sysdba's pwd> <backup> <newdb>

good luck

Salim


-----Original Message-----
From: dhay@... [mailto:dhay@...]


Running on Win XP with SuperServer.

cheers,

David






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/