We are running FMSA12.0.4 on Windows Server 2008 r2 (64bit).
The server uses an ODBC connection to send and receive data from a MySQL database on a webserver (another machine).
When an FM client logs on to the server and accesses a screen that includes the ODBC data, Filemaker will randomly stop functioning.
Typically, this will involve a Find dialog box appearing where it says the find process is progressing. The process cannot be cancelled and even when left for an extended period it does not progress. The only solution is to disconnect the user in the Server Admin console.
After some research I found some references to similar situations which had been resolved by using different versions of the MySQL ODBC driver.
As such I have tried MySQL ODBC 5.01.07, 5.02.02, then back to 5.01.08 with little success. Version 5.02.02 seemed to reduce the occurance of the crashing slightly but not enough to make the system usable.
I have seem some references to reducing the time an ODBC connection can be left open but I have not been able to find controls for this in the driver software.