I had posted this on the Support as I think this is a FireBird issue because 2 varied applications (VFP Application using ConnStrings and FlameRobin) were having connection problems. As I am bit desperate to know what might be happening and go on to resolve this at the earliest and the post being made by me on a Saturday maybe that is the reason for no-replies there but if this is considered a 3rd party question I would want to try it here too. I can confirm that VFP+ConnString does not work on 2 sets of computers so there is something I am royally missing here. Sorry about the trouble in any case the original text follows:

Hi all

Follow up to my recent message I have been doing some test between the problem computers. The basic setup is as follows:

server WinXP computer name: DEVE1
server alias.conf: C17_32787 = "C:\my database path\name.fdb"

client Win200 Prof computer name: DEVE2
client alias.conf: C17_37250 = "D:\my pathname\test.fdb"

I can never connect from the client to the server neither from the same VFP app nor FlameRobin using DEVE1:C17_32787

From the server I can always connect to the client database from my VFP app as well as FlameRobin using DEVE2:C17_37250

The below message is taken from flamerobin but has relevant FireBird error details.

Please advise what needs to be done in this regards.

Thanks and regards
Bhavbhuti


---------------------------
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 "DEVE1".
Failed to establish a connection.
A connection attempt failed because the connected party did not properly respond
after a period of time, or established connection failed because connected host
has failed to respond.

---------------------------
OK
---------------------------