|
Size: 2677
Comment:
|
Size: 6643
Comment: Add more driver links and infos for MySQL, MariaDB, PostgreSQL, Netezza, Teradata
|
| Deletions are marked like this. | Additions are marked like this. |
| Line 5: | Line 5: |
| It groups drivers by database backend. | We group drivers by database backend. Where available, please add the database vendor drivers as first entry in each section. |
| Line 19: | Line 19: |
| == ODBC Driver Vendors == There are a couple of companies which focus on creating commercial quality ODBC drivers for various backends: * [[http://www.easysoft.com/|EasySoft]] * [[http://www.openlinksw.com/|OpenLink]] * [[http://www.datadirect.com/|DataDirect]] * [[http://www.actualtech.com/|Actual Technologies]] (specialized on Mac OS X) * [[https://www.devart.com/odbc/|Devart]] |
|
| Line 27: | Line 41: |
| Open-source TDS protocol client library, which comes with an ODBC driver. | Open-source TDS protocol client library, which comes with an ODBC driver. The TDS protocol is used by SQL Server and Sybase ASE. |
| Line 47: | Line 61: |
| * [[http://www.easysoft.com/|EasySoft ODBC Driver for Oracle]] * [[http://www.openlinksw.com/|OpenLink ODBC Driver for Oracle]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for Oracle]] * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for Oracle]] |
|
| Line 49: | Line 71: |
| == Sybase ASE == | == SAP ASE / Sybase ASE == * [[http://scn.sap.com/community/developer-center/oltp-db|SAP/Sybase ASE ODBC driver]] <<BR>> The ASE ODBC driver comes as part of the ASE installer. Simply select the ODBC driver when running the installer on a client. * [[http://www.freetds.org/|FreeTDS Unix ODBC Driver for SQL Server]] <<BR>> 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. * [[http://www.easysoft.com/|EasySoft ODBC Driver for SQL Server]] * [[http://www.openlinksw.com/|OpenLink ODBC Driver for SQL Server]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for SQL Server]] * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for SQL Server]] |
| Line 54: | Line 92: |
* [[http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.swg.im.dbclient.install.doc/doc/c0059871.html?lang=en|IBM DB2 ODBC driver for Windows and Unix]] <<BR>> Come with IBM DB2, but can also be downloaded separately. Supports Windows and Unix. * [[http://www-03.ibm.com/systems/power/software/i/access/linux/guide.html|IBM ODBC Driver for Linux on iSeries / AS/400 DB2 servers]] * [[http://www.openlinksw.com/|OpenLink ODBC Driver for IBM DB2]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for IBM DB2]] |
|
| Line 71: | Line 119: |
| * [[http://www.teradata.com/downloadcenter/|Teradata ODBC Driver]] <<BR>> ODBC driver is available for Windows, Linux, Solaris, AIX, HP-UX and Mac. * [[http://www.datadirect.com/|DataDirect ODBC Driver for Teradata]] |
|
| Line 74: | Line 128: |
* Netezza ODBC driver <<BR>> 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 [[http://www-933.ibm.com/support/fixcentral/options|IBM FixCentral]] (search for "Netezza"). |
|
| Line 79: | Line 137: |
| * [[http://dev.mysql.com/downloads/connector/odbc/|MySQL ODBC Driver]] GPLed ODBC driver for Windows, Linux, Mac OS X, and Unix platforms. * [[http://www.openlinksw.com/|OpenLink ODBC Driver for MySQL]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for MySQL]] * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for MySQL]] * ''Please add new entries here'' == MariaDB == MariaDB is a fork of MySQL. * [[https://mariadb.com/kb/en/mariadb/about-mariadb-connector-odbc/|MariaDB ODBC Driver]] LGPLed ODBC driver for Windows. |
|
| Line 83: | Line 161: |
| * [[http://psqlodbc.projects.postgresql.org/|PostgreSQL ODBC Driver]]] <<BR>> Open-source driver developed as part of the PostgreSQL project. * [[http://www.easysoft.com/|EasySoft ODBC Driver for PostgreSQL]] * [[http://www.openlinksw.com/|OpenLink ODBC Driver for PostgreSQL]] * [[http://www.datadirect.com/|DataDirect ODBC Driver for PostgreSQL]] * [[http://www.actualtech.com/|Actual Technologies Mac OS X ODBC Driver for PostgreSQL]] |
|
| Line 85: | Line 175: |
| == SAP DB (also known as "MaxDB") == | == SAP DB / MaxDB == * [[http://scn.sap.com/community/maxdb|MaxDB ODBC Driver]] <<BR>> The driver comes as part of the [[https://store.sap.com/sap/cpa/ui/resources/store/html/Search.html?searchText=maxdb|MaxDB downloads]]. |
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.
Contents
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:
Actual Technologies (specialized on 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.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.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.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.Please add new entries here
Firebird (and Interbase)
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.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.
Please add new entries here
MariaDB
MariaDB is a fork of MySQL.
MariaDB ODBC Driver LGPLed ODBC driver for Windows.
Please add new entries here
PostgreSQL
PostgreSQL ODBC Driver]
Open-source driver developed as part of the PostgreSQL project.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