Installing Python pymssql Module
Problems
Cygwin
Looked like it installed OK.
$ pip install pymssql
Collecting pymssql
Downloading pymssql-2.1.2.tar.gz (898kB)
100% |████████████████████████████████| 901kB 134kB/s
Building wheels for collected packages: pymssql
Running setup.py bdist_wheel for pymssql ... done
Stored in directory: /home/aasdev/.cache/pip/wheels/08/df/03/0c92949cb5ecc9002cb965d135f1dec326cb7881f3e0bb80be
Successfully built pymssql
Installing collected packages: pymssql
Successfully installed pymssql-2.1.2
Windows
When I attempt to run a windows script which imports pymssql it fails:
Python 2.7.11 (v2.7.11:6d1b6a68f775, Dec 5 2015, 20:40:30) [MSC v.1500 64 bit (AMD64)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>> import pymssql Traceback (most recent call last): File "<stdin>", line 1, in <module> ImportError: DLL load failed: The specified module could not be found. >>>
Notes
Found this somewhere:
"Tried to install pymssql into cygwin python install using pip. There isn't currently any cygwin specific install instructions at http://pymssql.org but with a quick read it was obvious that pymssql has a dependency on FreeTDS that could be satisfied by installing FreeTDS package from the cygwin setup utility, however cygwin doesn't currently have any "freetds-dev" or "freetds-devel" package and it took quite a bit of head scratching to figure out the header files required by the pip build could be found in the the cygwin "libsybdb-devel" package"