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?


      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