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.