v5:database:odbc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
database:odbc [2015/11/26 19:07] – [Support Status] mnewnham | v5:database:odbc [2016/01/13 01:53] – ↷ Links adapted because of a move operation mnewnham | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== ODBC ===== | + | ====== ODBC ====== |
+ | ~~NOTOC~~ | ||
In addition to the genric ODBC driver for use with Windows ODBC drivers, there are additional ODBC drivers that provide extended support for database specific functions | In addition to the genric ODBC driver for use with Windows ODBC drivers, there are additional ODBC drivers that provide extended support for database specific functions | ||
- | * **odbc_mssql**. | + | ----------------------- |
- | * **odbc_oracle**. | + | ===== odbc ===== |
- | * **odbc_db2**. This driver | + | <WRAP right box round 300px> |
+ | == Specification == | ||
+ | ^Driver Name|odbc| | ||
+ | ^Data Provider|odbc| | ||
+ | ^Status|Active((This driver is actively supported by ADOdb project members))| | ||
+ | ^Windows|Yes| | ||
+ | ^Unix|No| | ||
+ | ^ADOdb V5|Yes| | ||
+ | ^ADOdb V6|Yes| | ||
+ | == Alternatives == | ||
+ | [[v5:database:pdo#pdo_odbc|PDO driver for ODBC]] | ||
+ | </ | ||
+ | * This generic driver | ||
+ | * Connections can only be made using DSN connection strings or pre-defined ODBC connections. | ||
+ | | ||
+ | | ||
+ | * When configuring connections on Windows, ensure that the ODBC driver | ||
+ | ==== Setting The Cursor Mode ==== | ||
+ | All ADOdb ODBC drivers can configure an appropriate cursor mode. The following modes are available through PHP. | ||
+ | * SQL_CUR_USE_IF_NEEDED | ||
+ | * SQL_CUR_USE_ODBC | ||
+ | * SQL_CUR_USE_DRIVER | ||
+ | The cursor is set by setting | ||
+ | <code php> | ||
+ | include | ||
+ | $db = newAdoConnection(' | ||
- | < | + | $db-> |
- | |Driver Name|odbc| | + | |
- | |Status|Active| | + | $db-> |
- | |Windows|Yes| | + | </ |
- | |Unix|No| | + | |
+ | |||
+ | ------------------------------ | ||
+ | ===== odbc_mssql ===== | ||
+ | < | ||
+ | == Specification == | ||
+ | ^Driver Name|odbc_mssql| | ||
+ | ^Data Provider|odbc| | ||
+ | ^Status|Active((This driver is actively supported by ADOdb project members))| | ||
+ | ^Windows|Yes| | ||
+ | ^Unix|No| | ||
+ | ^ADOdb V5|Yes| | ||
+ | ^ADOdb V6|Yes| | ||
+ | == Alternatives == | ||
+ | [[v5: | ||
</ | </ | ||
- | This preferred | + | When used on Windows clients, this driver needs the Microsoft SQL server native client. There are feature limitations compared to the '' |
+ | --------------------------- | ||
+ | ===== odbc_oracle ===== | ||
+ | <WRAP right box round 300px> | ||
+ | == Specification == | ||
+ | ^Driver Name|odbc_oracle| | ||
+ | ^Data Provider|odbc| | ||
+ | ^Status|Active((This driver | ||
+ | ^Windows|Yes| | ||
+ | ^Unix|No| | ||
+ | ^ADOdb V5|Yes| | ||
+ | ^ADOdb V6|Yes| | ||
+ | </ | ||
+ | --------------------------------------------- | ||
+ | After connection, the date format is automatically set **by the driver** by executing the following statement: | ||
+ | <code php> | ||
+ | $sql = "ALTER SESSION SET NLS_DATE_FORMAT=' | ||
+ | $db-> | ||
+ | </ | ||
+ | ----------------------------------- | ||
+ | ==== odbc_db2 ==== | ||
+ | <WRAP right box round 300px> | ||
+ | == Specification == | ||
+ | ^Driver Name|odbc_db2| | ||
+ | ^Data Provider|odbc| | ||
+ | ^Status|Inactive((This driver is not actively supported or enhanced by ADOdb project members, but you can provide fixes and enhancements if you have the expertise))| | ||
+ | ^Windows|Yes| | ||
+ | ^Unix|No| | ||
+ | ^ADOdb V5|Yes| | ||
+ | ^ADOdb V6|Yes| | ||
+ | == Alternatives == | ||
+ | [[v5: | ||
+ | </ | ||
+ | Connects | ||
+ | ------------------------------------------ | ||
+ | <WRAP tip> | ||
+ | If the driver supports it setting the Cursor Type to '' | ||
+ | </ | ||
+ | <WRAP tip> | ||
+ | == USING CLI INTERFACE == | ||
- | ===== Support Status ===== | + | There were reports that the $host and $database params have to be reversed in Connect() when using the CLI interface. |
- | This driver is actively supported by ADOdb project members | + | </ |
+ | <WRAP tip> | ||
+ | == System Error 5 == | ||
+ | IF you get a System Error 5 when trying to Connect/ | ||
+ | to DB2 full rights to the DB2 SQLLIB directory, and place the user in the DBUSERS group. | ||
+ | |||
+ | </ | ||
+ | |||
+ | ------------------------------------------------- | ||
===== Feature Limitations ===== | ===== Feature Limitations ===== | ||
- | ODBC connections have functionality limitations include transactional handling. See the [[reference:feature|Feature Matrix]] for more information | + | ODBC connections have functionality limitations include transactional handling. See the [[v5:database: |
{{tag> | {{tag> | ||
- |
v5/database/odbc.txt · Last modified: 2021/01/11 09:59 by peterdd