Home: Perl Programming Help: DBI:
Using DBD::ODBC to connect to FileMakerPro remotely.

New User

Jan 14, 2009, 7:51 AM

Views: 5628
Using DBD::ODBC to connect to FileMakerPro remotely.

I'm looking for the best solution to query a FileMakerPro database that is running on a remote server using DBI. From my research, it seems that I could do this using DBD::ODBC if I were running the perl script on windows using a ODBC FileMakerPro driver available on the windows format. Is there such a driver(s) that will allow me to use DBD::ODBC if my perl script is running on Mac OS X or Linux?

So far the only solution I've come up with that will work platform independent is to use a JDBC FileMakerPro driver and then use DBD::JDBC to make the database connection. While this works it's a bit cumbersome as I have to start a JDBC server loaded with the FileMakerPro driver first before I can query my FileMakerPro database server.

If I could use DBD::ODBC, this would make the script much easier for the end user to run. Thanks, your help will be much appreciated.

Veteran / Moderator

Jan 14, 2009, 9:15 AM

Views: 5626
Re: [madflava] Using DBD::ODBC to connect to FileMakerPro remotely.

You should install the ODBC driver libs before installing DBD::ODBC

google: FileMaker Pro ODBC linux or mac