Filemaker Server 11 on Server 2008 X64 MySql ODBC connection issues
Im trying to setup an ODBC connection between our Mysql and Filemaker servers. I have read around for the last two days and have found similar issues but their resolutions are to no avail to me. I first installed the odbc driver for server 2008 and then went to create the system dsn and it went great! Untill i went to add the data source in filemaker and there were no datasources in the ODBC list. Then I found that there isn't a compatabe 64x driver and i would have to use the 32 bit driver. I uninstalled the version 5.xx and installed the 3.xx version that was compatable and no mysql driver shows up when trying to setup the system dsn in Server 2008 ODBC setup. Am I missing something? FYI I am running MySql 5.0.45.
Thanks for your help!