I am using FileMaker 19 on a Windows 2016 server. The database is MySQL 8 because there is functionality I need in that version.
The ODBC driver is the MySQL driver version 8.
I have been having problems with FileMaker not recognising SQL views. Everything works okay but to get FileMaker to recognise the sequel views, I have to go to the database configuration and sync the views. As soon as that is done the application works on a browser from the server and on FileMaker pro or a client.If I log off and log back on again, I have to re-sync the views.I'm not having any other problems.
Looking at the documentation FileMaker only supports MySQL 5.7.
I don't know if there are options to use on the ODBC driver or whether FileMaker need to change the code.
Is there any way around this problem please otherwise my only option is to move to another database which is going to be a lot of work.
December 22, 2020 05:03AM
December 22, 2020 10:03AM
December 22, 2020 12:56PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.