LXXII. Unified ODBC Functions
Introduction
In addition to normal ODBC support, the Unified ODBC functions
in PHP allow you to access several databases that have borrowed
the semantics of the ODBC API to implement their own API.
Instead of maintaining multiple database drivers that were
all nearly identical, these drivers have been unified into
a single set of ODBC functions.
The following databases are supported by the Unified ODBC
functions: Adabas D, IBM DB2, iODBC, Solid, and Sybase SQL
Anywhere.
Note: There is no ODBC involved when connecting to the
above databases. The functions that you use to speak natively
to them just happen to share the same names and syntax as
the ODBC functions. The exception to this is iODBC. Building
PHP with iODBC support enables you to use any ODBC-compliant
drivers with your PHP applications. iODBC is maintained
by OpenLink Software. More information on iODBC, as well
as a HOWTO, is available at www.iodbc.org.
Requirements
To access any of the supported databases you need to have
the required libraries installed.
Installation
--with-adabas[=DIR]
Include Adabas D support. DIR is the Adabas base install
directory, defaults to /usr/local.
--with-sapdb[=DIR]
Include SAP DB support. DIR is SAP DB base install directory,
defaults to /usr/local.
--with-solid[=DIR]
Include Solid support. DIR is the Solid base install directory,
defaults to /usr/local/solid.
--with-ibm-db2[=DIR]
Include IBM DB2 support. DIR is the DB2 base install directory,
defaults to /home/db2inst1/sqllib.
--with-empress[=DIR]
Include Empress support. DIR is the Empress base install
directory, defaults to $EMPRESSPATH. From PHP 4, this option
only supports Empress Version 8.60 and above.
--with-empress-bcs[=DIR]
Include Empress Local Access support. DIR is the Empress
base install directory, defaults to $EMPRESSPATH. From PHP
4, this option only supports Empress Version 8.60 and above.
--with-birdstep[=DIR]
Include Birdstep support. DIR is the Birdstep base install
directory, defaults to /usr/local/birdstep.
--with-custom-odbc[=DIR]
Include a user defined ODBC support. The DIR is ODBC install
base directory, which defaults to /usr/local. Make sure
to define CUSTOM_ODBC_LIBS and have some odbc.h in your
include dirs. E.g., you should define following for Sybase
SQL Anywhere 5.5.00 on QNX, prior to run configure script:
CPPFLAGS="-DODBC_QNX -DSQLANY_BUG" LDFLAGS=-lunix
CUSTOM_ODBC_LIBS="-ldblib -lodbc".
--with-iodbc[=DIR]
Include iODBC support. DIR is the iODBC base install directory,
defaults to /usr/local.
--with-esoob[=DIR]
Include Easysoft OOB support. DIR is the OOB base install
directory, defaults to /usr/local/easysoft/oob/client.
--with-unixODBC[=DIR]
Include unixODBC support. DIR is the unixODBC base install
directory, defaults to /usr/local.
--with-openlink[=DIR]
Include OpenLink ODBC support. DIR is the OpenLink base
install directory, defaults to /usr/local. This is the same
as iODBC.
--with-dbmaker[=DIR]
Include DBMaker support. DIR is the DBMaker base install
directory, defaults to where the latest version of DBMaker
is installed (such as /home/dbmaker/3.6).
To disable unified ODBC support in PHP 3 add --disable-unified-odbc
to your configure line. Only applicable if iODBC, Adabas,
Solid, Velocis or a custom ODBC interface is enabled.
The windows version of PHP has built in support for this
extension. You do not need to load any additional extension
in order to use these functions.
