How to compile QMYSQL plugin with MSVC?

[Christian Ehrlicher]

You did not open the correct visual studio command prompt so the vc env variables are not properly set up.

[BushyAxis793]

OK. So I used Visual Studio Developer Command Prompt and got different errors. I tried also PowerShell but no result. Should I install any special version for MSVC?

[Christian Ehrlicher]

@BushyAxis793 said in How to compile QMYSQL plugin with MSVC?:

Should I install any special version for MSVC?

Why?
Start with a clean build dir from a properly set up environment and if you encounter errors, post them here.

[BushyAxis793]

OK. I understand. Let me show you step by step what I do:

1. Clear everything
2. Open Visual Studio Developer Command Prompt
3. I go to C:\mysql-8.0.28-winx64\

3. I create build-sqldrivers directory

4. I go to build-sqldrivers directory

5. I input command:
   qt-cmake -G Ninja C:\Qt\6.3.0\Src\qtbase\src\plugins\sqldrivers -DCMAKE_INSTALL_PREFIX=C:\Qt\Tools\CMake_64\bin -DMySQL_ROOT="C:\mysql-8.0.28-winx64\mysql-8.0.28-winx64"

And I got error

https://justpaste.it/f66k3

[Christian Ehrlicher]

Hostx86/x86/

You opened the wrong visual studio command prompt. Qt is built with 64bits...

[BushyAxis793]

OK. So I run again Visual Studio Command Prompt and check configuration with:

C:\Users\mnawr\source\repos\Project2>echo %VSCMD_ARG_TGT_ARCH%
x86

Then I change to x64 with:

set VSCMD_ARG_TGT_ARCH=x64

And check again:

C:\Users\mnawr\source\repos\Project2>echo %VSCMD_ARG_TGT_ARCH%
x64

And again create build-sqldrivers directory, run qt-cmake.. and got the error again:

https://justpaste.it/fvn4x

[Christian Ehrlicher]

Please open the correct visual studio command prompt for 64 bits... is it really that hard?

[BushyAxis793]

OK. I used x64 Native Tools Command Prompt for VS 2022 and my result is:

**********************************************************************
** Visual Studio 2022 Developer Command Prompt v17.13.5
** Copyright (c) 2022 Microsoft Corporation
**********************************************************************
[vcvarsall.bat] Environment initialized for: 'x64'

C:\Program Files\Microsoft Visual Studio\2022\Community>cd C:\mysql-8.0.28-winx64

C:\mysql-8.0.28-winx64>mkdir build-sqldrivers

C:\mysql-8.0.28-winx64>cd build-sqldrivers

C:\mysql-8.0.28-winx64\build-sqldrivers>qt-cmake -G Ninja C:\Qt\6.3.0\Src\qtbase\src\plugins\sqldrivers -DCMAKE_INSTALL_PREFIX=C:\Qt\Tools\CMake_64\bin -DMySQL_ROOT="C:\mysql-8.0.28-winx64\mysql-8.0.28-winx64"
-- The CXX compiler identification is MSVC 19.43.34809.0
-- The C compiler identification is MSVC 19.43.34809.0
-- The ASM compiler identification is MSVC
-- Found assembler: C:/Program Files/Microsoft Visual Studio/2022/Community/VC/Tools/MSVC/14.43.34808/bin/Hostx64/x64/cl.exe
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Check for working CXX compiler: C:/Program Files/Microsoft Visual Studio/2022/Community/VC/Tools/MSVC/14.43.34808/bin/Hostx64/x64/cl.exe - skipped
-- Detecting CXX compile features
-- Detecting CXX compile features - done
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working C compiler: C:/Program Files/Microsoft Visual Studio/2022/Community/VC/Tools/MSVC/14.43.34808/bin/Hostx64/x64/cl.exe - skipped
-- Detecting C compile features
-- Detecting C compile features - done
-- 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

-- Configuring done (9.9s)
-- Generating done (0.6s)
-- Build files have been written to: C:/mysql-8.0.28-winx64/build-sqldrivers

C:\mysql-8.0.28-winx64\build-sqldrivers>cmake --build .
[22/22] Linking CXX shared module plugins\sqldrivers\qsqlmysqld.dll

C:\mysql-8.0.28-winx64\build-sqldrivers>cmake --install .
-- Install configuration: "Debug"
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QMYSQLDriverPluginConfig.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QMYSQLDriverPluginConfigVersion.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QMYSQLDriverPluginConfigVersionImpl.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/./plugins/sqldrivers/qsqlmysqld.dll
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QMYSQLDriverPluginTargets.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QMYSQLDriverPluginTargets-debug.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/./plugins/sqldrivers/qsqlmysqld.pdb
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QMYSQLDriverPluginAdditionalTargetInfo.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginConfig.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginConfigVersion.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginConfigVersionImpl.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/./plugins/sqldrivers/qsqlodbcd.dll
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginTargets.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginTargets-debug.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/./plugins/sqldrivers/qsqlodbcd.pdb
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QODBCDriverPluginAdditionalTargetInfo.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginConfig.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginConfigVersion.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginConfigVersionImpl.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/./plugins/sqldrivers/qsqlited.dll
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginTargets.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginTargets-debug.cmake
-- Installing: C:/Qt/Tools/CMake_64/bin/./plugins/sqldrivers/qsqlited.pdb
-- Installing: C:/Qt/Tools/CMake_64/bin/lib/cmake/Qt6Sql/Qt6QSQLiteDriverPluginAdditionalTargetInfo.cmake

C:\mysql-8.0.28-winx64\build-sqldrivers>

I can't see any error but when I go to C:\mysql-8.0.28-winx64\build-sqldrivers\plugins\sqldrivers

I expected qsqlmysql.dll instead of qsqlmysqld.dll.

[Christian Ehrlicher]

You have to build debug and release libs (msvc is picky here)

-DCMAKE_BUILD_TYPE=Release

-DCMAKE_BUILD_TYPE=Debug

Debug was already built.

[BushyAxis793]

Thanks for reply. I run:
qt-cmake with -DCMAKE_BUILD_TYPE=Release parameter. Now my C:\mysql-8.0.28-winx64\build-sqldrivers\plugins\sqldrivers directory looks much better:

I can see qsqlmysql.dll.

I added to my project. It works perfect!

Thank you very much for help and for you patience!

Have a good day :]