I am trying to run Execute SQL script to populate a particular field (password) in MySQL table to which FileMaker 13 is connected using MySQL ODBC driver. The driver is already connected and i imported the tables i need, so it works perfect all arround BUT - when i Execute SQL from FileMaker to MySql it prompts me for a username and a password for the ODBC data source and when i import the details similar to the ones i am already using to connect ODBC driver with MySQL it rejects my credentials.

I am working on Apple and the database and the ODBC driver are hosted on Windows 2012 Server if this might be important.

Could anybody tell me why is this happening and which username and password is it asking for in the first place?

Thank you

*bump* similar issue for me. I'm trying to access a QuickBooks file using ODBC, works fine with no username and password from excel, filemaker seems to want some other credentials.... but which ones ?