I am attempting an ODBC connection between Filemaker and Prestashop (externally hosted mysql server).
I have set up the DSN Manager on the server with server, port, database, user etc.
When trying to add an occurence from the DSN to the relationship graph, the system appears to be making a connection but keeps running. After a while, I am prompted for my login and password again, then it runs again without results, asks for my login credentials, and again, and again.
My database is hosted on FM Server 14 on MacOS 10.9.
I have tried adding the occurences through both FMPA 14 on Mac OS and FMP 14 on Windows 7 (both on different machines than the server machine).
Any ideas what I'm doing wrong?