Hello all,
I have encountered the following error while trying the install an application in which pyodbc is used to connect to a database.
(I added pyodbc==4.0.32 to my requirements.txt)
The app works fine on my laptop and one of the VIKTOR dev’s already mentioned the problem is potentially related to Linux through which VIKTOR is operating.
ERROR: Command errored out with exit status 1:
command: /usr/local/bin/python -u -c 'import io, os, sys, setuptools, tokenize; sys.argv[0] = '"'"'/tmp/pip-install-g9dn89mj/pyodbc_895171c820f34db7a840d7a6e2addcfb/setup.py'"'"'; __file__='"'"'/tmp/pip-install-g9dn89mj/pyodbc_895171c820f34db7a840d7a6e2addcfb/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-mznwelmq
cwd: /tmp/pip-install-g9dn89mj/pyodbc_895171c820f34db7a840d7a6e2addcfb/
Complete output (14 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
gcc -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -g -fwrapv -O3 -Wall -fPIC -DPYODBC_VERSION=4.0.32 -I/usr/local/include/python3.7m -c src/buffer.cpp -o build/temp.linux-x86_64-3.7/src/buffer.o -Wno-write-strings
In file included from src/buffer.cpp:12:
src/pyodbc.h:56:10: fatal error: sql.h: No such file or directory
#include <sql.h>
^~~~~~~
compilation terminated.
error: command 'gcc' failed with exit status 1
----------------------------------------
ERROR: Failed building wheel for pyodbc
I am now looking into pymssql to get my connection running.