Pymssql library failing when upgrading to Python 3.7 - win32 issue

[stixmagiggins]

Hi,

I upgraded Python from 3.4 to 3.7 and now when I test my code I get the error

File "J:\Python_Scripts\Python_Application_Testing_Briars\BriarsNurseryApp.pyw", line 13, in <module>
import pymssql #http://pymssql.org/en/stable/
File "src\_mssql.pxd", line 10, in init pymssql
ImportError: DLL load failed: %1 is not a valid Win32 application.

I've read discussions and have tried various suggestions, such as installing the pymssql wheel directly from https://www.lfd.uci.edu/~gohlke/pythonlibs/ and uninstalling/upgrading pip, Python and pymssql but nothing works.
My machine is 64bit so I installed the Windows x86-64 web-based installer version of Python. I did try the 32bit version but other errors appeared.
There doesn't appear to be a win32 version of pymssql so it fails. Has anyone else had this problem specificially with pymssql and Python 3.7? I also read the error could be misleading.

Thanks