I am trying to connect Filemaker to MySQL using ODBC connection. I successfully connected Filemaker Pro 14 and MySQL using the ActualTech ODBC drivers for open source databases. Now, I want to connect FileMaker Server 16 to MySQL db using the ODBC connection. I followed the same procedure as the previous one for this connection but it doesn't seem to work with the FM Server.
My problem is that whenever I try to create a relationship graph and select a particular data source, it asks for the data source's username-password but it doesn't accept my username password and neither does it give any error.
However, a similar dialogue box pops up when I try to import records and the username-password combination works, which is weird.
I am new to FileMaker and it would be great if someone could help me solve this problem.