pyodbc - Erro install

[JoseRFJuniorLLMs]

Core:

• installed: 1.7.0
• latest: 1.7.0 - Up to date!

C:\Users\jose.junior\dbt_poc\dbt_poc>pip install dbt-sqlserver
Collecting dbt-sqlserver
Using cached dbt_sqlserver-1.4.3-py3-none-any.whl.metadata (4.3 kB)
Collecting dbt-core~=1.4.5 (from dbt-sqlserver)
Using cached dbt_core-1.4.9-py3-none-any.whl.metadata (4.1 kB)
Collecting pyodbc!=4.0.36,!=4.0.37,=4.0.35 (from dbt-sqlserver)
Using cached pyodbc-4.0.39.tar.gz (282 kB)
Installing build dependencies ... done
Getting requirements to build wheel ... done
Installing backend dependencies ... done
Preparing metadata (pyproject.toml) ... done
Collecting azure-identity>=1.12.0 (from dbt-sqlserver)
Using cached azure_identity-1.15.0-py3-none-any.whl.metadata (75 kB)
Collecting azure-core<2.0.0,>=1.23.0 (from azure-identity>=1.12.0->dbt-sqlserver)
Using cached azure_core-1.29.5-py3-none-any.whl.metadata (36 kB)
Requirement already satisfied: cryptography>=2.5 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from azure-identity>=1.12.0->dbt-sqlserver) (41.0.5)
Collecting msal<2.0.0,>=1.24.0 (from azure-identity>=1.12.0->dbt-sqlserver)
Using cached msal-1.24.1-py2.py3-none-any.whl.metadata (11 kB)
Collecting msal-extensions<2.0.0,>=0.3.0 (from azure-identity>=1.12.0->dbt-sqlserver)
Using cached msal_extensions-1.0.0-py2.py3-none-any.whl (19 kB)
Requirement already satisfied: Jinja2==3.1.2 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core=1.4.5->dbt-sqlserver) (3.1.2)
Collecting agate<1.7.1,>=1.6 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached agate-1.7.0-py2.py3-none-any.whl (97 kB)
Collecting betterproto==1.2.5 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached betterproto-1.2.5-py3-none-any.whl
Collecting click<8.1.4,>=7.0 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached click-8.1.3-py3-none-any.whl (96 kB)
Requirement already satisfied: colorama<0.4.7,>=0.3.9 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (0.4.6)
Collecting hologram<=0.0.16,>=0.0.14 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached hologram-0.0.16-py3-none-any.whl (11 kB)
Requirement already satisfied: isodate<0.7,>=0.6 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (0.6.1)
Requirement already satisfied: logbook<1.6,>=1.5 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (1.5.3)
Collecting mashumaro==3.3.1 (from mashumaro[msgpack]==3.3.1->dbt-core~=1.4.5->dbt-sqlserver)
Using cached mashumaro-3.3.1-py3-none-any.whl (86 kB)
Requirement already satisfied: minimal-snowplow-tracker==0.0.2 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (0.0.2)
Requirement already satisfied: packaging>20.9 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (23.2)
Collecting sqlparse<0.4.4,>=0.2.3 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached sqlparse-0.4.3-py3-none-any.whl (42 kB)
Collecting dbt-extractor~=0.4.1 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached dbt_extractor-0.4.1-cp36-abi3-win_amd64.whl (245 kB)
Requirement already satisfied: typing-extensions>=3.7.4 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (4.8.0)
Collecting werkzeug<3,>=1 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached werkzeug-2.3.7-py3-none-any.whl.metadata (4.1 kB)
Collecting pathspec<0.11,>=0.9 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached pathspec-0.10.3-py3-none-any.whl (29 kB)
Requirement already satisfied: pytz>=2015.7 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (2023.3.post1)
Requirement already satisfied: requests<3.0.0 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (2.31.0)
Requirement already satisfied: idna<4,>=2.5 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (3.4)
Requirement already satisfied: cffi<2.0.0,>=1.9 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (1.16.0)
Requirement already satisfied: pyyaml>=6.0 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from dbt-core~=1.4.5->dbt-sqlserver) (6.0.1)
Collecting networkx<3,>=2.3 (from dbt-core~=1.4.5->dbt-sqlserver)
Using cached networkx-2.8.8-py3-none-any.whl (2.0 MB)
Collecting grpclib (from betterproto==1.2.5->dbt-core~=1.4.5->dbt-sqlserver)
Using cached grpclib-0.4.6-py3-none-any.whl
Collecting stringcase (from betterproto==1.2.5->dbt-core~=1.4.5->dbt-sqlserver)
Using cached stringcase-1.2.0-py3-none-any.whl
Requirement already satisfied: MarkupSafe>=2.0 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from Jinja2==3.1.2->dbt-core~=1.4.5->dbt-sqlserver) (2.1.3)
Requirement already satisfied: msgpack>=0.5.6 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from mashumaro[msgpack]==3.3.1->dbt-core~=1.4.5->dbt-sqlserver) (1.0.7)
Requirement already satisfied: six<2.0,>=1.9.0 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from minimal-snowplow-tracker==0.0.2->dbt-core~=1.4.5->dbt-sqlserver) (1.16.0)
Requirement already satisfied: Babel>=2.0 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from agate<1.7.1,>=1.6->dbt-core~=1.4.5->dbt-sqlserver) (2.13.1)
Requirement already satisfied: leather>=0.3.2 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from agate<1.7.1,>=1.6->dbt-core~=1.4.5->dbt-sqlserver) (0.3.4)
Collecting parsedatetime!=2.5,!=2.6,>=2.1 (from agate<1.7.1,>=1.6->dbt-core~=1.4.5->dbt-sqlserver)
Using cached parsedatetime-2.4-py3-none-any.whl
Requirement already satisfied: python-slugify>=1.2.1 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from agate<1.7.1,>=1.6->dbt-core~=1.4.5->dbt-sqlserver) (8.0.1)
Requirement already satisfied: pytimeparse>=1.1.5 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from agate<1.7.1,>=1.6->dbt-core~=1.4.5->dbt-sqlserver) (1.1.8)
Requirement already satisfied: pycparser in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from cffi<2.0.0,>=1.9->dbt-core~=1.4.5->dbt-sqlserver) (2.21)
Requirement already satisfied: python-dateutil<2.9,>=2.8 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from hologram<=0.0.16,>=0.0.14->dbt-core~=1.4.5->dbt-sqlserver) (2.8.2)
Requirement already satisfied: jsonschema>=3.0 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from hologram<=0.0.16,>=0.0.14->dbt-core~=1.4.5->dbt-sqlserver) (4.19.2)
Requirement already satisfied: PyJWT<3,>=1.0.0 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from PyJWT[crypto]<3,>=1.0.0->msal<2.0.0,>=1.24.0->azure-identity>=1.12.0->dbt-sqlserver) (2.8.0)
Collecting portalocker<3,>=1.6 (from msal-extensions<2.0.0,>=0.3.0->azure-identity>=1.12.0->dbt-sqlserver)
Using cached portalocker-2.8.2-py3-none-any.whl.metadata (8.5 kB)
Requirement already satisfied: charset-normalizer<4,>=2 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from requests<3.0.0->dbt-core~=1.4.5->dbt-sqlserver) (3.3.2)
Requirement already satisfied: urllib3<3,>=1.21.1 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from requests<3.0.0->dbt-core~=1.4.5->dbt-sqlserver) (1.26.18)
Requirement already satisfied: certifi>=2017.4.17 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from requests<3.0.0->dbt-core~=1.4.5->dbt-sqlserver) (2023.7.22)
Requirement already satisfied: setuptools in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from Babel>=2.0->agate<1.7.1,>=1.6->dbt-core~=1.4.5->dbt-sqlserver) (68.2.2)
Requirement already satisfied: attrs>=22.2.0 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from jsonschema>=3.0->hologram<=0.0.16,>=0.0.14->dbt-core~=1.4.5->dbt-sqlserver) (23.1.0)
Requirement already satisfied: jsonschema-specifications>=2023.03.6 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from jsonschema>=3.0->hologram<=0.0.16,>=0.0.14->dbt-core~=1.4.5->dbt-sqlserver) (2023.7.1)
Requirement already satisfied: referencing>=0.28.4 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from jsonschema>=3.0->hologram<=0.0.16,>=0.0.14->dbt-core~=1.4.5->dbt-sqlserver) (0.30.2)
Requirement already satisfied: rpds-py>=0.7.1 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from jsonschema>=3.0->hologram<=0.0.16,>=0.0.14->dbt-core~=1.4.5->dbt-sqlserver) (0.10.6)
Collecting future (from parsedatetime!=2.5,!=2.6,>=2.1->agate<1.7.1,>=1.6->dbt-core~=1.4.5->dbt-sqlserver)
Using cached future-0.18.3-py3-none-any.whl
Collecting pywin32>=226 (from portalocker<3,>=1.6->msal-extensions<2.0.0,>=0.3.0->azure-identity>=1.12.0->dbt-sqlserver)
Using cached pywin32-306-cp312-cp312-win_amd64.whl (9.2 MB)
Requirement already satisfied: text-unidecode>=1.3 in c:\users\jose.junior\appdata\local\programs\python\python312\lib\site-packages (from python-slugify>=1.2.1->agate<1.7.1,>=1.6->dbt-core~=1.4.5->dbt-sqlserver) (1.3)
Collecting h2<5,>=3.1.0 (from grpclib->betterproto==1.2.5->dbt-core~=1.4.5->dbt-sqlserver)
Using cached h2-4.1.0-py3-none-any.whl (57 kB)
Collecting multidict (from grpclib->betterproto==1.2.5->dbt-core~=1.4.5->dbt-sqlserver)
Using cached multidict-6.0.4-cp312-cp312-win_amd64.whl
Collecting hyperframe<7,>=6.0 (from h2<5,>=3.1.0->grpclib->betterproto==1.2.5->dbt-core~=1.4.5->dbt-sqlserver)
Using cached hyperframe-6.0.1-py3-none-any.whl (12 kB)
Collecting hpack<5,>=4.0 (from h2<5,>=3.1.0->grpclib->betterproto==1.2.5->dbt-core~=1.4.5->dbt-sqlserver)
Using cached hpack-4.0.0-py3-none-any.whl (32 kB)
Using cached dbt_sqlserver-1.4.3-py3-none-any.whl (31 kB)
Using cached azure_identity-1.15.0-py3-none-any.whl (164 kB)
Using cached dbt_core-1.4.9-py3-none-any.whl (924 kB)
Using cached azure_core-1.29.5-py3-none-any.whl (192 kB)
Using cached msal-1.24.1-py2.py3-none-any.whl (95 kB)
Using cached werkzeug-2.3.7-py3-none-any.whl (242 kB)
Using cached portalocker-2.8.2-py3-none-any.whl (17 kB)
Building wheels for collected packages: pyodbc
Building wheel for pyodbc (pyproject.toml) ... error
error: subprocess-exited-with-error

