Skip to content

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

Latest commit

 

History

History
52 lines (35 loc) · 2.18 KB

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

File metadata and controls

52 lines (35 loc) · 2.18 KB
title Step 1: Configure pyodbc Python environment
description Step 1 of this getting started guide involves installing Python, the Microsoft ODBC Driver for SQL Server, and pyODBC into your development environment.
author David-Engel
ms.author v-davidengel
ms.date 08/29/2022
ms.prod sql
ms.technology connectivity
ms.topic conceptual

Step 1: Configure development environment for pyodbc Python development

This article explains how to configure your development environment for pyodbc Python development.

Windows

  1. Download Python installer. If your machine doesn't have Python, install it. Go to the Python download page and download the appropriate installer. For example, if you are on a 64-bit machine, download the Python 3.10 (x64) installer.

  2. Install Python. Once the installer is downloaded, do the following steps:

    1. Double-click the file to start the installer.
    2. Select your language, and agree to the terms.
    3. Follow the instructions on the screen to install Python on your computer.
    4. You can verify that Python is installed by going to a command prompt and running python -V. You can also search for Python in the start menu.

  3. Install the Microsoft ODBC Driver for SQL Server on Windows.

  4. Open cmd.exe as an administrator.

  5. Install pyodbc using pip - Python package manager.

    pip install pyodbc

Linux

Installing on Linux is similar. If the instructions below don't work, see the pyODBC Install instructions, which have more details for different Linux distributions.

  1. Open terminal.

  2. Install Microsoft ODBC Driver for SQL Server on Linux.

  3. Install pyodbc.

    sudo -H pip install pyodbc

Next steps

Create an SQL database for pyodbc.