v5:database:odbc
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
v5:database:odbc [2016/01/13 01:53] – ↷ Links adapted because of a move operation mnewnham | v5:database:odbc [2021/01/11 09:59] (current) – typo peterdd | ||
---|---|---|---|
Line 1: | Line 1: | ||
====== ODBC ====== | ====== ODBC ====== | ||
~~NOTOC~~ | ~~NOTOC~~ | ||
- | In addition to the genric | + | In addition to the generic |
----------------------- | ----------------------- | ||
===== odbc ===== | ===== odbc ===== | ||
Line 17: | Line 17: | ||
</ | </ | ||
* 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. | ||
- | * Connections can only be made using DSN connection strings or pre-defined | + | * Connections can only be made using DSN connection strings or predefined |
* Performance and functionality may be limited. | * Performance and functionality may be limited. | ||
* Writing portable applications that use this driver is not recommended. | * Writing portable applications that use this driver is not recommended. | ||
- | * When configuring connections on Windows, ensure that the ODBC driver configuration (32 Bit/64 Bit) matches the installed PHP version | + | * When configuring connections on Windows, ensure that the ODBC driver configuration (32 Bit/64 Bit) matches the installed PHP version. |
==== Setting The Cursor Mode ==== | ==== Setting The Cursor Mode ==== | ||
All ADOdb ODBC drivers can configure an appropriate cursor mode. The following modes are available through PHP. | All ADOdb ODBC drivers can configure an appropriate cursor mode. The following modes are available through PHP. | ||
Line 51: | Line 51: | ||
[[v5: | [[v5: | ||
</ | </ | ||
- | When used on Windows clients, this driver needs the Microsoft SQL server native client. There are feature limitations compared to the '' | + | 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 with SQL Server 2012, concatenation of strings results in a different behaviour compared with earlier versions. [[http:// | ||
--------------------------- | --------------------------- | ||
===== odbc_oracle ===== | ===== odbc_oracle ===== | ||
Line 106: | Line 120: | ||
===== Feature Limitations ===== | ===== Feature Limitations ===== | ||
ODBC connections have functionality limitations include transactional handling. See the [[v5: | ODBC connections have functionality limitations include transactional handling. See the [[v5: | ||
- | {{tag> | + | {{tag> |
v5/database/odbc.1452646427.txt.gz · Last modified: 2017/04/21 11:24 (external edit)