[FX.php List] FX.php and SQL queries against FMSA 8

[John Phillip Barclay]

My understanding is the FX.php is designed to avoid the Filemaker ODBC
by using the XML/Web publishing interface for filemaker.  I tried using
the PHP ODBC class
(http://us2.php.net/manual/en/function.odbc-execute.php) on a recent
project to connect to FMP in PHP and found the following limitations:

- documentation was incomplete
- buggy behaviour. This could be on the php or fmp odbc side as I never
bothered to pin it down.
- slow performance.  Oh it was terrible.
- lack of a user community.  Not much dialog or documentation on odbc
and filemaker.

After switching to FX.php I found performance to be quicker and haven't
found any bugs besides working with portals.  It seems that Filemaker
isn't really designed for ODBC.  The documentation is good and along
with this listserve and Google have answered all my questions thus far.

PEAR:DB supports many popular databases, but not Filemaker.  My guess is
that is because of the ODBC limitations of filemaker and the success of
FX.php.  I'm not sure if there is much motivation to adapt it form
filemaker.


John Barclay , Champaign, Illinois, U.S.


 


-----Original Message-----
From: fx.php_list-bounces at mail.iviking.org
[mailto:fx.php_list-bounces at mail.iviking.org] On Behalf Of Jason H
Awbrey
Sent: Tuesday, April 04, 2006 4:52 PM
To: FX.php Discussion List
Subject: [FX.php List] FX.php and SQL queries against FMSA 8

Hello all,

Has anyone used FX.php to query FileMaker via the ODBC interface? It
seems as though I would need to specify a DSN somewhere but don't see
anywhere I would be able to do that. Does anyone have a simple example
they could share that could get me pointed in the right direction?

Cheers,
Jason
_______________________________________________
FX.php_List mailing list
FX.php_List at mail.iviking.org
http://www.iviking.org/mailman/listinfo/fx.php_list