I've simply installed the Windows ODBC drivers supplied by MySQL (and by Microsoft for MS SQL Server). I have a number of FileMaker solutions that connect to both MySQL and MS SQL Server databases, and have found this solution to work well.
Just hadn't tried it yet.... A bit of a shame the mac platform has to shell out for expensive 3rd party drivers....., but hey it's a camp I love to live.... Now to go off and set up a windows FileMaker server with mainly mac clients - the database system requiring a live MySql connection and see how it goes.....
One thing to watch: if you're using FileMaker Server 11, note that they are 32-bit software. If your Windows server is running a 64-bit version of Windows/Server (e.g. Win Server 2008R2), you need to use the 32-bit ODBC Administrator to set up the ODBC data source(s). I don't have the location of it handy, but a quick search of the interwebs should enable you to find it. The default ODBC Administrator in 64-bit Windows is the obvious one, but any sources set up in it will not show up in Filemaker Server 11.
Obviously, if you're using FileMaker Server 12, use the 64-bit ODBC Administrator, since FMServer 12 is 64-bit.
In both cases,make sure you set the data source up as a "System DSN", not a "User DSN".
My FMS12 isn't seeing any of the 64bit ODBC connections. It IS showing the 32 bit ones, but trying to bring in a table into the relationship graph just causes it to crash. Any ideas? My setup worked in FMS11, but hasn't since the upgrade to 12.
Be sure to follow Rob's instructions and make the System DSN in the 64-bit ODBC Administrator on the Server.
Yes, that's how it was set up. System DSN, 64 bit. It just doesn't show up in the list in FM.
I'm just going to wipe everything and start over, reinstall Windows, FMS, drivers, everything.