The full error text is Remote error: [FireDAC][Phys][FB]Unable to complete network request to host "dataserver16". Error writing data to the connection. Now it seems that others have had this problem then once they sorted it, it went away, but I have the problem sporadically. My Datasnap ISAPI.dll which contains the FireDAC Firebird connection, is running on an IIS server on a different machine to the one where the database is hosted (dataserver16) but on the same subnet. I know everything is configured correctly, because the application works to expectations about 70% of the time! The other 30% of the time, my Datasnap client receives this error (as passed back from the dll).
Freddie Bell asked Jun 27, 2018 at 19:21 Freddie Bell Freddie Bell 2,255 1 1 gold badge 25 25 silver badges 48 48 bronze badgesAre you using any udf libraries? The Firebird server process stops unexpectedly after an exception in such libraries. You should definitely get a look into the firebird.log file on the server. It might hold further information.
Commented Jun 28, 2018 at 7:38 I'm not using any UDF libraries. Thanks Commented Jun 28, 2018 at 8:22 Anything in the firebird.log file? Commented Jun 28, 2018 at 8:31I see a lot of these: DATASERVER16 (Server) Thu Jun 28 10:00:16 2018 INET/inet_error: read errno = 10054 but they don't correlate to the exact times the reported error occurs. I appreciate the help.
Commented Jun 28, 2018 at 9:01errno = 10054 is connection reset by peer, and is usually an indication the connections aren't closed correctly by the client, it is probably not related to your problem.