Python

Python is a cross-platform, object-oriented programming language with support for writing database client applications.

Python's functionality can be extended with third-party modules. For example, a module may add new functionality by linking a Python program to binary libraries written in C such as an ODBC Driver Manager.

To access a database, Python needs a database module. Python database modules that conform to the Python Database API (DB-API) specification can be used to access relational databases from Python.

The tutorials in this section show how to connect Python to databases for which an ODBC driver is available by using the DB-API modules pyodbc and mxODBC.

You can then access such databases from Python scripts and Python applications such as Zope and Plone running on UNIX and Linux.

Connecting to databases that support ODBC from Python with pyodbc

Access databases such as SQL Server, Oracle, Salesforce, MongoDB, DB2, Sybase ASE, InterBase, Access, and Derby from Python with pyodbc.

Connecting to databases that support ODBC from Python with mxODBC

Access databases such as SQL Server, Oracle, Salesforce, MongoDB, DB2, Sybase ASE, InterBase, Access, and Derby from Python with mxODBC.

Python ODBC code samples

ODBC examples written in Python.