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

Easysoft ODBC-ODBC Bridge

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

Article:
00949
Last Reviewed:
24th January 2024
Revision:
1

The Easysoft ODBC-ODBC Bridge lets you access ODBC databases such as Microsoft Access and Microsoft SQL Server from PHP/Apache. To use the ODBC-ODBC Bridge 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 .
  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. You need to 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, 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)