CODEWITHSUNDEEP
pythonpython-3.xlinuxpippyodbc
ix.trc
ix.trc

Reputation: 81

How to solve installation error of pyodbc on Ubunutu 20.04?

I am trying to install pyodbc on Ubunut 20.04 (LTS) and get the following error.

$pip3 install --user pyodbc
Collecting pyodbc
  Using cached pyodbc-4.0.32.tar.gz (280 kB)
  Preparing metadata (setup.py) ... done
Building wheels for collected packages: pyodbc
  Building wheel for pyodbc (setup.py) ... error
  ERROR: Command errored out with exit status 1:
   command: /home/linuxbrew/.linuxbrew/opt/[email protected]/bin/python3.9 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-gn6zk8ei/pyodbc_4351fd17af0242d6b5939cae9874f889/setup.py'"'"'; __file__='"'"'/tmp/pip-install-gn6zk8ei/pyodbc_4351fd17af0242d6b5939cae9874f889/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'"'"'))' bdist_wheel -d /tmp/pip-wheel-ceo1au72
       cwd: /tmp/pip-install-gn6zk8ei/pyodbc_4351fd17af0242d6b5939cae9874f889/
  Complete output (9 lines):
  running bdist_wheel
  running build
  running build_ext
  building 'pyodbc' extension
  creating build
  creating build/temp.linux-x86_64-3.9
  creating build/temp.linux-x86_64-3.9/src
  gcc-5 -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -g -O3 -Wall -fPIC -DPYODBC_VERSION=4.0.32 -I/home/linuxbrew/.linuxbrew/include -I/home/linuxbrew/.linuxbrew/opt/[email protected]/include -I/home/linuxbrew/.linuxbrew/opt/sqlite/include -I/home/linuxbrew/.linuxbrew/opt/[email protected]/include/python3.9 -c src/buffer.cpp -o build/temp.linux-x86_64-3.9/src/buffer.o -Wno-write-strings
  error: command 'gcc-5' failed: No such file or directory
  ----------------------------------------
  ERROR: Failed building wheel for pyodbc
  Running setup.py clean for pyodbc
Failed to build pyodbc
Installing collected packages: pyodbc
    Running setup.py install for pyodbc ... error
    ERROR: Command errored out with exit status 1:
     command: /home/linuxbrew/.linuxbrew/opt/[email protected]/bin/python3.9 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-gn6zk8ei/pyodbc_4351fd17af0242d6b5939cae9874f889/setup.py'"'"'; __file__='"'"'/tmp/pip-install-gn6zk8ei/pyodbc_4351fd17af0242d6b5939cae9874f889/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 /tmp/pip-record-m8e62n8n/install-record.txt --single-version-externally-managed --user --prefix= --compile --install-headers /home/user/.local/include/python3.9/pyodbc
         cwd: /tmp/pip-install-gn6zk8ei/pyodbc_4351fd17af0242d6b5939cae9874f889/
    Complete output (9 lines):
    running install
    running build
    running build_ext
    building 'pyodbc' extension
    creating build
    creating build/temp.linux-x86_64-3.9
    creating build/temp.linux-x86_64-3.9/src
    gcc-5 -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -g -O3 -Wall -fPIC -DPYODBC_VERSION=4.0.32 -I/home/linuxbrew/.linuxbrew/include -I/home/linuxbrew/.linuxbrew/opt/[email protected]/include -I/home/linuxbrew/.linuxbrew/opt/sqlite/include -I/home/linuxbrew/.linuxbrew/opt/[email protected]/include/python3.9 -c src/buffer.cpp -o build/temp.linux-x86_64-3.9/src/buffer.o -Wno-write-strings
    error: command 'gcc-5' failed: No such file or directory
    ----------------------------------------
ERROR: Command errored out with exit status 1: /home/linuxbrew/.linuxbrew/opt/[email protected]/bin/python3.9 -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-gn6zk8ei/pyodbc_4351fd17af0242d6b5939cae9874f889/setup.py'"'"'; __file__='"'"'/tmp/pip-install-gn6zk8ei/pyodbc_4351fd17af0242d6b5939cae9874f889/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 /tmp/pip-record-m8e62n8n/install-record.txt --single-version-externally-managed --user --prefix= --compile --install-headers /home/user/.local/include/python3.9/pyodbc Check the logs for full command output.

Installing gcc-5 via apt didn't work since it is not available for installation. I currently have gcc-9 compiler installed.

I tried installing python3-dev python3-pip as described in Error installing pandas_profiling with Pip on Ubuntu 20.04 and https://github.com/mkleehammer/pyodbc/wiki/Install#installing-on-linux, but it didn't solve the issue.

Any help is greatly appreciated.

Upvotes: 3

Views: 2655

Answers (1)

nlta
nlta

Reputation: 1914

From the docs

sudo apt install python3-pip python3-dev unixodbc-dev
pip3 install --user pyodbc

This is for 18.04 but I suspect it'll work for you too.

Upvotes: 4

Related Questions