AnsweredAssumed Answered

Filemaker 14 Server xDBC

Question asked by bmts81 on Dec 20, 2016
Latest reply on Dec 21, 2016 by fmpdude

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)

  at java.sql.DriverManager.getConnection(DriverManager.java:664)

  at java.sql.DriverManager.getConnection(DriverManager.java:270)

 

I am without ideas...

I hare read some topics about but i am not being able to find a solution.

Can you help me?

Outcomes