I am trying to access the local MySQL database from FileMaker Pro Adv 12, but I can not see any tables.
My confirgration is as follows:
1. Windows 7, 64 bit
2. FileMaker Pro Adv 12v3
3. MySQL 5.5.27 Community Server (is part of XAMPP 1.8.1)
4. MySQL Connector/ODBC 5.2.2 x86 32bit
I was able to create a system DNS using the odbcad32.exe located in /Windows/SysWOW64/ folder. The DNS is available in FileMaker, I created an external data source with no problem, but when I try to add a table to the relationship graph, nothing is available.
The MySQL database is available from phpMyAdmin and MySQLWorkbench without any problems.
I do not know what would prevent FileMaker from displaying the tables. Any ideas?
I did not specify a database to connect to when I created the system DNS!!!