razsnic

FileMaker will not display the tables from the local mysql database

Discussion created by razsnic on Dec 23, 2012
Latest reply on Dec 24, 2012 by 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

Outcomes