Skip to content

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

Latest commit

 

History

History
49 lines (38 loc) · 1.91 KB

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

File metadata and controls

49 lines (38 loc) · 1.91 KB
title Step 1: Configure pyodbc Python development environment | Microsoft Docs
ms.custom
ms.date 07/06/2018
ms.prod sql
ms.prod_service connectivity
ms.reviewer
ms.technology connectivity
ms.topic conceptual
ms.assetid 74e69704-e63c-450b-9207-5c1491d0e0f5
author David-Engel
ms.author v-daenge

Step 1: Configure development environment for pyodbc Python development

Windows

Connect to SQL Database by using Python - pyodbc on Windows:

  1. Download Python installer.
    If your machine does not 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 2.7 or 3.7 (x64) installer.

  2. Install Python. Once the installer is downloaded, do the following steps: a. Double-click the file to start the installer. b. Select your language, and agree to the terms. c. Follow the instructions on the screen and Python should be installed on your computer. d. You can verify that Python is installed by going to C:\Python27 or C:\Python37 and run python -V or py -V (for 3.x)

  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 (Replace C:\Python27\Scripts with your installed Python path)

> cd C:\Python27\Scripts  
> pip install pyodbc

Linux

Connect to SQL Database by using Python - pyodbc:

  1. Open terminal

  2. Install Microsoft ODBC Driver for SQL Server on Linux

  3. Install pyodbc

> sudo -H pip install pyodbc