JDBC connection from remote computer
Reading the FMP docs I am under the impression that I should be able to access a FMP 11 database with JDBC connection from a remote computer:
Is this true?
I have a setup that works fine over the local WiFi:
DRIVER NAME: fmjdbc.jar
DRIVER CLASS: com.filemaker.jdbc.Driver
JDBC URL: jdbc:filemaker://10.0.1.2:2399/Product
USER NAME: Admin
If I use a similar setup, changing only the JDBC URL to use a remote address (below) it fails:
JDBC URL: jdbc:filemaker://myFMPHost:2399/Product
where myFMPHost is the static address of my FMP database (with all the port mapping correct)
The Error message I get is:
|Connection verification failed for data source: Product
com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] xDBC client must be on the same computer as FileMaker Pro
The root cause was that: com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] xDBC client must be on the same computer as FileMaker Pro
I can run the same JDBC URL against the same db uploaded to FM Server and it works fine.
-- there is a bug in FMP's JDBC implementation
-- the FMP JDBC docs are incorrect
-- FMP does not support JDBC access to a db from a remote URL
Frustrated: Which is it?
P.S. I was able to do this, several years ago, with an earlier version of FMP (7 or 8, AIR).