Menu
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
439
A simple database interface for Python that builds on top of FreeTDS to provide a Python DB-API (PEP-249) interface to Microsoft SQL Server. The 2. x branch of pymssql is built on the latest release of FreeTDS which removes many of the limitations found with older FreeTDS versions and the 1. x branch.
The Pymssql Project is Being Discontinued #668.
Go to python.org. b. Click on the appropriate Windows installer msi link. c. Once downloaded run the msi to install Python runtime. Download pymssql module from here. Make sure you choose the correct whl file. For example : If you are using Python 2.7 on a 64 bit machine choose : pymssql‑2.1.1‑cp27‑none‑win_amd64.whl.
pymssql wheels are available from PyPi. To install it run: pip install -U pip pip install pymssql Most of the times this should be all what’s needed.
The Python SQL Drivers use the TDS protocol, which is enabled by default in SQL Server and Azure SQL Database. No additional configuration is required. Install Python runtime and pip package manager. a. Go to python.org b. Click on the appropriate Windows installer msi link. c. Once downloaded run the msi to install Python runtime
The official pymssql wheels bundle a static copy of FreeTDS and have SSL support so they can be used to connect to Azure. On some Linux distributions pip version is too old to support all the flavors of manylinux wheels, so upgrading pip is necessary. An example of such distributions would be Ubuntu 18.04 or Python3.6 module in RHEL8 and CentOS8.
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
181
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!
3
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
