I have Filemaker Server Advanced running on an Mac OSX server. The same server acts as our webserver. What I would like to do is use PHP to present and edit data through the webserver.
With a Windows server I have been able to achieve this using ODBC (Filemaker as the data source, php as the client). From what I have read I believe it is possible to do the same thing on a Mac OSX server, but have not succeded.
Filemaker on the Mac is set up to share data through ODBC. ODBC drivers are set up in OS X and checks run through ODBC administrator show a working connection.
However, when I try to connect to the ODBC data source through a php script (odbc_connect ($dsn, $db_user, $db_password)) the process freezes; there is no error message and no page is returned to the browser. In fact the browser reports that the connection is lost. I have tried connecting to a non-existent DSN and I can get a properly formed error message.
Warning: odbc_connect(): SQL error: [iODBC][Driver Manager]Data source name not found and no default driver specified. Driver could not be loaded, SQL state IM002 in SQLConnect
I have read that people have experienced some rather flaky results with an ODBC connection, but nothing to suggest that other people have experienced the same sort of problem.
Suggestions welcome.
