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

• This generic driver can be used with any database with ODBC connection support.
• Connections can only be made using DSN connection strings or predefined ODBC connections.
• Performance and functionality may be limited.
• Writing portable applications that use this driver is not recommended.
• When configuring connections on Windows, ensure that the ODBC driver configuration (32 Bit/64 Bit) matches the installed PHP version.

All ADOdb ODBC drivers can configure an appropriate cursor mode. The following modes are available through PHP.

• SQL_CUR_USE_IF_NEEDED
• SQL_CUR_USE_ODBC
• SQL_CUR_USE_DRIVER

The cursor is set by setting the curmode prior to the connect statement

include 'adodb/adodb.inc.php';
$db = newAdoConnection('odbc');
 
$db->curmode = SQL_CUR_USE_IF_NEEDED;
 
$db->connect('northwind');

When used on Windows clients, this driver needs the Microsoft SQL server native client. There are feature limitations compared to the mssqlnative driver, use of that is always recommended. If you are using the driver with SQL Server versions 2012 and higher, consider using the odbc_mssql2012 driver instead, as 2012+ database specific fixes will be placed into that driver.

When used with SQL Server 2012, concatenation of strings results in a different behaviour compared with earlier versions. This article explains the difference.

After connection, the date format is automatically set by the driver by executing the following statement:

$sql = "ALTER SESSION SET NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'";
$db->execute($sql);

Connects to DB2 database using either the IBM or 3rd party ODBC driver

ODBC connections have functionality limitations include transactional handling. See the Feature Matrix for more information