We are moving our Filemaker system from Filemaker 11 to Filemaker 14. We have many databases hosted on our Filemaker 11 server.
My goal has been to cease new development in Filemaker 11 and to slowly port the databases from 11 to 14. This will prevent having to deal with all the user upgrade issues at the same time.
One thing I am trying to do to facilitate this is to access live FMS11 data from FMP14. You can't do this as an External Filemaker Data Source since they are not compatible So, I have enabled ODBC successfully on a database on the FM 11 server.
I installed FMP 14 Advanced and the Filemaker 14 xDBC driver on a separate Windows computer. When I ran the administrative tool 'Data Sources (ODBC)' on the client computer, I was able to create a data source using the Filemaker ODBC driver and successfully connect to the database.
I can then add the DSN as an External Data Source in a FMP 14 database on the client computer.
However, when I try to add a table from the External Data Source on the Relationship Graph, I get an error dialog box which says:
"The ODBC data source you have selected is not supported."
After seeing this problem on a Windows client, I did the same thing on a Macintosh (using ODBC Manager from Actual Technologies to create the Data Source), with the same result.
1. Is this possible?
2. Has Filemaker documented the capabilities, or lack thereof, of cross version connection via ODBC?