How to install pymssql on windows with python 2.7?

It seems that there are no such binaries开发者_StackOverflow yet. There is an issue on googlecode: http://code.google.com/p/pymssql/issues/detail?id=12 but i cannot figure out what to do with those files provided.

You may also get pymssql2.7 library from this unofficial extensions library

http://www.lfd.uci.edu/~gohlke/pythonlibs/#pymssql

If you have pip install:

pip install pymssql

To install pip (trust me its very helpful):

1. Download and run this python script (as admin):

   https://bootstrap.pypa.io/get-pip.py

Extract the contents into the Python27\Lib\site-packages directory.

Combining YOU and David Huang's answers will bring success; here are some further notes that may help a beginner:

Be sure to download the package that matches the bitness of your windows and also matches the version of Python you are running. I noticed on the pymssql wiki page a note about x64 not being available on Windows so test well if you choose those packages.

It may feel a little sketchy when you notice Christoph Gohlke packages are all exe's. I used WinRAR to open the self-extractor. Inside the archive is a PLATLIB folder which itself contains two files and a folder: _mssql.pyd, pymssql.pyd, and pymssql-N.N.N-pyN.N.egg-info. These two files and the pymssql-... folder are what needs extracting into ...\Lib\site-packages.