Qt6.8.1 Windows is not having qsqloci.dll

Qt6User

Hello

The online Qt maintenance installer for Qt version 6.8.1 has below DLLs in the directory C:\Qt\6.8.1\msvc2022_64\plugins\sqldrivers

Directory of C:\Qt\6.8.1\msvc2022_64\plugins\sqldrivers

qsqlite.dll
qsqlmimer.dll
qsqlodbc.dll
qsqlpsql.dll

But I don't see qsqloci.dll present above? Am I missing any specific option while using Online QT maintenance installer?

Christian Ehrlicher

@Qt6User said in Qt6.8.1 Windows is not having qsqloci.dll:

Am I missing any specific option while using Online QT maintenance installer?

Those plug-ins are not available in pre-compiled form. You have to build them by yourself: https://doc.qt.io/qt-6/sql-driver.html#how-to-build-the-oci-plugin-on-unix-and-macos

Qt6User

@Christian-Ehrlicher

I need your help in building the QT SQL OCI Plugin i.e. qsqloci.dll

I have installed Qt 6.8.1 using online maintenance installer. I do have several DLLs under C:\Qt\6.8.1\msvc2022_64\plugins\sqldrivers but not the qsqloci.dll. So i followed the instructions which you shared in last response for windows.

a) I installed oracle instant client libs (instantclient-basic-windows.x64-23.8.0.25.04.zip) at C:\oracle\instantclient_23_8 and SDK (instantclient-sdk-windows.x64-23.8.0.25.04.zip) at C:\oracle\sdk.

b) Then from the Developer Command Prompt for VS 2022 I issued below

C:\Qt\6.8.1\build-sqloci>cmake -G "Visual Studio 17 2022" -A x64 -T v143 "C:\Qt\6.8.1\Src\qtbase\src\plugins\sqldrivers" -DCMAKE_INSTALL_PREFIX="C:\Qt\6.8.1\build-sqloci\install" -DOracle_ROOT="C:\oracle" -DCMAKE_PREFIX_PATH="C:\Qt\6.8.1\msvc2022_64\lib\cmake\Qt6"

But I am getting errors as below

-- Selecting Windows SDK version 10.0.22621.0 to target Windows 10.0.27863.
-- Performing Test CMAKE_HAVE_LIBC_PTHREAD
-- Performing Test CMAKE_HAVE_LIBC_PTHREAD - Failed
-- Looking for pthread_create in pthreads
-- Looking for pthread_create in pthreads - not found
-- Looking for pthread_create in pthread
-- Looking for pthread_create in pthread - not found
-- Found Threads: TRUE
-- Performing Test HAVE_STDATOMIC
-- Performing Test HAVE_STDATOMIC - Success
-- Found WrapAtomic: TRUE
CMake Warning at C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtBuildHelpers.cmake:12 (message):
  The officially supported CMake generator for building Qt is Ninja / Ninja
  Multi-Config.  You are using: 'Visual Studio 17 2022' instead.  Thus, you
  might encounter issues.  Use at your own risk.
Call Stack (most recent call first):
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtBuildHelpers.cmake:396 (qt_internal_validate_cmake_generator)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtBuild.cmake:4 (qt_internal_setup_build_and_global_variables)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtSetup.cmake:6 (include)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtBuildRepoHelpers.cmake:21 (include)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtBuildRepoHelpers.cmake:112 (qt_build_internals_set_up_private_api)
  CMakeLists.txt:26 (qt_prepare_standalone_project)


-- Building for multiple configurations: RelWithDebInfo;Debug.
-- Main configuration is: RelWithDebInfo.
CMake Warning (dev) at C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPublicSbomHelpers.cmake:2584 (cmake_parse_arguments):
  The PACKAGE_NAME keyword was followed by an empty string or no value at
  all.  Policy CMP0174 is not set, so cmake_parse_arguments() will unset the
  arg_PACKAGE_NAME variable rather than setting it to an empty string.
Call Stack (most recent call first):
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPublicSbomHelpers.cmake:1926 (_qt_internal_sbom_record_target_spdx_id)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPluginHelpers.cmake:446 (_qt_internal_extend_sbom)
  psql/CMakeLists.txt:10 (qt_internal_add_plugin)
This warning is for project developers.  Use -Wno-dev to suppress it.

CMake Error at C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPublicSbomHelpers.cmake:2552 (message):
  No SBOM project name was set.
Call Stack (most recent call first):
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPublicSbomHelpers.cmake:2542 (_qt_internal_sbom_get_root_project_name_lower_case)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPublicSbomHelpers.cmake:2636 (_qt_internal_sbom_get_root_project_name_for_spdx_id)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPublicSbomHelpers.cmake:2603 (_qt_internal_sbom_generate_target_package_spdx_id)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPublicSbomHelpers.cmake:1926 (_qt_internal_sbom_record_target_spdx_id)
  C:/Qt/6.8.1/msvc2022_64/lib/cmake/Qt6/QtPluginHelpers.cmake:446 (_qt_internal_extend_sbom)
  psql/CMakeLists.txt:10 (qt_internal_add_plugin)


-- Configuring incomplete, errors occurred!

Am i missing something? Could you please guide so that I am able to build the qsqloci.dll in Windows and later do the same in Linux x64?

Qt6User

@Qt6User said in Qt6.8.1 Windows is not having qsqloci.dll:

@Christian-Ehrlicher

@Christian-Ehrlicher
Looks like setting -DQT_GENERATE_SBOM=OFF made the error go.

Christian Ehrlicher

@Qt6User said in Qt6.8.1 Windows is not having qsqloci.dll:

Looks like setting -DQT_GENERATE_SBOM=OFF made the error go.

Yes, that is a known issue with 6.8.1