Python Forum
Pymssql library failing when upgrading to Python 3.7 - win32 issue
Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Pymssql library failing when upgrading to Python 3.7 - win32 issue
#4
(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.4
You 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
Reply


Messages In This Thread
RE: Pymssql library failing when upgrading to Python 3.7 - win32 issue - by snippsat - Jun-24-2019, 12:15 AM

Possibly Related Threads…
Thread Author Replies Views Last Post
  Failing to connect by 'net use' tester_V 1 320 Apr-20-2024, 06:31 AM
Last Post: tester_V
  Failing regex tester_V 3 1,291 Aug-16-2022, 03:53 PM
Last Post: deanhystad
  Upgrading from 2 to 3 and having file write problems KenHorse 2 1,563 May-08-2022, 09:47 PM
Last Post: KenHorse
  Python library for win32 console commands eldiener 3 3,612 Aug-24-2021, 10:28 PM
Last Post: bowlofred
  Win32\ping.exe windows pops up -very annoying... tester_V 9 3,394 Aug-12-2021, 06:54 AM
Last Post: tester_V
  Failing to connect to a host with WMI tester_V 6 4,563 Aug-10-2021, 06:25 PM
Last Post: tester_V
  Failing to get Stat for a Directory tester_V 11 3,735 Jul-20-2021, 10:59 PM
Last Post: Larz60+
  Issue with a library ebolisa 2 1,863 Feb-27-2021, 08:35 AM
Last Post: ebolisa
Exclamation binwalk Win32 compile hackstunt 2 4,009 Feb-24-2021, 05:14 PM
Last Post: nilamo
  Virtual environment and upgrading python 3.5 to 3.9 NeilUK 4 12,406 Jan-24-2021, 01:02 PM
Last Post: snippsat

Forum Jump:

User Panel Messages

Announcements
Announcement #1 8/1/2020
Announcement #2 8/2/2020
Announcement #3 8/6/2020