Easysoft ODBC-ODBC Bridge

How do I use PHP under Apache 2.0.x with OOB on Irix?

Article:
00949
Last Reviewed:
27th April 2006
Revision:
1

The Easysoft ODBC-ODBC Bridge (OOB) lets you access ODBC databases such as Microsoft Access and Microsoft SQL Server from PHP/Apache. To use the OOB with PHP under Apache 2.0.x on Irix, please note the following:

  1. Apache 2.0.x builds with threads, but by default PHP does not. To build PHP with threads, add -lpthread to LDFLAGS before configuring PHP.

    Configure and build PHP as normal, the unixODBC configure line is:

    ./configure --with-unixODBC=shared,/usr/local/easysoft/unixODBC
  2. unixODBC needs to be built with threads, but the version that ships with the OOB is not built threaded. To build a threaded unixODBC, download the source from ftp://ftp.easysoft.com/pub/unixODBC. Unzip and untar the distribution file, and then configure, build and install unixODBC by running:
    ./configure --prefix=/usr/local/easysoft/unixODBC --sysconfdir=/etc
       --enable-threads=yes --enable-drivers=no --enable-iconv=no
       --enable-stats=no --enable-gui=no
    make
    make install
  3. You need to make sure that you specify the thread-safe OOB client driver ("OOB_r") in your data sources. To do this, use "OOB_r" as the value for the Driver entry in your data sources in odbc.ini. For example:
    [demo]
    Driver          = OOB_r
    Description             = Easysoft ODBC-ODBC Bridge demo data source
    SERVERPORT              = demo.easysoft.com:8888
    TARGETDSN               = pubs
    LOGONUSER               = demo
    LOGONAUTH               = easysoft
    TargetUser              = demo
    TargetAuth              = easysoft
  4. Ensure that the web server process can find the Easysoft libraries. The simplest way of doing this is to copy (or sym-link) the libraries into the Apache lib directory:
    cp /usr/local/easysoft/lib/libesrpc_r.so /usr/local/apache2/lib/
    cp /usr/local/easysoft/lib/libessupp_r.so /usr/local/apache2/lib/
    cp /usr/local/easysoft/lib/libesextra_r.so /usr/local/apache2/lib/
    cp /usr/local/easysoft/lib/libeslicshr_r.so /usr/local/apache2/lib/

For more information about using the OOB with Apache/PHP, see Enabling ODBC support in PHP under Apache.

Applies To

Knowledge Base Feedback

* Did this content help you?
* Please select one option based on your first choice:

(* Required Fields)


Oracle is a registered trademark of Oracle Corporation and/or its affiliates.