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) provide 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. Consider using the mssqlnative driver instead.

• 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.
• This driver can also be used on Linux platforms, beginning with PHP Version 7. The program relies on the Microsoft drivers for Linux. For more information, see the mssqlnative driver

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