Answered by:
VS2017 Enterprise, Python 3.6 Virutal Environment and .whl file installation

Question
-
Hi Python Guru's,
I use Windows 10 and Visual Studio2017 64bit.
I try to install pymssql but the corporate network ensures
that a network connection cant be established.
So I downloaded pymssql-2.1.3-cp36-cp36m-win_amd64.whl manually.
When I now go in VS 2017 to my virtual environment, right click to install
packages and type:
pip install C:\Users\xxxx\Downloads\pymssql-2.1.3-cp36-cp36m-win_amd64.whl
I get the message:
Requirement already satisfied: pip in c:\users\xxxxx\downloads\iwt_django\iwt_django\iwt_django\env_iwt\lib\site-packages
Collecting install
Retrying (Retry(total=4, connect=None, read=None, redirect=None)) after connection broken by 'NewConnectionError('<pip._vendor....
Could not find a version that satisfies the requirement install (from versions: )
No matching distribution found for install
----- Failed to install 'pip install C:\Users\xxxx\Downloads\pymssql-2.1.3-cp36-cp36m-win_amd64.whl' -----
I read on Stackoverflow I can do the following to install into my virtual environment:
py -m pip install C:\Users\xxxxx\Downloads\pymssql-2.1.3-cp36-cp36m-win_amd64.whl
But that just does not work.
Question; How do I install pymssql into my virtual environment?- Moved by Sara LiuMicrosoft contingent staff Monday, October 16, 2017 8:07 AM
Friday, October 6, 2017 8:25 AM
Answers
-
I downloaded python 3.6 and created
the whole virtual environment.
I opened cmd and cd to:
C:\Users\metalray\Downloads\iwt_django\iwt_django\iwt_django\env_iwt\Scripts
I type activate and end up with:
(env_iwt) C:\Users\metalray\Downloads\iwt_django\iwt_django\iwt_django\env_iwt\Sc
ripts>
when I type there:
py -3.6 -m pip install C:\Users\metalray\Downloads\pymssql-2.1.3-cp36-cp36m-win32.whl- Marked as answer by metallon123 Tuesday, November 7, 2017 1:22 PM
Tuesday, November 7, 2017 1:22 PM
All replies
-
Hi metallon123,
Welcome to the MSDN forum.
To install the pymssql package, please check this doc: Step 1: Configure development environment for pymssql Python development and follow those steps, especially the step ‘Download pymssql module’, once you download the .whl file place it in the python installation folder. It seems you directly download and save the .whl file into the ‘Downloads’ folder, please remove it to the right python installation folder and try it again.
>> Could not find a version that satisfies the requirement install (from versions:)
You can have a look at this: How do I install pip on Windows? and make sure your environment variable PATH includes Python's folders.
Best regards,
Sara
MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
Monday, October 9, 2017 2:23 AM -
Hi Sara,
Thanks for your reply.
I would like to install pymssql in the virtual environment that I set up with Visual Studio, not for the basic python environment on my PC.
Can I use the whl file to install into my virtual python environment?
Monday, October 9, 2017 7:56 AM -
Hi metallon,
Thank you for your update and sorry for my misunderstanding.
For the issue about the pymssql whl installation, it is better to redirect to this appropriate forum: https://github.com/pymssql/pymssql/issues to seek for a more professional support that come from the pymssql developers, our forum is to discuss the VS IDE. Sorry for this inconvenience and thank you for your cooperation.
If you have any other issues about the VS IDE in the future, please feel free to let us know.
Best regards,
Sara
MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com
- Proposed as answer by Sara LiuMicrosoft contingent staff Wednesday, October 11, 2017 8:28 AM
Tuesday, October 10, 2017 5:40 AM -
I downloaded python 3.6 and created
the whole virtual environment.
I opened cmd and cd to:
C:\Users\metalray\Downloads\iwt_django\iwt_django\iwt_django\env_iwt\Scripts
I type activate and end up with:
(env_iwt) C:\Users\metalray\Downloads\iwt_django\iwt_django\iwt_django\env_iwt\Sc
ripts>
when I type there:
py -3.6 -m pip install C:\Users\metalray\Downloads\pymssql-2.1.3-cp36-cp36m-win32.whl- Marked as answer by metallon123 Tuesday, November 7, 2017 1:22 PM
Tuesday, November 7, 2017 1:22 PM