1 Reply Latest reply on Dec 24, 2012 1:20 AM by razsnic

    FileMaker will not display the tables from the local mysql database

    razsnic

      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?

       

      Thank you.

      Raz