ODBC - MySQL tables not accessible in external data source - relationship graph
We are hosting a database using Filemaker Server Advanced 11 and Windows Server 2008 R2.
I am trying to set up a connection from an external data source (mySQL) hosted on a separate linux server. The Windows server has the MySQL driver (MySQL ODBC 5.1) configured to use System DSN. The connection appears to be working (ie the name of the database is accessible and pressing test results in a 'success' message). However, when I go to the relationship graph and try to add the data source, the source is listed but the tables are not listed in the window.
I have search for an answer but havent been able to find an answer - any ideas would be appreciated.