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.
pyodbc
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 1400+ tech skills courses.