Hello, I have a problem installing the pymssql database using Python
version 3.11.4, pip 23.1.2 when executing the command
"pip install pymssql". I need it to install Apache Superset. My OS is
Windows 10 64-bit. The first part of the script compiled via C++ normally
using visual studio community C++ 2022 installed on my computer, but later
the script wrote that it needs BuildTools C++ 14 or higher. the superset
itself was installed OK, but I still cannot run it.
The latest version of BuildTools C++ is installed on my PC, as well as
Visual studio community 2022. Please explain how I can instruct the script
to take the C++ BuildTools that is already installed on my computer?
It looks like the script doesn't see it. Note: i have upgraded pip, wheel,
buildtools to the latest version.
I am submitting a text of logs when executing the "pip install pymssql"
command.
George
===
an error while invoking: pip install pymssql (see below)
(venv) D:\superset\venv\Scripts>pip install pymssql
Collecting pymssql
Using cached pymssql-2.2.8.tar.gz (171 kB)
Installing build dependencies ... done
Getting requirements to build wheel ... done
Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: pymssql
Building wheel for pymssql (pyproject.toml) ... error
error: subprocess-exited-with-error
× Building wheel for pymssql (pyproject.toml) did not run successfully.
│ exit code: 1
╰─> [34 lines of output]
setup.py: platform.system() => Windows
setup.py: platform.architecture() => ('64bit', 'WindowsPE')
setup.py: include_dirs => []
setup.py: library_dirs => []
running bdist_wheel
running build
running build_py
creating build
creating build\lib.win-amd64-cpython-311
creating build\lib.win-amd64-cpython-311\pymssql
copying src\pymssql\__init__.py ->
build\lib.win-amd64-cpython-311\pymssql
running build_ext
warning: src\pymssql\_mssql.pyx:27:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:28:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:29:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:30:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:31:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:32:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:35:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:36:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:38:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:82:0: The 'IF' statement is
deprecated and will be removed in a future Cython version. Consider using
runtime conditions or C macros instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:230:0: The 'DEF' statement is
deprecated and will be removed in a future Cython version. Consider using
global variables, constants, and in-place literals instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:264:4: The 'IF' statement is
deprecated and will be removed in a future Cython version. Consider using
runtime conditions or C macros instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:333:4: The 'IF' statement is
deprecated and will be removed in a future Cython version. Consider using
runtime conditions or C macros instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:831:8: The 'IF' statement is
deprecated and will be removed in a future Cython version. Consider using
runtime conditions or C macros instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:919:8: The 'IF' statement is
deprecated and will be removed in a future Cython version. Consider using
runtime conditions or C macros instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:1005:12: The 'IF' statement is
deprecated and will be removed in a future Cython version. Consider using
runtime conditions or C macros instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:1379:16: The 'IF' statement is
deprecated and will be removed in a future Cython version. Consider using
runtime conditions or C macros instead. See
https://github.com/cython/cython/issues/4310
warning: src\pymssql\_mssql.pyx:1713:8: The 'IF' statement is
deprecated and will be removed in a future Cython version. Consider using
runtime conditions or C macros instead. See
https://github.com/cython/cython/issues/4310
Compiling src\pymssql\_mssql.pyx because it changed.
[1/1] Cythonizing src\pymssql\_mssql.pyx
building 'pymssql._mssql' extension
error: Microsoft Visual C++ 14.0 or greater is required. Get it with
"Microsoft C++ Build Tools":
https://visualstudio.microsoft.com/visual-cpp-build-tools/
[end of output]
note: This error originates from a subprocess, and is likely not a
problem with pip.
ERROR: Failed building wheel for pymssql
Failed to build pymssql
ERROR: Could not build wheels for pymssql, which is required to install
pyproject.toml-based projects
