pyodbc and pypyodbc

Let's explore how pyodbc and pypyodbc packages can be used.

We'll cover the following

Open Database Connectivity (ODBC) is a standard API for accessing databases. Most production databases have an ODBC driver available that we can install to access their database.


One of the most popular methods of connecting via ODBC with Python is the pyodbc package. According to its page on the Python Packaging Index, we can use it on Windows or Linux. The pyodbc package implements the DB API 2.0 specification. We can install pyodbc with pip:

pip3 install pyodbc

Get hands-on with 1200+ tech skills courses.