Unable to install pyodbc

0
votes

I am using python 3.3.0 .. Within this package C:\Python34\Scripts is my pip and I have added this path to my system and user environment variable PATH the link to this pip folder,I have installed Visual C++ 2010 but i don't know what needs to be done once it is installed if or not i need to configure something, yet when I do :

C:\Python33\Scripts>pip install https://pyodbc.googlecode.com/files/pyodbc-3.0.7.zip

It gives me the following error:

This is what stackoverflow editor has changed it to :

Fatal error in launcher: Unable to create process using
'"C:\Python33\python.exe "  "C:\Python33\Scripts\pip.exe" install
https://pyodbc.googlecode.com/files/pyo dbc-3.0.7.zip'

C:\Python33\Scripts>pip 
Fatal error in launcher: Unable to create process using
'"C:\Python33\python.exe " "C:\Python33\Scripts\pip.exe" '

And this is the actual error that i see at console:

ValueError: ['path']

----------------------------------------
Command "C:\Python33\python.EXE -c "import setuptools, tokenize;__file__='c

\users\elyon\appdata\local\temp\pip-inh3nq-build\setup.py';exec(compi e(getattr(tokenize, 'open', open)(file).read().replace('\r\n', '\n'), __fil __, 'exec'))" install --record c:\users\elyon\appdata\local\temp\pip-x45j1j- ecord\install-record.txt --single-version-externally-managed --compile" failed ith error code 1 in c:\users\elyon\appdata\local\temp\pip-inh3nq-build

1
pythonwindowspython-3.xpippyodbc
possible duplicate of Fatal error in launcher: Unable to create process using '""C:\Program Files (x86)\Python33\python.exe"" "C:\Program Files (x86)\Python33\pip.exe" – Bryan
The accepted answer in the potential duplicate is a workaround, take a look at this answer for an actual fix if a space-containing path is indeed your problem. – Bryan
The suggestions would only be relevant if the install path (current or original) contained spaces. What did you get back from the python -m pip install pyodbc execution? – Bryan
Hi Bryan .I have edited the question above to include what error i actually see on console..meanwhile i tried what you said......C:\Users\elyon>python -m pip install pyodbc ................ Collecting pyodbc Could not find any downloads that satisfy the requirement pyodbc Some externally hosted files were ignored as access to them may be unreliable (use --allow-external pyodbc to allow). No distributions at all found for pyodbc – elyon
Important clause in the message...Some externally hosted files were ignored as access to them may be unreliable (use --allow-external pyodbc to allow). What happens when you run with the --allow-external switch? – Bryan

1 Answers

1
votes

Since you're on Windows with Python 3.3, the easiest way to install pyodbc is to use the provided installers.

You should then be able to manage future upgrades using pip if you so desire.

C:\Python33\Scripts> .\pip.exe install --upgrade --allow-external pyodbc --allow-unverified pyodbc pyodbc

Requirement already up-to-date: pyodbc in c:\python33\lib\site-packages