AnsweredAssumed Answered

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

Question asked by mrwatson-gbs on Nov 22, 2011
Latest reply on Nov 22, 2011 by 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

Outcomes