Database Abstraction Layer for PHP http://adodb.org/dokuwiki/ 2026-05-16T19:08:34+00:00 http://adodb.org/dokuwiki/ http://adodb.org/dokuwiki/lib/exe/fetch.php?media=logo.png text/html 2025-06-01T11:21:07+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:access&rev=1748776867&do=diff Microsoft Access Specification Driver NameaccessData ProviderodbcStatusActive WindowsYesUnixNoADOdb V5YesADOdb V6Yes Alternatives PDO Driver For Access This driver provides a connection to Microsoft Access databases, via an ODBC connection. The easiest way to connect to the database is to define a DSN in the ODBC connection manager and connect via that. text/html 2020-01-13T12:20:29+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:ado&rev=1578918029&do=diff ADO Specification Driver NameadoData ProvideradoStatusObsoleteWindowsYesUnixNoADOdb V5YesADOdb V6No Alternatives ODBC driver for Access PDO Driver for Access Description This Windows only driver supports connections through COM obects to a limited number of databases. The ado driver itself cannot be used, one of the following subset drivers must be used text/html 2019-12-29T20:31:53+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:connection_matrix&rev=1577651513&do=diff The Connection Matrix Common connection parameters, by database type Parameter 1 Parameter 2 text/html 2019-12-28T02:37:47+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:feature_comparison&rev=1577500667&do=diff Feature Comparison Matrix ADOdb features, by Database Type Check that the 'Verified' column is checked before relying on information Driver Support Tier 1 Support Tier 1 Drivers are fully supported by members of the ADOdb project, and all contain the full feature list. New feature is available for all drivers on release of feature text/html 2025-06-01T11:21:08+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:firebird&rev=1748776868&do=diff Firebird & Interbase Firebird Specification Driver NamefirebirdData ProvideribaseStatusActiveWindowsYesUnixYesADOdb V5YesADOdb V6Yes PHP Drivers for the Firebird DBMS are now hosted on Github. Native mode drivers for PHP7.4+ are available for both Windows and Linux. text/html 2020-01-09T03:03:25+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:for_removal&rev=1578539005&do=diff List of Drivers To Be Removed / Merged Full Removal Driver Driver / Children Reason ADO ado, ado_access, ado_mssql, ado5 text/html 2025-06-01T11:21:08+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:frontbase&rev=1748776868&do=diff Frontbase Specification Driver NamefbsqlData ProviderfbsqlStatusInactiveWindowsYesUnixYesADOdb V5YesADOdb V6Yes Description This driver was provided by Frontbase. Its status and quality are unknown. frontbase dormant text/html 2026-02-15T02:00:21+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:ibm_db2&rev=1771120821&do=diff IBM DB2 Specification Driver Namedb2Data Providerdb2StatusActiveWindowsYesUnixYesADOdb V5YesADOdb V6Yes Alternative Drivers ODBC Driver For IBM DB2 See Also setConnectionParameter() Description This driver provides a connection to IBM DB2 Databases, using the IBM Data Client. This driver replaces the original text/html 2016-01-13T02:06:13+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:index&rev=1452650773&do=diff Index Of Database Drivers Pages in this namespace: * ADO * Feature Comparison Matrix * Firebird & Interbase * Frontbase * IBM DB2 * IBM Informix * Index Of Database Drivers * LDAP * Legacy MySQL drivers * List of Drivers To Be Removed / Merged * Microsoft Access * Microsoft SQL Server * MySQL * Netezza * ODBC * ODBTP * Oracle * PDO * PDO (new) * Plain Text * PostgreSQL * Proxy * SAP Adaptive Server Enterprise * SAP Advantage Database Server * SAP MaxDB * SAP SQLAnyw… text/html 2025-06-01T11:21:09+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:informix&rev=1748776869&do=diff IBM Informix A new driver based on the common IBM PDO driver is included in this development branch <https://github.com/ADOdb/ADOdb/pull/826>. This driver will be included into master at a later date. informix Specification Driver NameinformixData ProviderinformixStatusObsoleteWindows text/html 2025-06-01T00:46:34+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:ldap&rev=1748738794&do=diff LDAP Use of ADODB_FETCH_NUM is strongly discouraged because AD records returned in queries may not all contain the same number of fields Specification Driver NameldapData ProviderldapStatusActiveWindowsYesUnixPerhapsADOdb V5YesADOdb V6Yes Description text/html 2025-06-01T11:21:10+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:microsoft_sql_server&rev=1748776870&do=diff Microsoft SQL Server Description There are 2 supported drivers that allow connections to Microsoft SQL Server databases from SQL Server 2005 upwards. mssqlnative This driver, which runs on both Windows and Linux clients, allows connections to Microsoft SQL Server databases versions 2008 and up, and uses the Microsoft Native Client libraries. This driver is recommended for Windows Clients running PHP 5.3 and higher, and Linux Clients running PHP 7.0 and higher, and provides the fastest PHP… text/html 2025-06-01T11:21:10+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:mysql_legacy&rev=1748776870&do=diff Legacy MySQL drivers This page references the legacy MySQL drivers, which are deprecated since ADOdb 5.20 and were removed in 5.22. Please refer to MySQL for the current, supported driver (mysqli). Migrating to the mysqli driver If you are still using the legacy text/html 2026-01-30T02:48:38+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:mysql&rev=1769741318&do=diff MySQL mysqli driver Specification Driver NamemysqliData ProvidermysqlStatusActiveWindowsYesUnixYesADOdb V5YesADOdb V6Yes Alternatives PDO driver for MySQL See Also setConnectionParameter() This is the preferred driver for connections to the following databases: * MySQL * MariaDB * Percona This driver uses the PHP text/html 2025-06-01T11:21:11+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:netezza&rev=1748776871&do=diff Netezza This database was end-of-life in 2019 and is no longer supported Specification Driver NamenetezzaData Providerpostgres64StatusObsoleteWindowsYesUnixYesADOdb V5YesADOdb V6No This community provided driver is built on the PostgreSQL driver. Its status and quality are unknown. text/html 2025-06-01T11:21:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:odbc&rev=1748776872&do=diff ODBC In addition to the generic ODBC driver for use with Windows ODBC drivers, there are additional ODBC drivers that provide extended support for database specific functions ---------- odbc Specification Driver NameodbcData ProviderodbcStatusActive text/html 2020-01-13T12:17:20+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:odbtp&rev=1578917840&do=diff ODBTP odbtp This driver is officially dead, unsupported and will be removed in the next release Specification Driver NameodbtpData ProviderodbtpStatusObsoleteWindowsYesUnixNoADOdb V5YesADOdb V6No Description This driver is based on the 3rd party windows only text/html 2025-06-01T11:21:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:oracle&rev=1748776872&do=diff Oracle For more information on using advanced functionality in the Oracle driver, read the Advanced Oracle Tutorial oci8 Specification Driver Nameoci8Data ProvideroracleStatusActiveWindowsYesUnixYesADOdb V5YesADOdb V6Yes Alternatives PDO driver for Oracle See Also setConnectionParameter() This is the preferred driver for connecting to Oracle databases text/html 2023-01-24T03:00:08+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:pdo_new&rev=1674529208&do=diff PDO (new) This is still under development. Feedback is welcome, just add your comments in the pull request. Specification Driver NamepdoData ProviderpdoStatusActiveWindowsYesUnixYesADOdb V5YesADOdb V6Yes Description This driver supports connections using the standardized text/html 2022-02-20T22:47:29+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:pdo&rev=1645397249&do=diff PDO Description This driver supports connections using the standardized PHP Data Objects. Supported drivers: PHP DriverDescriptionADOdb Connectorpdo_firebirdFirebirdfirebirdpdo_mssqlSQL Server with FREETDSmssqlpdo_mysqlMySQLmysqlpdo_ociOracleocipdo_pgsqlPostgresql text/html 2025-06-01T11:21:12+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:postgresql&rev=1748776872&do=diff PostgreSQL The PostgreSQL drivers are currently undergoing a major refactoring, targeted at upcoming release 5.23.0. At the end of this process, there will be a single postgres driver instead of multiple, version-specific ones, which does not make sense anymore as they are all targeting versions of the database that have been obsolete and unsupported for many years. text/html 2020-01-13T12:15:46+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:proxy&rev=1578917746&do=diff Proxy See Also ADOdb Proxy Server Specification Driver NameproxyAlternate NamecsvData ProviderproxyStatusDeprecatedWindowsYesUnixYesADOdb V5YesADOdb V6Yes This functionality is deprecated as of ADOdb 5.21.0 and will be removed in a later release, unless the community contributes with necessary security enhancements, text/html 2026-01-27T11:11:52+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:sap_ads&rev=1769512312&do=diff SAP Advantage Database Server ads SAP Advantage Database Server 12.0 reached end of mainstream maintenance on December 31, 2022.. To our knowledge, there are currently no available drivers for PHP 7 or later. Specification Driver NameadsData Provider text/html 2026-03-09T23:27:49+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:sap_ase&rev=1773098869&do=diff SAP Adaptive Server Enterprise sybase_ase The official end-of-life for Sybase ASE 16.0 was 31/12/2025. Connection to the database is possible via both PDO\DBLIB and PDO\ODBC but there are currently no plans to add a PDO\DBLIB ADOdb driver. Use the ODBC driver which provides limited support for connection. text/html 2020-01-13T12:14:15+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:sap_maxdb&rev=1578917655&do=diff SAP MaxDB The status of the database is unknown, and there are currently no drivers for PHP 7. The support status may change if drivers become available Specification Driver NamesabdbData ProviderodbcStatusInactiveWindowsYesUnixNoADOdb V5YesADOdb V6 text/html 2025-06-01T11:21:13+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:sap_sqlanywhere&rev=1748776873&do=diff SAP SQLAnywhere sqlanywhere Whilst this database is still active and there are drivers available, absent any user requests about it, support for the driver is dormant. Use of the driver may be problematical with PHP7. The support status may change if requests are made about it text/html 2025-06-01T11:21:13+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:sqlite&rev=1748776873&do=diff SQLite Database sqlite3 Specification Driver Namesqlite3Data ProvidersqliteStatusActiveWindowsYesUnixYesADOdb V5YesADOdb V6Yes Alternatives PDO driver for SQLite This is the preferred driver for connecting to SQLite databases. It supports connections to SQLite version 3 databases. text/html 2021-03-12T17:15:06+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:supported&rev=1615569306&do=diff Supported Databases ADOdb offers a large number of database drivers, with various levels of support. Please refer to the Feature Comparison Matrix for details on availability of ADOdb features by Database Type. Support Tiers Tier 1 Tier 1 Drivers are fully supported by members of the ADOdb project, and contain the full feature list. New functionality is available for all drivers upon release of the feature. text/html 2025-06-01T11:21:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:sybase&rev=1748776874&do=diff Sybase Specification Driver NamesybaseData ProvidersybaseStatusInactiveWindowsYesUnixYesADOdb V5YesADOdb V6Yes This early driver supports the version of the Sybase database which shares common functionality with early versions of Microsoft SQL Server. text/html 2020-01-13T12:17:55+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:text&rev=1578917875&do=diff Plain Text This driver is broken in ADOdb version 5 when used with PHP version 5.3 and up. This is due to the fact that the execute method has a non-compliant 3rd argument to it. Absent any user requests, this driver will be removed in ADOdb version 6. text/html 2023-11-18T22:53:06+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:unsupported&rev=1700347986&do=diff Unsupported Drivers The following drivers may be found in some releases of ADOdb, but they are no longer supported. Most connections end-of-life because the databases become obsolete or there are no drivers available Driver text/html 2025-06-01T11:21:14+00:00 Anonymous (anonymous@undisclosed.example.com) http://adodb.org/dokuwiki/doku.php?id=v5:database:visual_foxpro&rev=1748776874&do=diff Visual Foxpro vfp As there are no drivers for PHP 7, this driver is now unsupported Specification Driver NamevfpData ProviderodbcStatusObsoleteWindowsYesUnixNoADOdb V5YesADOdb V6No Microsoft ceased development of Visual Foxpro in 2007. Although this driver was well-supported and well tested in earlier versions of ADOdb, it's obsolence means that it will be removed in ADOdb version 6.0