Ciao, I have this setup:
- OSX 10.12.6 Sierra
- FMP 16
- Oracle ODBC connector (MySQL :: Download Connector/ODBC)
- ODBC Manager (Mac OS X: ODBC Manager)
- A local MySQL server (version 5.6.35) with a fmp_demo Database
Thru ODBC Manager I've created A connection using the Unicode Driver
I've set the DNS with this settings:
I then Connected FMP thru the External Database Source manager:
Then in the Database Manager I added a relationship getting it from the ODBC source:
The result I get is a "Query in progress" window:
At it's end I get this error:
I've tried checking the credentials and everything is ok. I'm saying the credentials an data are ok because I did the same exacts steps with the "Actual Technologies ODBC Open Soure DB Connection" found here: Software downloads: Mac ODBC connectivity by Actual Technologies and everything works perfectly.
What can be wrong?