3 Replies Latest reply on Jun 21, 2017 5:16 PM by dbermann

    ODBC ESS Intermittent Connection only with PSOS

    dbermann

      I'm experiencing intermittent availability of the external data source after migrating from FileMaker Server 15 to 16. I have created a script to test this. It navigates to the layout of an external table, performs a Refresh Window (with Flush cached external data), attempts to Set Field, traps for errors. I run this 10 times via PSOS. I'm getting success sometimes 2/10 tries, sometimes 7/10 tries, etc. Very unreliable. The error is always #117.

       

      When I run the same script 10 times without PSOS, but in FMP connected to the hosted file, it is reliably successful 10/10 tries!

       

      All ODBC calls are going through the server of course. I don't know how to explain this. There was not an issue with FMS 15.

       

      Environment

      Windows Server 2012r2

      FileMaker Server 16

      MySQL ODBC Connector 5.3.7