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

[Dale Bengston]

I am using PHP, OS X Server and Actual Technologies ODBC drivers to  
pull data from Microsoft SQL Server. I am using the built-in PHP ODBC  
functions. I did not do anything special other than download and  
install the ODBC drivers to make this work. I did not have to  
recompile PHP or any of that. It all just worked.

Actual's drivers are $30, and it was one of the best investments I  
ever made, especially for the amount of integration it afforded me  
between my FileMaker stuff and my client's "more standard" (yeah I  
know) data source. Actual makes OS X ODBC drivers for SQL Server,  
Sybase, Oracle, MySQL, PostgreSQL, Access, and OpenBase. As far as I  
know, no one - including Actual Technologies - has an OS X version of  
a Progress ODBC driver.

It is probably true that you have to recompile PHP to support their  
non-standard implementation of ODBCNET. I see two options - recompile  
PHP as they have suggested, or move your Web Publishing Engine to a  
Windows server that has the Progress ODBC access.

Hope this helps,
Dale

On Mar 28, 2007, at 3:56 PM, Kim Hawksworth wrote:

> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.iviking.org/pipermail/fx.php_list/attachments/20070328/981d0b78/attachment-0001.html