× Building wheel for pyodbc (pyproject.toml) did not run successfully.
│ exit code: 1
╰─> [25 lines of output]
WARNING: '' not a valid package name; please use only .-separated package names in setup.py
running bdist_wheel
running build
running build_py
creating build
creating build\lib.win-amd64-cpython-312
copying src\pyodbc.pyi -> build\lib.win-amd64-cpython-312
running build_ext
building 'pyodbc' extension
creating build\temp.win-amd64-cpython-312
creating build\temp.win-amd64-cpython-312\Release
creating build\temp.win-amd64-cpython-312\Release\src
"C:\Program Files\Microsoft Visual Studio\2022\Professional\VC\Tools\MSVC\14.37.32822\bin\HostX86\x64\cl.exe" /c /nologo /O2 /W3 /GL /DNDEBUG /MD -DPYODBC_VERSION=4.0.39 -IC:\Users\jose.junior\AppData\Local\Programs\Python\Python312\include -IC:\Users\jose.junior\AppData\Local\Programs\Python\Python312\Include "-IC:\Program Files\Microsoft Visual Studio\2022\Professional\VC\Tools\MSVC\14.37.32822\include" "-IC:\Program Files\Microsoft Visual Studio\2022\Professional\VC\Tools\MSVC\14.37.32822\ATLMFC\include" "-IC:\Program Files\Microsoft Visual Studio\2022\Professional\VC\Auxiliary\VS\include" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\ucrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\um" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\shared" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\winrt" "-IC:\Program Files (x86)\Windows Kits\10\include\10.0.22621.0\cppwinrt" "-IC:\Program Files (x86)\Windows Kits\NETFXSDK\4.8\include\um" /EHsc /Tpsrc\buffer.cpp /Fobuild\temp.win-amd64-cpython-312\Release\src\buffer.obj /Wall /wd4514 /wd4820 /wd4668 /wd4711 /wd4100 /wd4127 /wd4191 /d2FH4-
buffer.cpp
C:\Users\jose.junior\AppData\Local\Programs\Python\Python312\include\cpython/unicodeobject.h(343): warning C4365: '=': conversion from 'unsigned int' to 'int', signed/unsigned mismatch
C:\Users\jose.junior\AppData\Local\Programs\Python\Python312\include\cpython/unicodeobject.h(367): warning C4365: '=': conversion from 'unsigned int' to 'int', signed/unsigned mismatch
C:\Users\jose.junior\AppData\Local\Programs\Python\Python312\include\cpython/longintrepr.h(121): warning C4365: 'initializing': conversion from 'uintptr_t' to 'Py_ssize_t', signed/unsigned mismatch
C:\Users\jose.junior\AppData\Local\Programs\Python\Python312\include\cpython/ceval.h(31): warning C5039: 'PyUnstable_Eval_RequestCodeExtraIndex': pointer or reference to potentially throwing function passed to 'extern "C"' function under -EHc. Undefined behavior may occur if this function throws an exception.
C:\Users\jose.junior\AppData\Local\Programs\Python\Python312\include\cpython/abstract.h(60): warning C4365: 'return': conversion from 'size_t' to 'Py_ssize_t', signed/unsigned mismatch
C:\Users\jose.junior\AppData\Local\Temp\pip-install-n0l2zog_\pyodbc_2c00c79831df43dd99c16026cbb43ec5\src\pyodbccompat.h(75): error C3861: 'PyUnicode_FromUnicode': identifier not found
C:\Users\jose.junior\AppData\Local\Temp\pip-install-n0l2zog_\pyodbc_2c00c79831df43dd99c16026cbb43ec5\src\pyodbccompat.h(86): error C3861: 'PyUnicode_AS_UNICODE': identifier not found
C:\Users\jose.junior\AppData\Local\Temp\pip-install-n0l2zog_\pyodbc_2c00c79831df43dd99c16026cbb43ec5\src\pyodbccompat.h(126): error C3861: 'PyUnicode_GET_SIZE': identifier not found
C:\Users\jose.junior\AppData\Local\Temp\pip-install-n0l2zog_\pyodbc_2c00c79831df43dd99c16026cbb43ec5\src\pyodbccompat.h(146): error C3861: 'PyUnicode_GET_SIZE': identifier not found
C:\Users\jose.junior\AppData\Local\Temp\pip-install-n0l2zog_\pyodbc_2c00c79831df43dd99c16026cbb43ec5\src\pyodbccompat.h(147): error C3861: 'PyUnicode_AS_UNICODE': identifier not found
error: command 'C:\Program Files\Microsoft Visual Studio\2022\Professional\VC\Tools\MSVC\14.37.32822\bin\HostX86\x64\cl.exe' failed with exit code 2
[end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
ERROR: Failed building wheel for pyodbc
Failed to build pyodbc
ERROR: Could not build wheels for pyodbc, which is required to install pyproject.toml-based projects

[romiof]

Issue related with #441