Solved QT5.15.0, MySQL database, msvc2015_64 and Windows 10
-
output from normal command prompt:
C:\Program Files\VCG\MeshLab>path PATH=C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\iCLS\;C:\Program Files\Intel\Intel(R) Management Engine Components\iCLS\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\dotnet\;C:\Program Files\Point Grey Research\FlyCapture2\bin64;C:\Program Files\Point Grey Research\FlyCapture2\bin64\vs2013;C:\Program Files\Point Grey Research\FlyCapture2\bin64\vs2015;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Windows Kits\8.1\Windows Performance Toolkit\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\Sontheim\MT_Api;C:\Program Files (x86)\Sontheim\MT_Api\;C:\Server\PHP;C:\WINDOWS\system32\config\systemprofile\.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm\;C:\Program Files (x86)\nodejs\;C:\Program Files\Git\cmd;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Windows Kits\10\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\39328\AppData\Local\Microsoft\WindowsApps;C:\Users\39328\AppData\Roaming\npm;C:\Users\39328\.dotnet\tools
output from x64 VS2019 native tools:
********************************************************************** ** Visual Studio 2019 Developer Command Prompt v16.6.5 ** Copyright (c) 2020 Microsoft Corporation ********************************************************************** [vcvarsall.bat] Environment initialized for: 'x64' C:\Program Files (x86)\Microsoft Visual Studio\2019\Community>path PATH=C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\\Extensions\Microsoft\IntelliCode\CLI;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\HostX64\x64;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\VC\VCPackages;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\TestWindow;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\TeamFoundation\Team Explorer;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\MSBuild\Current\bin\Roslyn;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Team Tools\Performance Tools\x64;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Team Tools\Performance Tools;C:\Program Files (x86)\Microsoft Visual Studio\Shared\Common\VSPerfCollectionTools\vs2019\\x64;C:\Program Files (x86)\Microsoft Visual Studio\Shared\Common\VSPerfCollectionTools\vs2019\;C:\Program Files (x86)\Microsoft SDKs\Windows\v10.0A\bin\NETFX 4.8 Tools\x64\;C:\Program Files (x86)\HTML Help Workshop;C:\Program Files (x86)\Windows Kits\10\bin\10.0.19041.0\x64;C:\Program Files (x86)\Windows Kits\10\bin\x64;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\\MSBuild\Current\Bin;C:\WINDOWS\Microsoft.NET\Framework64\v4.0.30319;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\Tools\;C:\Program Files (x86)\Common Files\Oracle\Java\javapath;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\iCLS\;C:\Program Files\Intel\Intel(R) Management Engine Components\iCLS\;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\NVIDIA Corporation\PhysX\Common;C:\Program Files\dotnet\;C:\Program Files\Point Grey Research\FlyCapture2\bin64;C:\Program Files\Point Grey Research\FlyCapture2\bin64\vs2013;C:\Program Files\Point Grey Research\FlyCapture2\bin64\vs2015;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\110\Tools\Binn\;C:\Program Files (x86)\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\Tools\Binn\;C:\Program Files\Microsoft SQL Server\120\DTS\Binn\;C:\Program Files (x86)\Windows Kits\8.1\Windows Performance Toolkit\;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;C:\Program Files\Intel\WiFi\bin\;C:\Program Files\Common Files\Intel\WirelessCommon\;C:\Program Files (x86)\Sontheim\MT_Api;C:\Program Files (x86)\Sontheim\MT_Api\;C:\Server\PHP;C:\WINDOWS\system32\config\systemprofile\.dnx\bin;C:\Program Files\Microsoft DNX\Dnvm\;C:\Program Files (x86)\nodejs\;C:\Program Files\Git\cmd;C:\Program Files\Microsoft SQL Server\130\Tools\Binn\;C:\Program Files (x86)\Windows Kits\10\Windows Performance Toolkit\;C:\Program Files\Microsoft SQL Server\Client SDK\ODBC\170\Tools\Binn\;C:\Program Files\MySQL\MySQL Shell 8.0\bin\;C:\Users\39328\AppData\Local\Microsoft\WindowsApps;C:\Users\39328\AppData\Roaming\npm;C:\Users\39328\.dotnet\tools;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\CMake\CMake\bin;C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE\CommonExtensions\Microsoft\CMake\Ninja
-
@Marcus-Barnet
Ok, there is not x86 and x64 bin in the normal PATH, I'm a little confused...
But I've checked your vs2019 output.
It seems the mysql plugins have already been copied to the plugin folder.
So you should have done the job.
Check C:\Qt\5.15.0\msvc2019_64\plugins\sqldrivers, do you have qsqlmysql.dll and qsqlmysqld.dll there?
If yes, just copy libmysql.dll from "MySQL Connector C 6.1\lib" (or bin, I'm not sure) to "C:\Qt\5.15.0\msvc2019_64\bin", then it is finished.Ah, if you still want to try the vs2015_64 one.
I think maybe you could run "set PATH=C:\Program Files (x86)\Windows Kits\8.1\bin\x64;%PATH%" after qtenv2.bat. -
Finally, it works! Thank you!
I just followed your advice and I copied the libmysql.dll to "C:\Qt\5.15.0\msvc2019_64\bin" after checked the presence of qsqlmysql.dll and qsqlmysqld.dll in sqldrivers.I tried to compile my project in QtCreator and it worked with mscv2019_64 so I think it's OK for me to use this one instead of the 2015 version.
The project compiles and it is able to connect to MySQL, I only get a warning from the Qtcreator console:
:-1: warning: "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\x86_amd64\cl.exe" is used by qmake, but "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\BIN\amd64\cl.exe" is configured in the kit. Please update your kit (Desktop Qt 5.15.0 MSVC2019 64bit) or choose a mkspec for qmake that matches your target environment better.
-
@Marcus-Barnet
That's a little weird, that path seems to be vs2015 compiler.
Check the Kits setting of QtCreator, make sure you select the right C/C++ compiler.
For vs2019_64 that should be 16.x.xxxxx.xx (amd64) -
This is my current configuration:
and I can select Visual C++ compiler16.6.30320.27 (amd64)
Should I switch to this other one?
-
@Marcus-Barnet said in QT5.15.0, MySQL database, msvc2015_64 and Windows 10:
and I can select Visual C++ compiler16.6.30320.27 (amd64)
Should I switch to this other one?Yes, change both C and C++ to 16.6.30320.27 (amd64)
-
I switched it, it compiled the first time my project and everything was OK.
I tried to compile it again and it gives me this error:
:-1: error: LNK1104: cannot open file 'release\PUMP.exe'
where PUMP.exe is my project executable.
I never had this problem before.
I also get this other warning:
yvals_core.h:462:2: error: STL1000: Unexpected compiler version, expected Clang 9.0.0 or newer. pump.h:1:1: note: in file included from C:\Qt\Examples\Qt-5.15.0\PUMP\pump.h:1: pump.h:4:10: note: in file included from C:\Qt\Examples\Qt-5.15.0\PUMP\pump.h:4: QMainWindow:1:10: note: in file included from C:\Qt\5.15.0\msvc2019_64\include\QtWidgets\QMainWindow:1: qmainwindow.h:43:10: note: in file included from C:\Qt\5.15.0\msvc2019_64\include\QtWidgets\qmainwindow.h:43: qtwidgetsglobal.h:43:10: note: in file included from C:\Qt\5.15.0\msvc2019_64\include\QtWidgets\qtwidgetsglobal.h:43: qtguiglobal.h:43:10: note: in file included from C:\Qt\5.15.0\msvc2019_64\include\QtGui\qtguiglobal.h:43: qglobal.h:45:12: note: in file included from C:\Qt\5.15.0\msvc2019_64\include\QtCore\qglobal.h:45: type_traits:9:10: note: in file included from C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\include\type_traits:9:
pump.h is very simple:
#ifndef PUMP_H #define PUMP_H #include <QMainWindow> #include <QtSql> #include <QSqlDatabase> QT_BEGIN_NAMESPACE namespace Ui { class Pump; } QT_END_NAMESPACE class Pump : public QMainWindow { Q_OBJECT public: Pump(QWidget *parent = nullptr); ~Pump(); private slots: void on_pushButton_clicked(); private: Ui::Pump *ui; }; #endif // PUMP_H
-
PUMP.exe is created during the first compilation (I can run it) and then when I click on build again, it disappears and I get that error.
-
Do you use shadow build? Delete your build folder and try again.
-
@Bonnie said in QT5.15.0, MySQL database, msvc2015_64 and Windows 10:
Do you use shadow build? Delete your build folder and try again.
Thank you for your support, everything works fine now!
@hskoglund: thank you to you, too, for your support!