We are trying to connect a Filemaker database to Drupal. heres the 802 error:

 

http://acwa.asn.au:8080/fmi/xml/FMPXMLRESULT.xml?-db=test1.fp13&-layoutnames

 

We've being using the following:

 

https://github.com/yodarunamok/fxphp

 

W can't figure out why Drupal can't find the Filemaker databases.

 

 

FileMaker help says:

 

802

Unable to open file.

This error can be caused by one or more of the following:

 

Invalid database name

File is closed in FileMaker Server

Invalid permission

 

I suspect -db=Test1.fp13 is the culprit

 

The extension is not required

 

Specifically, p53 from the Cutsom Web Publishing guide states:

 

–db (Database name) query parameter

Specifies the database that the query command is applied to

Value is: Name of the database, not including the filename extension if any

Note When specifying the name of the database for the –db parameter in query strings, do not include a filename extension. The actual database filename can optionally include an extension, but extensions are not allowed as a value for the –db parameter.

I use the Actual Open Source ODBC connector to allow filemaker to connect to the MySQL databases. Exposes the MySQL as external sources in FMP.

http://www.actualtech.com

JP