This is an old revision of the document!
ODBC
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
Specification
Driver Name | odbc |
---|---|
Data Provider | odbc |
Status | Active1) |
Windows | Yes |
Unix | No |
ADOdb V5 | Yes |
ADOdb V6 | Yes |
Alternatives
- 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 ODBC connections.
- Performance and functionality may be limited.
- 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
odbc_mssql
Specification
Driver Name | odbc_mssql |
---|---|
Data Provider | odbc |
Status | Active2) |
Windows | Yes |
Unix | No |
ADOdb V5 | Yes |
ADOdb V6 | Yes |
Alternatives
When used on Windows clients, this driver needs the Microsoft SQL server native client. There are feature limitations compared to the mssqlnative
driver, use of that is always recommended.
odbc_oracle
Specification
Driver Name | odbc_oracle |
---|---|
Data Provider | odbc |
Status | Active3) |
Windows | Yes |
Unix | No |
ADOdb V5 | Yes |
ADOdb V6 | Yes |
After connection, the date format is automatically set by executing the following statement:
$sql = "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'"; $db->execute($sql);
odbc_db2
Specification
Driver Name | odbc_db2 |
---|---|
Data Provider | odbc |
Status | Inactive4) |
Windows | Yes |
Unix | No |
ADOdb V5 | Yes |
ADOdb V6 | Yes |
This driver was originally the main connection to DB2 databases. Since the introduction of the db2 native driver it's status is unknown.
Feature Limitations
ODBC connections have functionality limitations include transactional handling. See the Feature Matrix for more information