I don't have the install "disks" handy, and it's been quite a while, but isn't there a special JDBC installation folder in the installation disks (or DMG) for the JDBC install itself?
I use the JDBC connection from a Java IDE all the time to FM. Works fine.
Check this out: https://fmhelp.filemaker.com/docs/13/en/fm13_odbc_jdbc_guide.pdf
Thanks for the response.
I have the install disks and the guide. The problem is the ODBC Manager app referred to in the guide is no where to be found after the ODBC driver install.
On your Mac, do you see the path: /Library/ODBC/FileMaker ODBC.bundle
If not, then it's not installed.
(note: Although the path above should make it clear, this is the Library under the root directory, NOT the Library folder under your user folder (~))
If you do see the package FileMaker ODBC.bundle, then you could try to download and install the "ODBC Manager" program. I got mine from "Actual", a company that makes ODBC drivers for FileMaker.
See the screenshot below.
I needed to download the ODBC Manager.
BTW, if you find yourself wanting to do any data analysis beyond the rudimentary "QBE" (Query By Example) offered by FMP, you might want to use a Java IDE like Eclipse or other with a "database" pane where you can connect to your FMP database using JDBC.
Using a real database console will let you resize windows, do native queries, get real SQL error messages (not the maddening "?") and have lots of other benefits - like being able to save to varying formats like CSV, XML, TAB, ....
I'll occasionally use the Data Viewer (in FMP Advanced), but its "Results" window is so teeny tiny, it's not really usable for anything other than the simplest data analysis. Plus, you have to use "ExecuteSQL" and its syntax vs regular SQL.
There is also another SQL solution out there that is native FMP, but I don't really care for it.