Unable to install pyodbc on windows server

Python Help
1

Hi
I am unable to install pyodbc or eciespy using PIP install pyodbc.

I get the following error:
ERROR: Command errored out with exit status 1:
command: ‘C:\Program Files\Python\python.exe’ -u -c ‘import io, os, sys, setuptools, tokenize; sys.argv[0] = ‘"’"‘C:\Users\q_infa_svc\AppData\Local\Temp\pip-install-cfrzulp9\cytoolz_cbc6eb836b1d42dfa23b3c2ff0622c8f\setup.py’"’"’; file=’"’"‘C:\Users\q_infa_svc\AppData\Local\Temp\pip-install-cfrzulp9\cytoolz_cbc6eb836b1d42dfa23b3c2ff0622c8f\setup.py’"’"’;f = getattr(tokenize, ‘"’"‘open’"’"’, open)(file) if os.path.exists(file) else io.StringIO(’"’"‘from setuptools import setup; setup()’"’"’);code = f.read().replace(’"’"’\r\n’"’"’, ‘"’"’\n’"’"’);f.close();exec(compile(code, file, ‘"’"‘exec’"’"’))’ install --record ‘C:\Users\q_infa_svc\AppData\Local\Temp\pip-record-sc3frutg\install-record.txt’ --single-version-externally-managed --compile --install-headers ‘C:\Program Files\Python\Include\cytoolz’
cwd: C:\Users\q_infa_svc\AppData\Local\Temp\pip-install-cfrzulp9\cytoolz_cbc6eb836b1d42dfa23b3c2ff0622c8f
Complete output (49 lines):
ALERT: Cython not installed. Building without Cython.
running install
running build
running build_py
creating build
creating build\lib.win-amd64-3.10
creating build\lib.win-amd64-3.10\cytoolz
copying cytoolz\compatibility.py → build\lib.win-amd64-3.10\cytoolz
copying cytoolz_signatures.py → build\lib.win-amd64-3.10\cytoolz
copying cytoolz_version.py → build\lib.win-amd64-3.10\cytoolz
copying cytoolz_init_.py → build\lib.win-amd64-3.10\cytoolz
creating build\lib.win-amd64-3.10\cytoolz\curried
copying cytoolz\curried\exceptions.py → build\lib.win-amd64-3.10\cytoolz\curried
copying cytoolz\curried\operator.py → build\lib.win-amd64-3.10\cytoolz\curried
copying cytoolz\curried_init_.py → build\lib.win-amd64-3.10\cytoolz\curried
copying cytoolz\dicttoolz.pyx → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\functoolz.pyx → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\itertoolz.pyx → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\recipes.pyx → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\utils.pyx → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\cpython.pxd → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\dicttoolz.pxd → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\functoolz.pxd → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\itertoolz.pxd → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\recipes.pxd → build\lib.win-amd64-3.10\cytoolz
copying cytoolz\utils.pxd → build\lib.win-amd64-3.10\cytoolz
copying cytoolz_init_.pxd → build\lib.win-amd64-3.10\cytoolz
creating build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\dev_skip_test.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_compatibility.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_curried.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_curried_toolzlike.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_dev_skip_test.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_dicttoolz.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_docstrings.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_doctests.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_embedded_sigs.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_functoolz.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_inspect_args.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_itertoolz.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_none_safe.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_recipes.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_serialization.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_signatures.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_tlz.py → build\lib.win-amd64-3.10\cytoolz\tests
copying cytoolz\tests\test_utils.py → build\lib.win-amd64-3.10\cytoolz\tests
running build_ext
building ‘cytoolz.dicttoolz’ extension
error: Microsoft Visual C++ 14.0 or greater is required. Get it with “Microsoft C++ Build Tools”: Microsoft C++ Build Tools - Visual Studio
----------------------------------------
ERROR: Command errored out with exit status 1: ‘C:\Program Files\Python\python.exe’ -u -c ‘import io, os, sys, setuptools, tokenize; sys.argv[0] = ‘"’"‘C:\Users\q_infa_svc\AppData\Local\Temp\pip-install-cfrzulp9\cytoolz_cbc6eb836b1d42dfa23b3c2ff0622c8f\setup.py’"’"’; file=’"’"‘C:\Users\q_infa_svc\AppData\Local\Temp\pip-install-cfrzulp9\cytoolz_cbc6eb836b1d42dfa23b3c2ff0622c8f\setup.py’"’"’;f = getattr(tokenize, ‘"’"‘open’"’"’, open)(file) if os.path.exists(file) else io.StringIO(’"’"‘from setuptools import setup; setup()’"’"’);code = f.read().replace(’"’"’\r\n’"’"’, ‘"’"’\n’"’"’);f.close();exec(compile(code, file, ‘"’"‘exec’"’"’))’ install --record ‘C:\Users\q_infa_svc\AppData\Local\Temp\pip-record-sc3frutg\install-record.txt’ --single-version-externally-managed --compile --install-headers ‘C:\Program Files\Python\Include\cytoolz’ Check the logs for full command output.

2

It looks like pyodbc doesn’t yet have wheels built for Python 3.10. You have three options to resolve this:

  1. Install the Microsoft Build tools for C++ and build the package from source yourself
  2. Ask the pyodbc maintainers to build wheels for Python 3.10 and wait
  3. Use Python 3.9 as there are wheels for that version

I would recommend doing 2 followed by 3 while you wait. I would not recommend 1 for fixing this quickly.

3

i am installing python 3.9 version. i am seeing PIP is not installed by default. Did i do something wrong?