Error building pymssql on Windows - tdsutils.lib does not exist.

[Kiyotoshi Ichikawa]

Hey all,

I'm using Python 3.6 on Windows 10 and am trying to install pymssql. I have fought my way through all build errors except this one: LINK : fatal error LNK1181: cannot open input file 'tdsutils.lib'

I have done the following to get to this point:

1. Downloaded most recent x86_x64 FreeTDS from here: https://github.com/ramiro/freetds/releases
2. Downloaded OpenSSL from here: http://www.npcglib.org/~stathis/blog/precompiled-openssl/
3. Set the following environment variables:
   1. $env:INCLUDE = "C:\Program Files (x86)\Windows Kits\10\Include\10.0.16299.0\ucrt;C:\Program Files (x86)\Windows Kits\10\Include\10.0.16299.0\shared;C:\Program Files (x86)\freetds-v0.95.95-win-x86_64-vs2015\include;C:\Program Files (x86)\Windows Kits\10\Include\10.0.16299.0\um"
      
   2. $env:LIB = "C:\Program Files (x86)\Windows Kits\10\Lib\10.0.16299.0\ucrt\x64;C:\Program Files (x86)\freetds-v0.95.95-win-x86_64-vs2015\lib;C:\Program Files (x86)\Windows Kits\10\Lib\10.0.16299.0\um\x64;C:\Program Files (x86)\freetds-v0.95.95-win-x86_64-vs2015\lib\static;"
      
4. Run pipenv install pymssql or just pip install pymssql.

I have searched for this file and cannot find it, but I do see it referenced in the source here: pymssql/setup.py at master · pymssql/pymssql · GitHub and do not see it in the version of FreeTDS I downloaded. Has anyone run into this?

[Mikhail Terekhov]

Hello,

You can see how Windows wheels are build here:

https://github.com/pymssql/pymssql/blob/f486f7d79bd2583eba96323cdeca34eb8f14cd2a/.github/workflows/test_windows.yml#L52

https://github.com/pymssql/pymssql/blob/f486f7d79bd2583eba96323cdeca34eb8f14cd2a/dev/build.py#L109

Or you can just install from pypi.

Regards,

Mikhail