You're using ODBC with SQLCONNECTIONSTRING() also. Something is different or missing from the connection string.

>Thanks, I will check for AERROR() and let you know. In the mean time I used FlameRobin (FireBird GUI) to connect to the database and got the following error
>--------------------------
>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
>---------------------------
>
>If it is failing to connect to the server DEVE1 but DEVE1 does not have any problem to connect to the client's test database in a similar manner. This is not only a single case but happens similarly on another set of computers and this is apart from VFP+ConnStrings but then again everything was fine when using ODBC on both the sets of computers. I will revert back to ODBC for the moment but I am not sure of this one way traffic thing.