Step 1: Configure development environment for pyodbc Python development
You need to configure your development environment with the prerequisites in order to develop an application using the pyodbc Python driver for SQL Server.
- Python 3
Install the ODBC driver
This driver requires the host operating system to have the appropriate ODBC driver already installed.
Obtain and install the Microsoft ODBC driver for SQL Server on Windows:
Verify that you have installed the driver.
Install the pyodbc package
pyodbc package from PyPI.
Open a command prompt in an empty directory.
pip install pyodbc
Check installed packages
You can use the PyPI command-line tool to verify that your intended packages are installed.
Check the list of installed packages with