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

[Gjermund Gusland Thorsen]

On a microsoft server there is already ODBC drivers for MicrosoftSQL,
you just have to share a DB source and then Filemaker on a Mac can
connect to it.

I doubt you really need those drivers when dealing with Microsoft

ggt667

On 3/29/07, Dale Bengston <dbengston at preservationstudio.com> wrote:
> 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
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>
>