How to install and configure a 32 bit ODBC driver on a 64 bit Operating System?

You have a 64 bit operating system, which usually comes with a more modern equipment, and specially a 64 bit server OS, which is most likely to be the case, and you need to install an ODBC driver that would work with a 32 bit application such as FileMaker Pro.
If you install a 64 bit ODBC driver, it will be listed and configurable in “ODBC Data Source Administrator” (Start\Control Panel\All Control Panel Items\Administrative Tools\Data Source (ODBC)), but it will not be able to work with FileMaker Pro (or any other 32 bit application).
On the other hand, if you try to install the 32 bit driver, the system will not recognise it, and it will not appear in your default Data Sources (ODBC) inside the control panel, so you will not be able to configure it and connect to MySQL.


THERE IS A SOLUTION TO THIS PROBLEM – In many places you will read that this is IMPOSSIBLE – WHICH IS NOT TRUE. What you need to do is the following: Continue reading How to install and configure a 32 bit ODBC driver on a 64 bit Operating System?

Connecting FileMaker Pro and MySQL Database with MySQL ODBC driver

FileMaker Pro is compatible with MySQL databases which makes it possible to merge the system with any other web platform based on PHP/SQL including Word Press?

As the matter of fact, there is a long-lasting partnership between FileMaker Pro and MySQL (Oracle). There are a few extensive tutorials related to this that come with the software, or could be found on: http://www.filemaker.com/support/product/documentation.html.

You can also listen to a very good webinar by Zack Urlocker, that is covering many issues that the readers of this article might be interested in.

However, there are a few things you might have to face that nobody is telling you about when it comes to a real-life situation, and connecting to the WordPress particularily. This article will describe my experience of connecting FileMaker Pro database to MySQL database driving a WordPress website via a MySQL ODBC driver. My goal was to automatically harvest and sort-order data from contact forms so it could be used inside the FileMaker Pro database instantly. I will also include a step by step instruction on how to connect successfully and further integrate it all into a workable system.

Continue reading Connecting FileMaker Pro and MySQL Database with MySQL ODBC driver