Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to install pymssql module in Python 3.6?

I have been through a couple of documentations involving FreeTDS, Wheel, git and github but nothing was working on my Windows 10 PC with Python 3.6 but I need to install it. I'm working on a project and I'm most comfortable with mssql which is already installed in my pc.

like image 651
Gautham Kolluru Avatar asked Jun 12 '17 01:06

Gautham Kolluru


People also ask

Is Pymssql deprecated?

The Pymssql Project is Being Discontinued #668.

How do I get PIP in Python?

Step 1: Download the get-pip.py (https://bootstrap.pypa.io/get-pip.py) file and store it in the same directory as python is installed. Step 2: Change the current path of the directory in the command line to the path of the directory where the above file exists. Step 4: Now wait through the installation process. Voila!


2 Answers

this seems to work from

export PYMSSQL_BUILD_WITH_BUNDLED_FREETDS=1

pip install pymssql

like image 64
Mallinath Biswas Avatar answered Sep 22 '22 16:09

Mallinath Biswas


Remember to install FreeTDS first.

Ubuntu/Debian:

sudo apt-get install freetds-dev

Mac OS X with Homebrew:

brew install freetds

Finally:

pip install pymssql
like image 24
Benchur Wong Avatar answered Sep 18 '22 16:09

Benchur Wong