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)

To establish a connection, the DSN style of connection must be used, the first argument of the DSN string being the database type, e.g. to connect to a MySQL database:

include_once 'adodb/adodb.inc.php';
$db = ADOnewConnection('pdo');
 
$user     = 'pdo-user';
$password = 'pdo-pass';
$dsnString= 'host=localhost;dbname=employees;charset=utf8mb4'
$db->connect('mysql:' . $dsnString,$user,$password);

Note that in the above example, the database type is separated from the rest of the DSN string by a : (colon). The rest of the DSN arguments are separated by a ; (semi-colon).

In all cases, using native drivers (listed below) provides better functionality, as well as performance, than the equivalent PDO driver.

As of ADOdb 5.21, the PDO::setAttribute() method can be emulated using setConnectionParameter().

The current status of this driver is unknown

• Some Meta functions are unavailable

include 'adodb-dir/adodb.inc.php';
$db = ADOnewConnection('pdo');
$user = 'user';
$password = 'password'
$db->connect('mysql:hostname=127.0.0.1;database=employees;',$user,$password);

The current status of this driver is unknown

The current status of this driver is unknown

include 'adodb-dir/adodb.inc.php';
$db = ADOnewConnection('pdo');
$db->connect('sqlite:/home/sqlite/adodb-sqlite.db','root');

• This driver requires the installation of the Microsoft native client library, as well as the Microsoft SQL Server PDO drivers for PHP
• Dates are always returned as strings
• Most Meta functions are unsupported
• setConnectionParameter() is not supported, so changing the character set at run-time is not available.

include 'adodb-dir/adodb.inc.php';
$db = ADOnewConnection('pdo');
$user = 'user';
$password = 'password'
$db->connect('sqlsrv:server=SERVER\SQLEXPRESS;database=NORTHWND;',$user,$password);