pyodbc: pip install pyodbc fails on Windows

this fails consistently on 2 different machines one Windows Server 2012R2 and one Win8.1 the error is the same.

C:\Windows\System32>pip install pyodbc Collecting pyodbc Using cached pyodbc-3.0.10.tar.gz Installing collected packages: pyodbc Running setup.py install for pyodbc Complete output from command “c:\program files (x86)\python 3.5\python.exe” -c “import setuptools, tokenize;file=‘C:\Users\Kiril\AppData\Local\Temp \pip-build-wx_guj66\pyodbc\setup.py’;exec(compile(getattr(tokenize, ‘open’, o pen)(file).read().replace(‘\r\n’, ‘\n’), file, ‘exec’))” install --recor d C:\Users\Kiril\AppData\Local\Temp\pip-0hu94gdr-record\install-record.txt --sin gle-version-externally-managed --compile: running install running build running build_ext building ‘pyodbc’ extension error: [WinError 2] The system cannot find the file specified

----------------------------------------

Command ““c:\program files (x86)\python 3.5\python.exe” -c “import setuptools, t okenize;file=‘C:\Users\Kiril\AppData\Local\Temp\pip-build-wx_guj66\py odbc\setup.py’;exec(compile(getattr(tokenize, ‘open’, open)(file).read().re place(‘\r\n’, ‘\n’), file, ‘exec’))” install --record C:\Users\Kiril\AppData \Local\Temp\pip-0hu94gdr-record\install-record.txt --single-version-externally-m anaged --compile” failed with error code 1 in C:\Users\Kiril\AppData\Local\Temp
pip-build-wx_guj66\pyodbc

C:\Windows\System32>

About this issue

  • Original URL
  • State: closed
  • Created 9 years ago
  • Reactions: 2
  • Comments: 29 (3 by maintainers)

Most upvoted comments

There is no wheel (binary distribution) for 3.5 on PyPI. So while they are not provided you can use unofficial binaries from here. Just download the matching file for Python 3.5 and install it with pip install pyodbc-3.0.10-cp35-none-win32.whl.

@mkleehammer I love pyodbc. Is there any way you could put a wheel for Python 3.5 up on PyPI?

This would make it much easier to build upon!