We are beginning to migrate away from Windows 2000/FMP6 to Mac OS X/FMP6 [FMP7 will be migrated to at some point, but not for a while]. Under Windows, we've got FMP able to update our MySQL db via ODBC and the MySQL AB. free driver, MyODBC.
I downloaded MyODBC for OS X on Friday, yet FMP6 would not see the MyODBC datasource [eg: when using the File->Open->ODBC Source]. I tried this with FMP7 as well, and came up with the same results.
After doing some research, it appears that the reason for this is because FMP6 [and 7?] is a CFM application, and the MyODBC driver is a Mach O application, as is the OS X ODBC administrator application. I had to download iODBC [a free ODBC administrator program for creating DSNs], and also download a 30-day evaluation of a CFM-based MySQL driver from a company called OpenLink <http://www.openlinksw.com/>.
OpenLink charges $99 per seat for their MySQL driver, but it actually does work with FMP6.
My question to y'all here is - has anyone successfully used the free MyODBC MySQL ODBC driver with FMP6 running OS X [10.3.8 in this case]? Spending $99 for something that has been free in the Windows world just leaves a bad taste in my mouth, so I am very much interested in learning if there is a way to use the MyODBC driver with FMP6.
Thanks for any info you can provide.
/vjl/