0 Replies Latest reply on May 2, 2011 10:13 AM by donjuancarlos_1

    ODBC connection not working consistently

    donjuancarlos_1

      Title

      ODBC connection not working consistently

      Post

      --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?