ODBC Drivers

This page provides resources for people looking for ODBC drivers which they can then use with one of the available Python ODBC interfaces.

We group drivers by database backend. Where available, please add the database vendor drivers as first entry in each section.

Generic Lists

• SQL Summit list of ODBC drivers and vendors
  This was once the most comprehensive listing of ODBC drivers. Unfortunately, the site stopped working in 2014, so the above is a link to the last archive.org version. Even though it is not updated anymore, it still provides a good overview of where to look for drivers.

• ODBC Drivers on databasedrivers.com

  Listing of available ODBC drivers. This is also available as list based on database backend.

ODBC Driver Vendors

There are a couple of companies which focus on creating commercial quality ODBC drivers for various backends:

• EasySoft

• OpenLink

• DataDirect

• Actual Technologies (specialized on Mac OS X)

• Devart (Windows, Linux, Mac OS X)

• Simba Technologies (Windows, Linux, Mac OS X)

Microsoft SQL Server

• MS SQL Server Native Client for SQL Server 2005, 2008 and later
  Free, supported by Microsoft and available for Windows and 64-bit Linux.

• FreeTDS Unix ODBC Driver for SQL Server
  Open-source TDS protocol client library, which comes with an ODBC driver. The TDS protocol is used by SQL Server and Sybase ASE.

• EasySoft ODBC Driver for SQL Server

• OpenLink ODBC Driver for SQL Server

• DataDirect ODBC Driver for SQL Server

• Actual Technologies Mac OS X ODBC Driver for SQL Server

• Devart SQL Server ODBC Driver
  Works on Windows, Linux, Mac OS X 32/64 bits.
  Compatible with SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, SQL Server 2008, SQL Server 2005, SQL Server 2000 (including MSDE), SQL Server 7, SQL Server Compact 4.0, 3.5, 3.1

* Simba SQL Server ODBC drivers Supports Linux, Mac and Windows. Available in client and server (two-tier) versions.

• Please add new entries here

Oracle

• Oracle Instant Client ODBC driver
  Free, supported by Oracle. Works on Windows, Linux, Mac OS X, AIX, z/Linux, Solaris, HP-UX.

• Devart Oracle ODBC Driver
  Works on Windows, Linux, Mac OS X 32/64 bits.
  Supports Oracle servers: 12c, 11g, 10g, 9i, 8i, 8.0, including Oracle Express Edition 11g and 10g.
  Supports both x86 and x64 versions of the following Oracle Clients: 12c, 11g, 10g, 9i, 8i, 8.0.

• EasySoft ODBC Driver for Oracle

• OpenLink ODBC Driver for Oracle

• DataDirect ODBC Driver for Oracle

• Actual Technologies Mac OS X ODBC Driver for Oracle

• Please add new entries here

SAP ASE / Sybase ASE

• SAP/Sybase ASE ODBC driver
  The ASE ODBC driver comes as part of the ASE installer. Simply select the ODBC driver when running the installer on a client.

• FreeTDS Unix ODBC Driver for SQL Server
  Open-source TDS protocol client library, which comes with an ODBC driver. ASE talks TDS on the wire and the FreeTDS driver also supports ASE.

• EasySoft ODBC Driver for SQL Server

• OpenLink ODBC Driver for SQL Server

• DataDirect ODBC Driver for SQL Server

• Actual Technologies Mac OS X ODBC Driver for SQL Server

• Please add new entries here

IBM DB2

• IBM DB2 ODBC driver for Windows and Unix
  Come with IBM DB2, but can also be downloaded separately. Supports Windows and Unix.

• IBM ODBC Driver for Linux on iSeries / AS/400 DB2 servers

• OpenLink ODBC Driver for IBM DB2

• DataDirect ODBC Driver for IBM DB2

• Please add new entries here

Firebird (and Interbase)

• Devart Firebird ODBC Driver
  Works on Windows, Linux, Mac OS X 32/64 bits.
  Supports Firebird server and client versions 2.x, 1.x.

• Devart Interbase ODBC Driver
  Works on Windows, Linux, Mac OS X 32/64 bits.
  Supports all the InterBase server and client versions.

• Please add new entries here

IBM Informix

• Please add new entries here

Ingres

• Please add new entries here

Teradata

• Teradata ODBC Driver
  ODBC driver is available for Windows, Linux, Solaris, AIX, HP-UX and Mac.

• DataDirect ODBC Driver for Teradata

• Please add new entries here

IBM Netezza

• Netezza ODBC driver

  Since IBM acquired Netezza, the ODBC drivers are only available to customers with active support contracts. If you have one, you can download the driver as part of the software bundles from IBM FixCentral (search for "Netezza").

• Please add new entries here

MySQL

• MySQL ODBC Driver GPLed ODBC driver for Windows, Linux, Mac OS X, and Unix platforms.

• Devart MySQL ODBC Driver
  Works on Windows, Linux, Mac OS X 32/64 bits.
  Supports MySQL servers: 6.0, 5.6, 5.5, 5.1, 5.0, 4.1, 4.0, and 3.23

• OpenLink ODBC Driver for MySQL

• DataDirect ODBC Driver for MySQL

• Actual Technologies Mac OS X ODBC Driver for MySQL

• Please add new entries here

MariaDB

MariaDB is a fork of MySQL.

• MariaDB ODBC Driver

• Devart MariaDB ODBC Driver
  Works on Windows, Linux, Mac OS X 32/64 bits.
  Supports MariaDB 5.x. LGPLed ODBC driver for Windows.

• Please add new entries here

PostgreSQL

• PostgreSQL ODBC Driver]
  Open-source driver developed as part of the PostgreSQL project.

• Devart PostgreSQL ODBC Driver
  Works on Windows, Linux, Mac OS X 32/64 bits.
  Supports PostgreSQL server versions since 7.1 up to 9.4.

• EasySoft ODBC Driver for PostgreSQL

• OpenLink ODBC Driver for PostgreSQL

• DataDirect ODBC Driver for PostgreSQL

• Actual Technologies Mac OS X ODBC Driver for PostgreSQL

• Please add new entries here

SAP DB / MaxDB

• MaxDB ODBC Driver
  The driver comes as part of the MaxDB downloads.

• Please add new entries here

Microsoft Access

• Please add new entries here