PDO_ODBC is a driver that implements the PHP Data Objects (PDO) interface to enable access from PHP to databases through ODBC drivers or through the IBM DB2 Call Level Interface (DB2 CLI) library. PDO_ODBC currently supports three different "flavours" of database drivers:
Supports access to IBM DB2 Universal Database, Cloudscape, and Apache Derby servers through the free DB2 client.
Supports access to database servers through the unixODBC driver manager and the database's own ODBC drivers.
Offers a compile option for ODBC driver managers that are not explicitly supported by PDO_ODBC.
On Windows, PDO_ODBC is built into the PHP core by default. It is linked against the Windows ODBC Driver Manager so that PHP can connect to any database cataloged as a System DSN, and is the recommended driver for connecting to Microsoft SQL Server databases.
As of PHP 5.1, PDO_ODBC is included in the PHP source. You can compile the PDO_ODBC extension as either a static or shared module using the following configure commands.
./configure --enable-pdo_odbc=ibm-db2,/opt/IBM/db2/V8.1/ |
If you do not supply a location for the DB2 libraries and headers to the configure command, PDO_ODBC defaults to /home/db2inst1/sqllib.
./configure --enable-pdo_odbc=unixODBC,/usr/local |
./configure --enable-pdo_odbc=generic,/usr/local,libname,ldflags,cflags |
Поведение этих функций зависит от установок в php.ini.
Таблица 1. PDO_ODBC Configuration Options
| Name | Default | Changeable | Changelog |
|---|---|---|---|
| pdo_odbc.connection_pooling | "strict" | PHP_INI_ALL |
Краткое разъяснение конфигурационных директив.
Whether to pool ODBC connections. Can be one of "strict", "relaxed" or "off" (equals to ""). The parameter describes how strict the connection manager should be when matching connection parameters to existing pooled connections. strict is the recommend default, and will result in the use of cached connections only when all the connection parameters match exactly. relaxed will result in the use of cached connections when similar connection parameters are used. This can result in increased use of the cache, at the risk of bleeding connection information between (for example) virtual hosts.
This setting can only be changed from the php.ini file, and affects the entire process; any other modules loaded into the process that use the same ODBC libraries will be affected too, including the Unified ODBC extension.
| Внимание |
relaxed matching should not be used on a shared server, for security reasons. |
Подсказка: Leave this setting at the default strict setting unless you have good reason to change it.
| Пред. | Начало | След. |
| odbc_tables | Уровень выше | PDO_ODBC DSN |