Hi again,

Well, changed over to get ip address dynamically, and it all works fine!!!

So...could anyone point me in the right direction to figure out what was
going wrong with a static ip address?

Many thanks,

David

---------------------- Forwarded by David Hay/Lex/Lexmark on 04/11/2003
01:00 PM ---------------------------


David Hay
04/11/2003 12:36 PM

To: firebird-support@yahoogroups.com
cc:

Subject: RE: [firebird-support] HELP! Unavailable database whatever I
do! (Document link: David Hay)

Hi,

thanks for the suggestions.

It is definitely Firebird in a wierd state, as I cannot create a database -
I get the old
Statement failed, SQLCODE = -904

unavailable database
message when I try.

I have tried uninstalling everything, and reinstalling firebird, and I
still have the same problem. The fbserver is started fine & I have copied
the 2 dll's to \Windows\System32.

I then tried on another XP machine - same thing. Then on a test machine,
and it worked fine!

The only difference (apart from power) between the three is that the 2 that
fail both have static ip's, whereas the 3rd one, along with my dev machine
which works fine, has dynamic ip.

Could this be a reason for the problem? Are there any network-type
requirements for Firebird SS along these lines? Any ideas what to check?

I am **really** stuck here, so anyone's suggestions and help would be very
much appreciated!

I am using isql to try and create a database, using:

SQL> CREATE DATABASE 'c:\firebird\databases\kiosk.fdb' user 'SYSDBA'
password 'masterkey';

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/