[FX.php List] [Off Topic] Using PHP to Query and ODBC Data Source

[Kim Hawksworth]

We have a web application built using FX.php.   I would like to query a
Progress 9.1E database running on AIX and input the results into Filemaker.
The primary web server and FMSA are running on two Xservers.  It appears the
primary web server needs to make an ODBC connection to the external data
source in order to use the PHP ODBC function.  This appears to be the rub, I
have a Window¹s ODBC driver for the Progress database but not an OS 10
driver.   I¹ve looked into a product called  ODBCNET which sets up an ODBC
router on a Windows client/server and then provides a Linux, Mac and Windows
client that connects to the router.  The company, however, says Apple does
not integrate the ODBC plug-ins with their PHP and PERL interpreters to work
with the ODBC functions that ship with OS 10.  In order for their product to
work with PHP on OS 10,  PHP has to be recompiled with their
³-with-odbcrouter² build option.  Like I said, I have access to both a
Windows Client and Server that has a driver and also a copy of FMP 8.5
client.  Any thoughts on how to get the data from the external data source
into Filemaker using a web interface would be greatly appreciated.  At this
point, I¹ve hit a wall as to a possible solution.
-- 
Kim David Hawksworth, R.Ph., Web Manager
The OSUMC Dept. of Pharmacy
410 W. 10Th Ave, Room 368 Doan
Ph# (614) 293-3765
Pager# (614) 730-8143
Email: kim.hawksworth at osumc.edu
     
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070328/42f9b386/attachment.html