Skip to content

Latest commit

 

History

History
52 lines (36 loc) · 1.95 KB

step-1-configure-development-environment-for-pymssql-python-development.md

File metadata and controls

52 lines (36 loc) · 1.95 KB
title description author ms.author ms.date ms.service ms.subservice ms.topic
Step 1 - Configure pymssql environment
Step 1 of this getting started guide involves installing Python, the Microsoft ODBC Driver for SQL Server, and pymssql into your development environment.
David-Engel
davidengel
08/22/2023
sql
connectivity
how-to

Step 1: Configure development environment for pymssql Python development

You need to configure your development environment with the prerequisites in order to develop an application using the pymssql Python driver for SQL Server.

Note

This driver uses the TDS protocol, which is enabled by default in SQL Server and Azure SQL Database. No extra configuration is required.

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.

Install the pymssql package

Get the pymssql package from PyPI.

  1. Open a command prompt in an empty directory.

  2. Install the pymssql package.

    pip install pymssql

Check installed packages

You can use the PyPI command-line tool to verify that your intended packages are installed.

  1. Check the list of installed packages with pip list.

    pip list

Next steps

[!div class="nextstepaction"] Step 2: Create a SQL database for pymssql Python development