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 <[email protected]) 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 ------------------------------------ ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: [email protected] [email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
