CODEWITHSUNDEEP
pythonwindowswindows-server-2012-r2freetdspymssql
Fricative Melon
Fricative Melon

Reputation: 389

Pymssql Install Error

I'm trying to install FreeTDS using binaries from here, on Windows, but I can't figure out how to install binary files; a google search turned up nothing relevant. I'm installing so that the Python module Pymssql can be imported and used.

I'm getting the same error as in this post: https://github.com/pymssql/pymssql/issues/372

Upvotes: 10

Views: 1102

Answers (3)

den.run.ai
den.run.ai

Reputation: 5933

  1. Download and install pymssql wheels from here:

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

Download and then pip install %userprofile%\downloads\pymssql-2.1.2-cp**-cp**m-win??.whl

  1. conda install -c https://conda.anaconda.org/prometeia pymssql

  2. WinPython may soon include pymssql by default:

https://github.com/winpython/winpython/issues/307

Upvotes: 3

Fricative Melon
Fricative Melon

Reputation: 389

I fixed the problem by moving all the .h files from the FreeTDS and OpenSSL files I downloaded into where all the other .h files were in C:\Users\KAllen\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\include, and put all the .dll files with the others in C:\Users\KAllen\AppData\Local\Programs\Common\Microsoft\Visual C++ for Python\9.0\VC\bin

Upvotes: 4

FlipperPA
FlipperPA

Reputation: 14311

You can download the Windows binaries here:

https://sourceforge.net/projects/freetdswindows/

There is an executable installer in the ZIP file you download; install away. It should install the necessary binaries you need. Good luck!

Upvotes: 3

Related Questions