AnsweredAssumed Answered

ODBC ESS Intermittent Connection only with PSOS

Question asked by dbermann on Jun 21, 2017
Latest reply on Oct 3, 2017 by swheeler

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

Outcomes