Step 2: Create an SQL database for pyodbc Python development
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.
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
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for