JDBC - Help! - 803 Host cannot be found

[pvandee]

Hi

I am trying to establish a connection to a FileMaker database using JDBC with Mac OSX but keep getting an "803 Host cannot be found" Error. My code (which I am very sure follows the documentation in the JDBC driver fmpjdbc12.jar recommends is

Class.forName("com.fmi.jdbc.JdbcDriver");

String url = "jdbc:fmpro:http://##.##.##.##:80/";

String username="";

String password="";

Connection con = DriverManager.getConnection(url, username, password);

Any help would be GREATLY appreciated!!!

[Anatoli]

Are those databases open in FM? How do you serve them to the JDBC?

[chrisonmaui]

1. Is web publishing turned on in your fmpro host?

Go to File -> Sharing then ensure web companion is checked.

2. Why are you using port 80? you should be using port 591 as default.

3. have a look at your settings for webcompanion

make sure you are allowing connections via http

Edit -> Preferences -> Application -> Plugins -> WebCompanion

[pvandee]

Thank you chrisonmaui!! That was it! When I went to the Configure settings under the Web Companion...80 was already in the Port Number box and this worked in the Java connection URL..is there any particular reason to use 591 instead of 80? Thanks again SO much for your help!

[Anatoli]

There can be standard web server on port 80.

Port 591 is registered with IANA for FileMaker Inc.