pip install pyodbc failed ERROR: Failed building wheel for pyodbc

user_14022171 0
Viewed 31140

I'am trying to import pyodbc library into google colab, but i'am getting this error.

Just in case, I have Anaconda installed in my notebook, and I never had problem with pyodbc in there.

Can you help me please?

Tks!

Collecting pyodbc
  Using cached https://files.pythonhosted.org/packages/81/0d/bb08bb16c97765244791c73e49de9fd4c24bb3ef00313aed82e5640dee5d/pyodbc-4.0.30.tar.gz
Building wheels for collected packages: pyodbc
  Building wheel for pyodbc (setup.py) ... error
  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: /usr/bin/python3 -u -c 'import sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-u5dmb223/pyodbc/setup.py'"'"'; __file__='"'"'/tmp/pip-install-u5dmb223/pyodbc/setup.py'"'"';f=getattr(tokenize, '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"', '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))' install --record /tmp/pip-record-9jmhckrt/install-record.txt --single-version-externally-managed --compile Check the logs for full command output.
pyodbc python
4 Answers

You can try the following:

!apt install unixodbc-dev
!pip install pyodbc
user_144894480

While installing 'unixodbc-dev' it will ask for permission to install all dependent required libraries. Follow the steps to install pyodbc:

!apt install unixodbc-dev --yes
!pip install pyodbc
user_86143140

Follow this one:

!apt install unixodbc-dev --yes
!pip install pyodbc

Giving permission while installing unixodbc-dev to install if anything required.

user_86143140

In case if needed to be installed in the container, then here are the lines which worked for me. Add these in the beginning in DockerFile

USER root
RUN apt-get update && apt-get install build-essential unixodbc-dev -y
RUN pip install pyodbc
user_31987670
Related