Hello Filemaker Community,
I am working in a filemaker server v14 and trying to establish a JDBC connection to the server.
The ODBC/JDBC sharing is enabled and the users have the right permissions (fmxdbc, fmapp).
The database does not contain no spaces, no |, no _, no -, no special characters, and it contains a single table with 2 fields.
The server OS is Mac OS X Yosmitte, the server is listening on port 2399.
I installed in the client (Mac OS X El Capitan) the JDBC and ODBC client drivers version 15.
I tested the connection and i can reach the server on port 2399.
When finishing the ODBC system DSN the test returns success.
At this point I am also able to see the shared databases at the server on the dsn wizard.
So far so good, the problems start here.
If i try with excel to use system DSN to retrieve data from server when it raises an unhandled exception and excel crashes.
Using a tool to test ODBC connections it connects, but i cannot execute any SQL commands.
When using a simple java project it returns:
com.filemaker.jdbc.FMSQLException: [FileMaker][FileMaker JDBC] (802): Unable to open file
at com.filemaker.jdbc1.CommonJ1Connection.openConnection(Unknown Source)
at com.filemaker.jdbc.Driver.connect(Unknown Source)
I am without ideas...
I hare read some topics about but i am not being able to find a solution.
Can you help me?