Edit

Step 2: Create an SQL database for pyodbc Python development

  • Article

Create an SQL database using either Azure SQL or SQL Server.

Prerequisites

  • Python 3
    • If you don't already have Python, install the Python runtime and Python Package Index (PyPI) package manager from python.org.
    • Prefer to not use your own environment? Open as a devcontainer using GitHub Codespaces.
      • Open in GitHub Codespaces.
  • pyodbc package from PyPI.

Create an SQL database

The samples in this next section only work with the AdventureWorks schema, on either Microsoft SQL Server or Azure SQL Database.

Important

Don't forget to get the credentials for the database you create.

Next steps

Step 3: Proof of concept connecting to SQL using pyodbc