(Jun-22-2019, 09:28 AM)stixmagiggins Wrote: ImportError: DLL load failed: %1 is not a valid Win32 application.This is error message is almost always a mix up 32-bit and 64-bit.
(Jun-22-2019, 09:28 AM)stixmagiggins Wrote: There doesn't appear to be a win32 version of pymssql so it fails.No this is just wrong.
Type
python
in cmd.This is what matter
[MSC v.1916 32 bit (Intel)]
or look like this [MSC v.1915 64 bit (AMD64)]
.This is Python version 32-bit and 64-bit.
If i test on 32-bit Python version.
E:\div_code λ python Python 3.7.3 (v3.7.3:ef4ec6ed12, Mar 25 2019, 21:26:53) [MSC v.1916 32 bit (Intel)] on win32 Type "help", "copyright", "credits" or "license" for more information. >>> exit() E:\div_code λ pip -V pip 19.1.1 from c:\python37\lib\site-packages\pip (python 3.7) E:\div_code λ pip install pymssql Collecting pymssql Downloading .... pymssql-2.1.4-cp37-cp37m-win32.whl (353kB) Installing collected packages: pymssql Successfully installed pymssql-2.1.4You see that it find correct wheel
pymssql-2.1.4-cp37-cp37m-win32.whl
This mean that wheel if for Python 3.7 and 32-bit version of Python
If i test it will work.
>>> import pymssql >>> pymssql.VERSION (2, 1, 4) >>> exit()So it should detected correct version,on Gohlke pymssql
The 64-bit version is
pymssql‑2.1.4‑cp37‑cp37m‑win_amd64.whl
.If i download with my Anaconda Python version which is 64-bit.
You see that it download wheel i marked over.
G:\Anaconda3\Scripts λ pip install pymssql Collecting pymssql Downloading .... pymssql-2.1.4-cp37-cp37m-win_amd64.whl (411kB) Installing collected packages: pymssql Successfully installed pymssql-2.1.4