Adding a ODBC Table to the Relationship Graph Error
I have set up the ODBC drivers on our FMP server, with a local FMP app on the server, I can access a small mysql table that I would like to host on our serever, make a FMP DB from the data, delete the data and re-import it.
My problem is when I then try to add the ODBC table to a Relationship Graph, I can see the driver, save the password etc. but when it tries to add the table, FMP hangs for a while then I get the following error message.
ODBC communication / Link error. Please check your network connection and / or database server