Jan 14, 2009, 7:51 AM
Post #1 of 2
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.