FMP is 32-bit; so you need to set up the MySQL DSN in Window's 32-bit ODBC control panel.
As Wim said FMP is 32-bit
From the control-panel standard the 64-bit odbc-control-panel will be opened. You can open the 32-bit-panel from:
%windir%\syswow64\odbcad32.exe ( = c:\windows\syswow64\odbcad32.exe )
If you type this exact command in the commandprompt, the 32-bit-panel will be opened
I do believe that Windows 8.1 shows both the 64 and 32-bit administrator panels right in the control panel. For Windows 7 you have to hunting where Menno points to.
Yes that is true, it is a bit odd behaviour though that in both these control-panels all the defined DSN's are shown, only to find out when you select one them that you can't edit it in case it's a 32-bit DSN in the 64-bit-panel and vice versa. I can understand that this is unclear for a lot of us.
That hasn't been my experience. I only see 32-bit DSN in the 32-bit admin panel. And 64-bit DSNs in the 64-bit admin panel.
I did. I'm very familiar with the DSN. I have be creating them and setting them up for a few years.
What version of Windows is that?
That's in Windows 8.1 64-bit
I just checked in Windows 8 on a 32-bit system and there the platform-column does not exist.
It's a combination of all your answers that helped me. FileMaker can only use 32-bit connector defined via System DSN.
Steps to resolutions
- Go to ODBC Data Source Administrator (64-bit) and remove all sources.
- Uninstall MySQL connector 64-bit.
- Install MySQL Connector 5.2.7 32-bit
- Open ODBC Data Source Administrator (32-bit)
- Go to System DSN and Add
I don't understand the inconsistency in FM, why one tab is be able to show the datasources while another won't.
The functionality between ESS and ODBC import are 2 completely different things.
ODBC import - is just that. An import using the ODBC standards.
ESS ( External SQL Source ) - in FileMaker allows a live connection to the ODBC database. That functionality is much, much different. So FM only shows you the supported DSN that it can use with ESS.
Now this makes sense, but the UI frames are the same in both steps, it leaves much room for confusion to the uninitiated. Thanks for your clear explanation though.