mac | pc Accessing Filemaker Server through ODBC/JDBC from PERL on Linux

[Richard Fincher]

Hi, I've been researching the feasibility of accessing Filemaker Server through ODBC/JDBC from PERL on Linux, and seem to have drawn a blank.  There seem to be no Filemaker ODBC drivers for Linux.  One article I found said that it is possible with JDBC, but before I start reading about that, I just wanted to check that it's definitely impossible to access FMS from PERL/Linux using ODBC.

 

Many thanks,

 

 

[Wim Decorte]

Yep, JDBC it is on Linux...

 

I'm sure the ODBC driver for OSX can be hacked to work on Linux but that obviously would not be supported.

[Richard Fincher]

Thanks Wim!

I have progressed much further with this. My firewall counts a hit on port 2399 each time I run my test script. I think I might have a driver or config problem though:

Expecting tag 0x73875f, found 0x32 at /usr/local/share/perl5/Convert/BER.pm line 379.

[Wim Decorte]

Not sure what you are asking.... port 2399 is the FMS xDBC port so it's normal that you'd see a hit there.

[Richard Fincher]

I guess I was saying that the error I am experiencing isn't preventing the connection to the server from being attempted.

[Richard Fincher]

We now have PERL scripts running on Linux inserting data into Filemaker Server through JDBC.  This was done using the Inline Java PERL module and Java Runtime Environment for Linux.