Download ODBC Drivers for Oracle, SQL Server, Salesforce, MongoDB, Access, Derby, InterBase & DB2.

How do I use PHP under Apache 2.0.x with the ODBC-ODBC Bridge on Irix?

The Easysoft ODBC-ODBC Bridge lets you access ODBC databases such as Microsoft Access and Microsoft SQL Server from Apache > PHP. To use the ODBC-ODBC Bridge with PHP under Apache 2.0.x on Irix, 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.
  2. Configure and build PHP as normal. Include this: 
    ./configure --with-unixODBC=shared,/usr/local/easysoft/unixODBC

    on the PHP configure line.

  3. unixODBC needs to be built with threads, but the version that ships with the ODBC-ODBC Bridge is not built threaded. To build a threaded unixODBC, download the source, unpack 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
  4. Make sure that you specify the thread-safe ODBC-ODBC Bridge client driver (ODBC-ODBC Bridge_r) in your data sources. To do this, use ODBC-ODBC Bridge_r as the value for the Driver entry in your data sources in odbc.ini. For example: 
    [demo]
Driver          = ODBC-ODBC Bridge_r
Description             = Easysoft ODBC-ODBC Bridge demo data source
SERVERPORT              = demo.easysoft.com:8888
TARGETDSN               = pubs
LOGONUSER               = demo
LOGONAUTH               = easysoft
TargetUser              = demo
TargetAuth              = easysoft
  5. Ensure that the web server process can find the Easysoft libraries. The simplest way of doing this is to copy (or symlink) 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 ODBC-ODBC Bridge with Apache > PHP, refer to Enabling ODBC support in PHP under Apache.