PythonPython to SQL Server, Python to Oracle, Python to MS Access connectivity from Linux and Unix. 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 remote databases such as SQL Server, Oracle and Access by using the ODBC-enabled DB-API modules pyodbc and mxODBC. You can then access ODBC databases from Python scripts and Python applications such as Zope and Plone running on Unix and Linux. |