10

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

Fricative Melon
  • 293
  • 2
  • 12
  • http://pymssql.org/en/latest/freetds.html#windows here it states: If applicable, add the directories that hold the above DLLs to your PATH environment variable. – nicecatch Apr 11 '16 at 15:16
  • @AndreaConte I did that, and the error changed to me needing to install Visual C++ but after I did that it went back to what it is now. – Fricative Melon Apr 12 '16 at 13:39
  • Please [edit] your question to indicate the specifics of your Python install: distribution (where did you get your Python installer?), exact Python version, 64-bit or 32-bit? – Gord Thompson Apr 13 '16 at 07:10

3 Answers3

4

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

Fricative Melon
  • 293
  • 2
  • 12
2

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!

FlipperPA
  • 11,339
  • 3
  • 27
  • 57
2
  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

denfromufa
  • 4,995
  • 11
  • 66
  • 130