JDBC accessing FMP file

[stanley]

Hi all

We're developing a java application which is a sort of multimedia database front end. On the Windows side it uses Microsoft Access as the data source, and works fine. On the Mac side, I had hoped to use FMP as the data source, but can't get it to work.

I've gone through all the info I could find on it, have the data access stuff on, ODBC control panel, etc, but the thing just won't go. Does anybody know enough about this to fill me in on what I may be missing?

I realize this isn't really the right place to ask this question, but I can't think of where else to go.

Thanks

Stanley

[Anatoli]

Did you consider trying CDML served from FileMaker's WebCompanion?

ODBC is not really workable option. Very slow and quirky.

[stanley]

I think what's going to end up happening is that we'll not use FileMaker at all - the thing has to work using ODBC/JDBC/SQL because (although this is only the single-user version) there is an enterprise version which will hook up to a database server - whatever the client wants - and FMP has the added caveat of having to be open in order for the data source to be readable.

I had just hoped that I had missed something in the FMP docs or whatever, and that I could make a single-user version work with FMP. I think that's just not going to happen.

Thanks again,

Stanley