AnsweredAssumed Answered

FMP12A worked fine with ODBC to MySQL but FMP14A won't

Question asked by rowland_carson on Jul 1, 2015
Latest reply on Oct 2, 2015 by beverly

For about 6 years I've been using the Actual ODBC drivers to connect FMP as a client to various MySQL databases, both on my local machine and on remote servers. Most recently I've been running FMP12A on a MacBook Pro with OS X 10.9.5.


I've just bought the FMP14A upgrade and am in process of checking that my existing FMP files work OK with the new version of FileMaker. All the plain-vanilla FMP-only files seem to open and work perfectly in FMP14A just as in FMP12A, and all the scripts etc seem happy. However, I'm having problems getting any file working that acts as a client to a MySQL database.


I wondered if the Actual Technologies driver needed to be updated, so I checked for a new version and paid $14.95 for an upgrade - but installing this did not change my symptoms at all.


As a sanity check, I created a new system DSN using the ODBC Manager, then created a new FMP file and tried to use the new DSN to connect it to a MySQL database, and still the symptoms (see next para) are the same.


I set up the data source from the "manage external data sources" menu and specify a user name & password (same as used in the ODBC Manager to set up the DSN). When I try to create a table occurrence on the relationship graph for the MySQL shadow table It asks again for the user name & password, I fill those in, and immediately the dialogue window re-appears with empty fields asking for the user name & password. I did try entering them repeatedly but gave up after the 3rd or 4th repetition as it seemed to be an infinite loop.


The first MySQL-client file that I opened in FMP14A would not work when I opened it again in FMP12A either. I eventually got it functioning in FMP12A again after deleting the external data source and re-specifiying it. I then had to re-sync and also re-connect fields as they all came up <file missing>.


I've also noticed that I am getting new messages on opening existing files in FMP12A such as asking for Keychain access and sometimes something about sharing files which I can't quite remember.


I feel sure I must be doing something really elementary that is wrong, but can't see it. All suggestions welcome!


in friendship