Pymssql library failing when upgrading to Python 3.7 - win32 issue

[snippsat]

Even though Python is 64bit it is on win32. Does that affect things?

No,it's the Python version of 32-bit or 64-bit that matter,most have 64-bit version of Windows these days.
Look at installation tutorial make sure you make new folder Path as shown there so you get all new files.
So no files get mixed up.

It should auto detect 32 or 64 bit when do pip install pymssql.
Can do it manually download pip install pymssql‑2.1.4‑cp37‑cp37m‑win_amd64.whl,but should not be needed.
So this is the 64-bit wheel,so i use a Python 64-bit version.

G:\Anaconda3
λ python
Python 3.7.3 (default, Mar 27 2019, 17:13:21) [MSC v.1915 64 bit (AMD64)] :: Anaconda, Inc. on win32

[MSC v.1915 64 bit (AMD64)] the version on Python.

G:\Anaconda3\Scripts
# Manually wheel install 
λ pip install pymssql-2.1.4-cp37-cp37m-win_amd64.whl
Processing g:\anaconda3\scripts\pymssql-2.1.4-cp37-cp37m-win_amd64.whl
Installing collected packages: pymssql
Successfully installed pymssql-2.1.4

No error it work.

G:\Anaconda3
λ python
Python 3.7.3 (default, Mar 27 2019, 17:13:21) [MSC v.1915 64 bit (AMD64)] :: Anaconda, Inc. on win32
>>> import pymssql
>>> pymssql.VERSION
(2, 1, 4)
>>>
>>> exit()