trying to install pymssql on ubuntu 12.04 using pip

Question

Make sure you have the python-dev package installed (needed to compile packages with native bindings (thanks to @ravihemnani).

Then you'll need to install the FreeTDS development package (freetds-dev) before trying to install pymssql with pip:

$ sudo apt-get install freetds-dev

and then, in your virtualenv or wherever you wish to install it:

$ pip install pymssql

Apart from freetds-dev, you need to install python-dev as well as follow.

sudo apt-get install python-dev

Or else, you will again face some error.

For those on OpenSuse (and related OSes):

zypper in freetds-devel
pip install pymssql

On Mac

brew install [email protected]
brew link --force [email protected]
pip install pymssql