1 Reply Latest reply on Nov 22, 2011 11:44 PM by mrwatson-gbs

    Why do ESS TOs disconnect from their tables in the relations graph?

    mrwatson-gbs

      Hallo all,

       

      I've created ESS table occurences in a database on a Windows computer using the MySQL ODBC driver. ODBC System DSN Name = "Verbindung"

      Then I moved the DB to my Mac laptop, where the same ODBC System DSN is set up. It uses however the latest ODBC driver from Actual Technologies.

       

      I can use the database successfuly on both machines...BUT...on the mac :

       

      • the ESS-Table Occurences are NOT CONNECTED to a table,
      • when I double-click an ESS TO in the relationship graph I see the list of tables in the mySQL database, BUT there is no table selected. (On the windows machine the table IS selected, e.g. TO "ESS_products" is linked to ESS Table "products"),
      • if I now click on the table that the TO *SHOULD* be connected to...a SECOND shadow table ("products 2") is created in the FileMaker file.

       

      Anybody else expereienced this?

       

      Is it because of the different drivers?

       

      Is it because of a capital letter in the ODBC Name?

       

      Thanking you in advance for any feedback.

       

      Russell Watson

       

      FMA11

      windows_2003_r2

      mac_os_x_lion