Hello,

  Trying to install pyodbc on a 7.2 server. We have it installed on aix 7.3 server. On that one, it still needs some kind of odbc manager, so if that rings a bell as well, that would be great, also. But when I do the install, I get this message.

Defaulting to user installation because normal site-packages is not writeable

Collecting pyodbc

  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

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

  ╰─> [18 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.aix-7.2-cpython-37

      copying src/pyodbc.pyi -> build/lib.aix-7.2-cpython-37

      running build_ext

      building 'pyodbc' extension

      creating build/temp.aix-7.2-cpython-37

      creating build/temp.aix-7.2-cpython-37/src

      gcc -maix64 -fPIC -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -I/usr/include -I/opt/freeware/include -I/opt/freeware/include/ncurses -DAIX_GENUINE_CPLUSCPLUS -D_LINUX_SOURCE_COMPAT -Wl,-brtl -O2 -fPIC -I/usr/include -I/opt/freeware/include -I/opt/freeware/include/ncurses -DAIX_GENUINE_CPLUSCPLUS -D_LINUX_SOURCE_COMPAT -Wl,-brtl -O2 -fPIC -DPYODBC_VERSION=4.0.39 -I/opt/freeware/include/python3.7m -c src/buffer.cpp -o build/temp.aix-7.2-cpython-37/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 '/usr/bin/gcc' failed with exit code 1

      [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

Thanks

Steve Hansell

Digital & IT Technical Specialist

Infrastructure Engineer

Parker Hannifin Corporation

Midrange Team

stevenhansell@parker.com

I think you are missing unixODBC-devel package that provides sql.h file.

Please install this RPM package from AIX toolbox and try again.

Hello,

  Trying to install pyodbc on a 7.2 server. We have it installed on aix 7.3 server. On that one, it still needs some kind of odbc manager, so if that rings a bell as well, that would be great, also. But when I do the install, I get this message.

Defaulting to user installation because normal site-packages is not writeable

Collecting pyodbc

  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

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

  ╰─> [18 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.aix-7.2-cpython-37

      copying src/pyodbc.pyi -> build/lib.aix-7.2-cpython-37

      running build_ext

      building 'pyodbc' extension

      creating build/temp.aix-7.2-cpython-37

      creating build/temp.aix-7.2-cpython-37/src

      gcc -maix64 -fPIC -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -I/usr/include -I/opt/freeware/include -I/opt/freeware/include/ncurses -DAIX_GENUINE_CPLUSCPLUS -D_LINUX_SOURCE_COMPAT -Wl,-brtl -O2 -fPIC -I/usr/include -I/opt/freeware/include -I/opt/freeware/include/ncurses -DAIX_GENUINE_CPLUSCPLUS -D_LINUX_SOURCE_COMPAT -Wl,-brtl -O2 -fPIC -DPYODBC_VERSION=4.0.39 -I/opt/freeware/include/python3.7m -c src/buffer.cpp -o build/temp.aix-7.2-cpython-37/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 '/usr/bin/gcc' failed with exit code 1

      [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

Thanks

Steve Hansell

Digital & IT Technical Specialist

Infrastructure Engineer

Parker Hannifin Corporation

Midrange Team

stevenhansell@parker.com

I think you are missing unixODBC-devel package that provides sql.h file.

Please install this RPM package from AIX toolbox and try again.

Hello,

  Trying to install pyodbc on a 7.2 server. We have it installed on aix 7.3 server. On that one, it still needs some kind of odbc manager, so if that rings a bell as well, that would be great, also. But when I do the install, I get this message.

Defaulting to user installation because normal site-packages is not writeable

Collecting pyodbc

  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

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

  ╰─> [18 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.aix-7.2-cpython-37

      copying src/pyodbc.pyi -> build/lib.aix-7.2-cpython-37

      running build_ext

      building 'pyodbc' extension

      creating build/temp.aix-7.2-cpython-37

      creating build/temp.aix-7.2-cpython-37/src

      gcc -maix64 -fPIC -pthread -Wno-unused-result -Wsign-compare -DNDEBUG -O2 -I/usr/include -I/opt/freeware/include -I/opt/freeware/include/ncurses -DAIX_GENUINE_CPLUSCPLUS -D_LINUX_SOURCE_COMPAT -Wl,-brtl -O2 -fPIC -I/usr/include -I/opt/freeware/include -I/opt/freeware/include/ncurses -DAIX_GENUINE_CPLUSCPLUS -D_LINUX_SOURCE_COMPAT -Wl,-brtl -O2 -fPIC -DPYODBC_VERSION=4.0.39 -I/opt/freeware/include/python3.7m -c src/buffer.cpp -o build/temp.aix-7.2-cpython-37/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 '/usr/bin/gcc' failed with exit code 1

      [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

Thanks

Steve Hansell

Digital & IT Technical Specialist

Infrastructure Engineer

Parker Hannifin Corporation

Midrange Team

stevenhansell@parker.com