Subject | Presumed server conflict with WHS 2003 |
---|---|
Author | Don Davis |
Post date | 2012-02-27T02:06:34Z |
Is there a known conflict between Firebird and Windows Home Server 2003? Or does WHS host prohibit Firebird from acting as a server?
I recently installed Firebird 2.5.1.26351 (Win32) as a full server on my Windows Home Server 2003 machine. I created a test database using Virtual Volumes View (VVV) . My WHS is called "homeserver". I installed Firebird as a minimum client on three other machines of my LAN. My main client is called CYCLOPS.
On CYCLOPS, using FlameRobin, I registered "homeserver", the database, and port 3050. I got this message:
_________________________
Unhandled Error in FlameRobin
*** IBPP::SQLException
Context: Database::Connect
Message: isc_attach_database failed
SQL Message: -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code : 335544721
Engine Message:
Unable to complete network request to host "homeserver".
Failed to establish a connection.
__________________________
When the client machines could not connect to "homeserver", I discovered netstat. Netstat -a on CYCLOPS reported:
Proto Local Address Foreign Address State
TCP CYCLOPS:1028 homeserver.home:1138 ESTABLISHED
I reregistered Firebird on CYCLOPS using port 1028 and got the same error.
I reregistered Firebird on CYCLOPS using port 1138 and got:
__________________________
Unhandled Error in FlameRobin
*** IBPP::SQLException
Context: Database::Connect
Message: isc_attach_database failed
SQL Message: -923
Connection not established
Engine Code :335544421
Engine Message:
connection rejected by remote interface
__________________________
I reregistered port 3050 and installed vcredist.exe from the Microsoft site. Following error messages to Microsoft resulted in an MS statement that they had no solution for the error.
Fruitless searches of the internet, the Firebird public lists, and an extended correspondence with the VVV creator (Fulvio Senore <fsenore@...) finally resulted in this situation:
- Complete uninstalls of firewalls, anti-viruses on two client machines
- Clean install of Firebird full server on WHS homeserver (netstat -a: port 3050)
- Clean install on client machines of
Firebird minimum client, user SYSDBA, password masterkey
vcredist.exe
FlameRobin: server "homeserver", port 3050
I again got the 902 error. It was suggested that I use a machine other than my WHS. I clean installed VVV, Firebird, vcredist.exe, FlameRobin on CYCLOPS. On my third machine, I changed the server/database/port 3050 registration to CYCLOPS. VVV-Firebird instantly appeared.
It was then suggested I query here re intricacies of Firebird and WHS.
Thank you for any guidance you can offer.
Don Davis
I recently installed Firebird 2.5.1.26351 (Win32) as a full server on my Windows Home Server 2003 machine. I created a test database using Virtual Volumes View (VVV) . My WHS is called "homeserver". I installed Firebird as a minimum client on three other machines of my LAN. My main client is called CYCLOPS.
On CYCLOPS, using FlameRobin, I registered "homeserver", the database, and port 3050. I got this message:
_________________________
Unhandled Error in FlameRobin
*** IBPP::SQLException
Context: Database::Connect
Message: isc_attach_database failed
SQL Message: -902
Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements
Engine Code : 335544721
Engine Message:
Unable to complete network request to host "homeserver".
Failed to establish a connection.
__________________________
When the client machines could not connect to "homeserver", I discovered netstat. Netstat -a on CYCLOPS reported:
Proto Local Address Foreign Address State
TCP CYCLOPS:1028 homeserver.home:1138 ESTABLISHED
I reregistered Firebird on CYCLOPS using port 1028 and got the same error.
I reregistered Firebird on CYCLOPS using port 1138 and got:
__________________________
Unhandled Error in FlameRobin
*** IBPP::SQLException
Context: Database::Connect
Message: isc_attach_database failed
SQL Message: -923
Connection not established
Engine Code :335544421
Engine Message:
connection rejected by remote interface
__________________________
I reregistered port 3050 and installed vcredist.exe from the Microsoft site. Following error messages to Microsoft resulted in an MS statement that they had no solution for the error.
Fruitless searches of the internet, the Firebird public lists, and an extended correspondence with the VVV creator (Fulvio Senore <fsenore@...) finally resulted in this situation:
- Complete uninstalls of firewalls, anti-viruses on two client machines
- Clean install of Firebird full server on WHS homeserver (netstat -a: port 3050)
- Clean install on client machines of
Firebird minimum client, user SYSDBA, password masterkey
vcredist.exe
FlameRobin: server "homeserver", port 3050
I again got the 902 error. It was suggested that I use a machine other than my WHS. I clean installed VVV, Firebird, vcredist.exe, FlameRobin on CYCLOPS. On my third machine, I changed the server/database/port 3050 registration to CYCLOPS. VVV-Firebird instantly appeared.
It was then suggested I query here re intricacies of Firebird and WHS.
Thank you for any guidance you can offer.
Don Davis