Try changing the port to 2399.
The port is set to 2399, the original post was a typo.
Thank you for your post.
Your settings look fine.
Just to be clear, did you run the test connection with FMServer_Sample.fp7? If not, try that first. If successful, then try it with your other file. If it is unable to open the file (error 802), make sure Admin Console displays your file under "Databases" with a check mark under the ODBC/JDBC column.
Please continue to keep us posted with any additional information.
I cannot find a file called FMServer_Sample.fp7. I do not have the server edition of FM Pro 10, I have Advanced. I did try it with a file called sample.fp7 and it gave me the same error (error 802).
I also want to make sure that I am looking in the right place for the Admin Console. I can't find a window that is titled Admin console. Could you please tell me where you are looking.
Sorry for the confusion. I obviously missed the statement that you were using FileMaker Pro Advanced. The posts I replied to previously involved something similar with FileMaker Server, so I assumed incorrectly. Therefore, all of the Admin Console instructions do not apply.
Since this fails at the "Test Connect", go back into "Sharing -> ODBC/JDBC..." and verify ODBC/JDBC is turned on. Then, while still in that same dialog box, select the file in the lower left corner, and then on the right side, make sure the Access privileges is set to All users. If it was set to "No users", this would cause an error.
Sorry again for the previous information. Please continue to keep me updated with any progress.
I have checked the settings on the "Sharing -> ODBC/JDBC..." and ODBC is turned on, the Access privileges for my file is set to All Users.
Thanks for your thoughts. Any other suggestions?
Hi did you ever get a response to this message?
I have got this working on a Mac but am getting the same problem as you on Windows...