ODBC是“开放数据库互联的简称”(Open Database Connectivity)的简称。ODBC是MicroSoft公司提出的应用程序通用编程接口标准,用于对数据库的访问。
ODBC实际上是一个数据库访问函数库,使应用程序可以直接操纵数据库中的数据。ODBC是基于SQL语言的,是一种在SQL和应用界面之间的标准接口,他解决了嵌入式SQL接口非规范核心,免除了应用软件随数据库的改变而改变的麻烦。ODBC的一个显著优点是,用它生成的程序是与数据库或数据库引擎无关的,为数据库用户和开发人员屏蔽了异构环境的复杂性,提供了数据库访问的统一接口,为应用程序实现与平台的无关性和可移植性提供了基础,因而ODBC获得了广泛的支持和应用。
安装
- --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. 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. 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 someodbc.hin 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). 
PHP的 Windows 版本已内建对此扩展的支持。不需要载入额外的扩展来使用这些函数。
As of PHP 7.0.0, however, Windows users must enablephp_odbc.dllin order to use this extension.
运行时配置
这些函数的行为受php.ini中的设置影响。
| 名字 | 默认 | 可修改范围 | 更新日志 | 
|---|---|---|---|
| odbc.default_db * | NULL | PHP_INI_ALL | |
| odbc.default_user * | NULL | PHP_INI_ALL | |
| odbc.default_pw * | NULL | PHP_INI_ALL | |
| odbc.allow_persistent | "1" | PHP_INI_SYSTEM | |
| odbc.check_persistent | "1" | PHP_INI_SYSTEM | |
| odbc.max_persistent | "-1" | PHP_INI_SYSTEM | |
| odbc.max_links | "-1" | PHP_INI_SYSTEM | |
| odbc.defaultlrl | "4096" | PHP_INI_ALL | |
| odbc.defaultbinmode | "1" | PHP_INI_ALL | |
| odbc.default_cursortype | "3" | PHP_INI_ALL | Available as of PHP 5.3.0 | 
