On Thu, 2012-02-02 at 08:42 -0600, sillentkil wrote:> Hi,
> I got a big project where i need to read an visual fox pro database,
> got this working on a windows server running php. But i would like to
> run this app on a linux machine(ubuntu 11.10). My idea was to use wine
> to setup the odbc driver and connect to it using php running on my
> linux machine. Now my question is if this is posible?
>
PHP has a native ODBC implementation for Linux, so why go to the trouble
of adding Wine to the mix? PHP also offers an ODBC alternative via PEAR.
Both work just fine, though I'll admit I used them to access PostgreSQL
rather than FoxPro.
There doesn't seem to be a native FoxPro driver for PHP ODBC, but there
is a workround. PHP ODBC can link in Unified ODBC's unixODBC, which
supports ODBC-ODBC Bridge. This, it says, allows access to any ODBC
data source on a Windows machine. Links:
native ODBC
http://php.net/manual/en/intro.uodbc.php
unixODBC
http://www.unixodbc.org/
ODBC-ODBCbridge
http://www.easysoft.com/products/data_access/odbc_odbc_bridge/index.html
I've used unixODBC in the past in a very different environment (on a DEC
Alpha machine to access the Red Brick data warehouse via its standard
Windows ODBC driver from C programs. That 'just worked', so there's
no
reason it wouldn't work equally well from PHP on Linux. unixODBC acts as
a wrapper for the Windows ODBC driver.
Alternatively you can use PEAR, http://pear.php.net/ - specifically the
DB-odbtp package, http://pear.php.net/package/DB_odbtp which provides
access to Win32-ODBC databases.
Martin