ADOdb

Database Abstraction Layer for PHP

User Tools

Site Tools


v5:database:odbc

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 Nameodbc
Data Providerodbc
StatusActive1)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes
Alternatives

PDO driver for ODBC


odbc_mssql

Specification
Driver Nameodbc_mssql
Data Providerodbc
StatusActive2)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes
Alternatives

SQL Server

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 Nameodbc_oracle
Data Providerodbc
StatusActive3)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes

odbc_db2

Specification
Driver Nameodbc_db2
Data Providerodbc
StatusInactive4)
WindowsYes
UnixNo
ADOdb V5Yes
ADOdb V6Yes

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

1) , 2) , 3)
This driver is actively supported by ADOdb project members
4)
This driver is not supported by ADOdb project members
v5/database/odbc.1449087033.txt.gz · Last modified: 2017/04/21 11:24 (external edit)