I have a linux server running the Filemaker Pro server, with a Windows server running the web-connector (front-end). I need to be able to access our OptiGold database directly from a remote FreeBSD server, using Perl scripts preferrably. I haven't been able to find much information on how to do this, or if it's possible. AFAIK, I need to use DBI::ODBC and a FMPro driver to access the database directly, but I don't know where to find the FMPro ODBC driver for FreeBSD. I just don't know how to "talk" to the FMPro database. I think another way to get to OptiGold remotely would be to use LWP to connect to the web-connector front-end, but this seems very redundant to me because one of my goals is to take the Windows server out of the equation altogether. Can anyone give me any suggestions about accessing the OptiGold database remotely?
There isn't a way to do it without leaving a Windows/Mac server in the equation. The best method is probably XML to the web server.
Don't even bother with ODBC. It won't work. Your best bet is to wait for the OptiGold PHP/MySQL re-write.