Skip to content

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

Latest commit

 

History

History
75 lines (58 loc) · 2.81 KB

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

File metadata and controls

75 lines (58 loc) · 2.81 KB
title Step 1: Configure pymssql environment
description Step 1 of this getting started guide involves installing Python, the Microsoft ODBC Driver for SQL Server, and pymssql into your development environment.
author David-Engel
ms.author v-davidengel
ms.date 01/19/2017
ms.prod sql
ms.technology connectivity
ms.topic conceptual

Step 1: Configure development environment for pymssql Python development

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

The Python SQL Drivers use the TDS protocol, which is enabled by default in SQL Server and Azure SQL Database. No additional configuration is required.

Windows

  1. Install Python runtime and pip package manager.
    a. Go to python.org
    b. Click on the appropriate Windows installer msi link.
    c. Once downloaded run the msi to install Python runtime

  2. Download pymssql module from here

    Make sure you choose the correct whl file. For example: If you are using Python 2.7 on a 64-bit machine choose pymssql‑2.1.1‑cp27‑none‑win_amd64.whl. Once you download the whl file, place it in the C:\Python27 folder.

  3. Open cmd.exe

  4. Install pymssql module.
    For example, if you are using Python 2.7 on a 64-bit machine:

> cd c:\Python27  
> pip install pymssql‑2.1.1‑cp27‑none‑win_amd64.whl

Ubuntu Linux

  1. Install Python runtime and pip package manager. Python comes pre-installed on most distributions of Ubuntu. If your machine does not have python installed, you can either download the source tarball from python.org and build locally, or you can use the package manager:
> sudo apt-get install python

  1. Open terminal

  2. Install pymssql module and dependencies

> sudo apt-get --assume-yes update  
> sudo apt-get --assume-yes install freetds-dev freetds-bin  
> sudo apt-get --assume-yes install python-dev python-pip  
> sudo pip install pymssql

macOS

  1. Install Python runtime and pip package manager
    a. Go to python.org
    b. Click on the appropriate macOS installer pkg link.
    c. Once downloaded run the pkg to install Python runtime

  2. Open terminal

  3. Install Homebrew package manager

> ruby -e "$(curl -fsSL https://raw.githubusercontent.com/Homebrew/install/master/install)"
  1. Install FreeTDS module
> brew install FreeTDS
  1. Install pymssql module
> sudo -H pip install pymssql