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.