please re-insert the images, all we see is a broken link. Looks like something happened once you posted your question. The best format to use is .png.
1 of 1 people found this helpful
OK. Just after posting this, it occurred to me that I needed to create an empty database first and to enable JDBC access in the sharing and admin account security settings.
Sure enough, that was it!
Since this bump took a few hours to work through, any other general advice or "how-to's"on using SQLEditor with FileMaker would be very much appreciated!
I think Failed to Connect says it all, SQLEditor was not able to connect to the FileMaker database.
Are FileMaker and SQLEditor running on the same computer ? Make sure the port is open if so. Did you check the JDBC driver is installed and working ?
In the connection URL, the port is specified (from you screenshot). The example I found out in the FileMaker Guide (for V13), the port is not part of it: jdbc:filemaker://192.168.1.1/database I can't tell if that's an issue.
Are you sure about the user and password ?
I don't have access to SQLEditor and don't know if it works with both FMS and FMP as the server.
I found posts dating back to 2010 when searching for "SQLeditor" in this forum.
If you have further questions, start a new thread and be sure to mention anyone you think should see the post. Try not to just PM people as many can benefit from the discussions!
Keep us posted on your progress user29402!
It took me a little work to get SQL Editor to work with FMP the first time I tried it way back when also. I actually found a bug that Malcolm (the SQL Editor developer) promptly fixed. I haven't upgraded to version 3 yet so maybe things are easier yet in the new version.