Easysoft
ODBC Drivers for Oracle, SQL Server, Firebird, ISAM, InterBase, Sybase, MS Access & more.

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?
Yes
No
Maybe
 
* Please select one option based on your first choice:
I'm very satisfied
I think it will help, but I haven't tried it yet
It is helpful, but I need more information
It is helpful, but hard to understand
Seemed relevant in search results, but didn't help me
The information is incorrect
The page contains one or more broken links
 
  Suggest new content or let us know how we can improve this content:

 
  (* Required Fields)   



© 1993 - 2008 Easysoft Limited. All rights reserved.