AnsweredAssumed Answered

Filemaker Server 16 ODBC connection freezing

Question asked by johnfranklin on Jan 8, 2018
Latest reply on Feb 4, 2018 by beverly

I have a solution that has been working well for several months and suddenly broke. This may have been perpetuated by the last round of windows security updates. I have a list of orders displayed in a portal. The source of the portal is SQL Native 11 ODBC data. Consisting of a header table and several related tables. Clicking on a portal row will create a new Filemaker record and populate it with the related ODBC data. This will work for several hours and then un expectantly hang. The find window  \ Find in progress \ Processing query window will appear. The copy cup will then appear. When this happens the database cannot be closed from Filemaker server. The ODBC data source is no longer accessible by other applications. My configuration is as follows:

SERVER

Window Server 2016 Standard Edition

Filemaker Server 16.03

SQL Server native Client (64 bit)

WORKSTATIONS

Windows 10 Pro 64 bit

FMP 16.03 user connections

Outcomes