- skip to content

# Database Abstraction Layer

### User Tools

- Login

### Site Tools

- Recent changes
- Media Manager
- Sitemap

### Sidebar

##### Resources

- Reference Manual
- User Guide
- The Data Dictionary
- ADOdb-xmlschema
- ADOdb Active Record
- Performance Monitoring
- Date/Time Library
- Session Management Library
- Unsupported Addons
- Coding Standards

##### Supported Databases

- Access
- ADO
- CSV
- Firebird
- Frontbase
- IBM DB2
- Informix
- Interbase
- LDAP
- Microsoft SQL Server
- MySQL
- Netezza
- ODBC
- ODBTP
- Oracle
- PDO
- Postgresql
- SAP ADS
- SAP ASE
- SAP Maxdb
- SAP Sqlanywhere
- Sqlite
- Sybase
- Plain Text
- Visual Foxpro

##### Other

- Feature Comparison Matrix
- Connection Matrix
- Include File Guide

v5:database:pdo

# PDO

## Description

This driver supports connections using the standardized PHP Data Objects connection. The `pdo` driver itself cannot be used, it must be used with one of the supported databases:

- pdo_mssql (SQL Server with FREETDS)
- pdo_mysql (MySQL)
- pdo_oci (Oracle)
- pdo_pgsql (Postgresql)
- pdo_sqlite (SQLite)
- pdo_sqlsrv (SQL Server with Windows)

## Preferred Drivers

In all cases, using native drivers (listed to the left) provides better functionality than the equivalent PDO driver.

## Individual Driver Status

### pdo_mssql

##### Preferred Drivr

FreeTDS Driver For Unix

##### Specification

Driver Name | access
Data Provider | access
Status | Inactive1)
Windows | Yes
Unix | Yes
ADOdb V5 | Yes
ADOdb V6 | Yes

The current status of this driver is unknown

### pdo_mysql

##### Preferred Driver

mysql

##### Specification

Driver Name | access
Data Provider | access
Status | Inactive2)
Windows | Yes
Unix | No
ADOdb V5 | Yes
ADOdb V6 | Yes

The current status of this driver is unknown

### pdo_oci

##### Preferred Driver

oracle

##### Specification

Driver Name | access
Data Provider | access
Status | Inactive3)
Windows | Yes
Unix | No
ADOdb V5 | Yes
ADOdb V6 | Yes

The current status of this driver is unknown

### pdo_pgsql

##### Preferred Driver

postgresql

##### Specification

Driver Name | access
Data Provider | access
Status | Inactive4)
Windows | Yes
Unix | No
ADOdb V5 | Yes
ADOdb V6 | Yes

The current status of this driver is unknown

### pdo_sqlite

##### Preferred Driver

sqlite

##### Specification

Driver Name | access
Data Provider | access
Status | Inactive5)
Windows | Yes
Unix | No
ADOdb V5 | Yes
ADOdb V6 | Yes

The current status of this driver is unknown

### pdo_sqlsrv

##### Preferred Driver

Native Mode Driver
ODBC Driver for SQL Server

##### Specification

Driver Name | access
Data Provider | access
Status | Inactive6)
Windows | Yes
Unix | No
ADOdb V5 | Yes
ADOdb V6 | Yes

The current status of this driver is unknown

1) , 2) , 3) , 4) , 5) , 6) This driver is not supported by ADOdb project members, but you can contribute to this driver if you have the expertise
v5/database/pdo.txt · Last modified: 2016/01/12 16:53 by mnewnham

### Page Tools

- Show pagesource
- Old revisions
- Backlinks
- Rename Page
- Back to top