Try to install libiodbc2-dev first. You are missing the sql.h which is
provided by that package.
On Wednesday, July 28, 2021 at 6:50:17 PM UTC+9 chennu....@gmail.com wrote:
> Hi All,
>
> could someone help me here,
> Facing pyodbc installation issue.
>
> command:
> pip install pyodbc
>
>
> error:
> =====
>
> Collecting pyodbc
> Downloading pyodbc-4.0.31.tar.gz (280 kB)
> |████████████████████████████████| 280 kB 4.6 MB/s eta 0:00:01
> Building wheels for collected packages: pyodbc
> Building wheel for pyodbc (setup.py) ... error ERROR: Command errored out
> with exit status 1:
> command: /srv/conda/envs/notebook/bin/python -u -c 'import sys,
> setuptools, tokenize; sys.argv[0] =
> '"'"'/tmp/pip-install-lx0nvnbu/pyodbc_bde09eeb034e4518acf81d3236cbabbf/setup.py'"'"';
>
> __file__='"'"'/tmp/pip-install-lx0nvnbu/pyodbc_bde09eeb034e4518acf81d3236cbabbf/setup.py'"'"';f=getattr(tokenize,
> '"'"'open'"'"', open)(__file__);code=f.read().replace('"'"'\r\n'"'"',
> '"'"'\n'"'"');f.close();exec(compile(code, __file__, '"'"'exec'"'"'))'
> bdist_wheel -d /tmp/pip-wheel-szs7gw8z
> cwd: /tmp/pip-install-lx0nvnbu/pyodbc_bde09eeb034e4518acf81d3236cbabbf/
> Complete output (15 lines):
> running bdist_wheel
> running build
> running build_ext
> building 'pyodbc' extension
> creating build
> creating build/temp.linux-x86_64-3.7
> creating build/temp.linux-x86_64-3.7/src
> /srv/conda/envs/notebook/bin/x86_64-conda-linux-gnu-cc -Wno-unused-result
> -Wsign-compare -DNDEBUG -fwrapv -O2 -Wall -Wstrict-prototypes -march=nocona
> -mtune=haswell -ftree-vectorize -fPIC -fstack-protector-strong -fno-plt -O2
> -pipe -march=nocona -mtune=haswell -ftree-vectorize -fPIC
> -fstack-protector-strong -fno-plt -O2 -pipe -march=nocona -mtune=haswell
> -ftree-vectorize -fPIC -fstack-protector-strong -fno-plt -O2
> -ffunction-sections -pipe -isystem /srv/conda/envs/notebook/include -DNDEBUG
> -D_FORTIFY_SOURCE=2 -O2 -isystem /srv/conda/envs/notebook/include -fPIC
> -DPYODBC_VERSION=4.0.31 -I/srv/conda/envs/notebook/include/python3.7m -c
> src/buffer.cpp -o build/temp.linux-x86_64-3.7/src/buffer.o -Wno-write-strings
> cc1plus: warning: command line option '-Wstrict-prototypes' is valid for
> C/ObjC but not for C++
> In file included from src/buffer.cpp:12:0:
> src/pyodbc.h:56:10: fatal error: sql.h: No such file or directory
> #include <sql.h>
> ^~~~~~~
> compilation terminated.
> error: command '/srv/conda/envs/notebook/bin/x86_64-conda-linux-gnu-cc'
> failed with exit status 1
>
>
>
>
> screenshot for the same.
> [image: image.png]
>
--
You received this message because you are subscribed to the Google Groups
"Project Jupyter" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to jupyter+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jupyter/41f8ab2c-43a1-43da-bc13-049833cd0d95n%40googlegroups.com.
