pip安装pyodbc失败错误:为pyodbc构建轮子失败

Question

我正试图将pyodbc库导入谷歌colab，但我收到了这个错误。

以防万一，我的笔记本上安装了蟒蛇，我从来没有遇到过pyodbc的问题。

你能帮我吗？

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('"'"'rn'"'"', '"'"'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.

Answer 1

您可以尝试以下操作：

!apt install unixodbc-dev
!pip install pyodbc

Answer 2

在安装"unixodbc-dev"时，它将请求获得安装所有相关必需库的权限。按照步骤安装pyodbc：

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

Answer 3

遵循以下内容：

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

在安装unixodbc-dev时授予安装权限(如果需要(。

Answer 4

如果需要安装在容器中，下面是对我有用的行。在DockerFile 的开头添加这些行

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