Your firewall sees this static IP address as a foreign computer and is
probably killing the packets.
I am not a firewall expert, but I think you can give your firewall a
list of all the "good" static
IP address. Then everything should work fine.

dhay@... wrote:

>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/
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>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/
>
>
>
>
>

--
Thomas Miller
Delphi Client/Server Certified Developer
BSS Accounting & Distribution Software
BSS Enterprise Accounting FrameWork

http://www.bss-software.com
http://sourceforge.net/projects/dbexpressplus