Many of the web applications I develop use MySQL databases. To access these I can build webforms and try to add in security, but I find it often easier to use FileMaker Pro to access the MySQL database via OBDC. When using Filemaker Pro on a Mac running OS X, I have found it best to purchase an ODBC driver and have successfully used the one offered by Actual Technologies using the Actual ODBC Driver for Open Source Databases. For Windows, I use the free ODBC driver offered by Oracle.
Unfortunately Windows version of FileMaker Pro 12 is a 32 bit application so although you can install 64 bit OBDC drivers, Filemaker can not access them. There is a work around however. This has been tested using both Windows 7 as well as Windows 8 (including 8.1).
This remainder of this post is with regards to Windows Operating System.
If you install a 64 bit ODBC driver it will be listed and configurable in the “ODBC Data Source Administrator” (Start\Control Panel\All Control Panel Items\Administrative Tools\DataSource (ODBC). But that will NOT work with Filemaker Pro, as of version 12. On the other hand if you install the 32 bit version, you can not use this method to configure the ODBC driver.
Installing the 32 bit ODBC Driver
- Download the 32 bit OBDC driver that provided by Oracle: mysql-connector-odbc-win32.msi. You can obtain at this link. Be sure to download the 32 bit version regardless if you have the 64 bit version of Windows installed.
- Right click on the MSI file and select to Install the driver. The driver will be installed in the following place: C:\Program Files (x86)\MySQL\Connector ODBC 5.1
- Instead of following the usual path via the Control Panel, where the 32 bit driver will not be recognized, instead go where the 32 bit driver configuration is:
- After launching, click on the driver tab and you can see the drivers installed. You will be using the MySQL ODBC Driver.
Configuring the ODBC Driver to work with Filemaker Pro
- Click on the System DNS Tab, then click the Add Button
- Select the MySQL Driver
- For the Data Source Name, use what you will be addressing this in your Filemaker Application
- Give it any description you wish.
- For the Server you will need the parameter that points to your MySQL database. Typically this is int he form of mysql.mydomain.com
- Enter the Username and password for your MySQL Database
- If you have entered the correct Username and Password, the database drop down will allow you to select which database you wish to connect to.
- Add any additional connections you need, then click OK to close the admin application.