I set up a client ODBC driver for FMS 19 using the latest download (18) from the Claris download site I saw.
I set up the ODBC driver dialog on the Mac to access FMS and it looked like everything was OK. No errors reported. Used IP address of FMS not the web direct "https://.../fmi/webd/..." syntax.
But, when I enter the user name and password when trying to add an ODBC table to a local FMP table (all FMP files have ODBC/JDBC enabled), I get this (not useful at all) error:
I tried, then, to use a simple JDBC connection to the same database in FMS locally and that worked fine. ODBC/JDBC are enabled on FMS so it's not a 2399 port issue.
Alternatively, I tried to use the File..Manage..External Data Sources approach, but that didn't work either.
I noticed that even trying to create an ODBC connection on the server itself failed as the 64-bit ODBC manager couldn't find any opened databases (either using "localhost" or the server's IP address).
Would appreciate suggestions how to get ODBC working.