ODBC connection not working consistently
--FM11 Database hosted on FM11 Advanced server. My database connects to Simply Accounting, which uses MySQL.
Problem: When users open a page that has some ODBC data fields on it (e.g., sales data) the data almost always does not show up.
The only fix I have found so far is for each user to export a report that has ODBC fields in it. After that, users can view ODBC data everywhere normally. This works until the user closes FileMaker, at which time they must rerun the export report.
It seems like the data connection isn't initializing properly (possibly because initializing ODBC connection is slow and FileMaker has some timeout limitation?) Does anyone have experience with this issue?