v5:database:odbc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
database:odbc [2015/12/03 20:17] – mnewnham | v5:database:odbc [2020/01/13 13:07] – Add tier2 tag dregad | ||
---|---|---|---|
Line 14: | Line 14: | ||
^ADOdb V6|Yes| | ^ADOdb V6|Yes| | ||
== Alternatives == | == Alternatives == | ||
- | [[database: | + | [[v5:database: |
</ | </ | ||
* This generic driver can be used with any database with ODBC connection support. | * This generic driver can be used with any database with ODBC connection support. | ||
Line 26: | Line 26: | ||
* SQL_CUR_USE_ODBC | * SQL_CUR_USE_ODBC | ||
* SQL_CUR_USE_DRIVER | * SQL_CUR_USE_DRIVER | ||
- | The cursor is set by passing it as the 4< | + | The cursor is set by setting |
<code php> | <code php> | ||
include ' | include ' | ||
$db = newAdoConnection(' | $db = newAdoConnection(' | ||
- | $db-> | + | |
+ | $db-> | ||
+ | |||
+ | $db-> | ||
</ | </ | ||
Line 46: | Line 49: | ||
^ADOdb V6|Yes| | ^ADOdb V6|Yes| | ||
== Alternatives == | == Alternatives == | ||
- | [[database: | + | [[v5:database: |
+ | </ | ||
+ | When used on Windows clients, this driver needs the Microsoft SQL server native client. There are feature limitations compared to the '' | ||
+ | ------------------------------------ | ||
+ | ===== odbc_mssql2012 ===== | ||
+ | <WRAP right box round 300px> | ||
+ | == From ADOdb V5.21 == | ||
+ | == Specification == | ||
+ | ^Driver Name|odbc_mssql2012| | ||
+ | ^Data Provider|odbc| | ||
+ | ^Status|Active((This driver is actively supported by ADOdb project members))| | ||
+ | ^Windows|Yes| | ||
+ | ^Unix|No| | ||
+ | ^ADOdb V5|Yes| | ||
+ | ^ADOdb V6|Yes| | ||
</ | </ | ||
- | When used on Windows clients, this driver needs the Microsoft | + | When used with SQL Server 2012, concatenation |
--------------------------- | --------------------------- | ||
===== odbc_oracle ===== | ===== odbc_oracle ===== | ||
Line 78: | Line 95: | ||
^ADOdb V5|Yes| | ^ADOdb V5|Yes| | ||
^ADOdb V6|Yes| | ^ADOdb V6|Yes| | ||
+ | == Alternatives == | ||
+ | [[v5: | ||
</ | </ | ||
Connects to DB2 database using either the IBM or 3rd party ODBC driver | Connects to DB2 database using either the IBM or 3rd party ODBC driver | ||
Line 100: | Line 119: | ||
===== Feature Limitations ===== | ===== Feature Limitations ===== | ||
- | ODBC connections have functionality limitations include transactional handling. See the [[database: | + | 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