This driver supports connections using the standardized PHP Data Objects.This page refers to ADOdb release 5.23.0 and higher. For previous versions of ADOdb, see the Previous Version Of This Page.

Except for the pdo_odbc driver, all PDO drivers include support for full data dictionary functions (e.g. createTableSql(),addIndexSql(), etc.)

• pdo_mssql
• pdo_dblib
• pdo_cubrid

To establish a connection:

1. The PDO database type must be specified in the ADONewConnection() function call
2. The DSN style of connection must be used in the connect() statement, e.g. to connect to a MySQL database:

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

Using ADOdb effectively eliminates the need to use the PHP PDO driver as it hides the PHP level command:

• It provides true database abstraction, for example, the ADOdb method selectLimit() provides a true abstraction of the row limiting and offset of all databases. With PDO, you still need to provide the database specific syntax.
• Unless otherwise described below, using native drivers (listed below) provide better functionality, as well as performance, than the equivalent PDO driver. This is true at both the ADOdb and PHP level

Certain attributes need to be passed to the PDO Constructor, for example, changing the error mode. To facilitate this, a PDO specific settable array ADOConnection::pdoParameters is provided:

$db = newAdoConnection('pdo\firebird');
 
$db->pdoParameters = [
\PDO::ATTR_ERRMODE => \PDO::ERRMODE_EXCEPTION
];
 
$dsnString= 'host=localhost;dbname=employee.fdb';
$db->connect($dsnString,"SYSDBA", "password");

For parameters that are set after the class is instantiated, The PDO::setAttribute() method can be populated using setConnectionParameter().

include 'adodb-dir/adodb.inc.php';
$db = ADOnewConnection('pdo\firebird');
 
$dsn  = 'dbname=employee.fdb;hostname=localhost';
$user = 'SYSDBA';
$pass = 'master-key';
 
$db->connect($dsn,$user,$pass);

• This driver requires the installation of the IBM DB2 client

include 'adodb-dir/adodb.inc.php';
$db   = ADOnewConnection('pdo\ibm');
 
$dsn = 'hostname=192.168.86.141;protocol=tcpip;port=50000;';
$dsn.= 'database=SAMPLE;uid=db2inst1;pwd=somepassword';
$user = '';
$password = ''
 
$db->connect($dsn,$user,$password);

• There is no native mode driver for IBM Informix Connections
• This driver requires the installation of the IBM Informix Client

include 'adodb-dir/adodb.inc.php';
$db   = ADOnewConnection('pdo\informix');
 
$dsn = 'hostname=192.168.86.141;service=ol_informix1410;database=stores_demo;';
$dsn.= 'server=ol_informix1410;protocol=onsoctcp;EnableScrollableCursors=1;';
$user = 'ix-user';
$password = 'ix-password'
 
$db->connect($dsn,$user,$password);

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

• There is no support for the complex binding features available in the Native Driver
• This driver requires installation of an Oracle client, such as InstantClient

If you are using the instantclient, and there is no tsnames.ora defined, you can define a connection like this

$db = newAdoConnection('pdo\oci');
 
//Connecting to Oracle Express on 192.168.86.86
$tns = " 
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.86.86)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = XEPDB1)
    )
  )
";
$dsnString="dbname=$tns";
$db->connect($dsnString,$userName,$password);

$db = newAdoConnection('pdo\pgsql');
 
$dsn  = 'pgsql:host=192.168.0.212;dbname=dvdrental';
$user = 'someuser';
$pass = 'somepass';
 
$db->connect($dsn,$user,$pass);

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

• 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
• 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
• You cannot change the character set in the driver. This is a limitation of the PDO driver, not ADOdb
• No support for parameter binding

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