I've written an application which uses JDBC to connect to a FMP database. It works fine on my test system (shared via JDBC in FMP9 on Windows), but I can't get it to connect to the live database, which is running in FMP9 Advanced Server on MacOS X.

Closer investigation (with netstat) indicates that the FMP server is not listening on port 2399 for incoming connections. I have read as much of the documentation as I can find, and consequently have:

• Enabled plugins in the server
  
• Enabled ODBC/JDBC in the database
  
• Added the the xDBC permissions to all users defined in the database
  
• Reuploaded the database to the server
  
• Restarted the server
  

None of these has made the server start listening on port 2399.

What am I doing wrong?

When you say you've enabled ODBC/JDBC on the database, is that the .fp7 file? Have you turned on ODBC sharing in the FM Server options?

Edited August 20, 201015 yr by Guest
Additional thought

Yes, I've enabled ODBC/JDBC in the database.

The server shows ODBC/JDBC as ticked next to the database in the database listing.

Like I said, this database works fine with JDBC in the desktop version of FMP9 on my test/development system. It's just the server I can't persuade to work.

Edited August 20, 201015 yr by Guest
Answered the other point too

A firewall issue?

No, I'm pretty sure it's not a firewall issue. I'm working purely on localhost, and I'm checking via netstat: there is nothing listening on port 2399 at all.

Unless a firewall is capable of preventing FMP from even opening a port, without FMP reporting an error (which it isn't doing), this isn't a firewall issue.