Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?

BAHRAMUDIN ADIL

@J-Hilk One problem I am getting while using Qt with MSVC 2019, my code not getting compiled:

main.obj:-1: error: LNK2019: unresolved external symbol "__declspec(dllimport) public: __cdecl QSqlDatabase::~QSqlDatabase(void)" (__imp_??1QSqlDatabase@@QEAA@XZ) referenced in function main

But same code works well with Qt + MSVC 2017.

Christian Ehrlicher

@BAHRAMUDIN-ADIL said in Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?:

But same code works well with Qt + MSVC 2017.

I doubt that - I would guess you don't link against the Qt sql library. Please show us your .pro file and/or make sure you're linking against the correct libraries you need.

BAHRAMUDIN ADIL

@Christian-Ehrlicher It is the .pro file content:

QT -= gui

CONFIG += c++11 console sql
CONFIG -= app_bundle

# The following define makes your compiler emit warnings if you use
# any Qt feature that has been marked deprecated (the exact warnings
# depend on your compiler). Please consult the documentation of the
# deprecated API in order to know how to port your code away from it.
DEFINES += QT_DEPRECATED_WARNINGS

# You can also make your code fail to compile if it uses deprecated APIs.
# In order to do so, uncomment the following line.
# You can also select to disable deprecated APIs only up to a certain version of Qt.
#DEFINES += QT_DISABLE_DEPRECATED_BEFORE=0x060000    # disables all the APIs deprecated before Qt 6.0.0

SOURCES += \
        main.cpp

# Default rules for deployment.
qnx: target.path = /tmp/$${TARGET}/bin
else: unix:!android: target.path = /opt/$${TARGET}/bin
!isEmpty(target.path): INSTALLS += target

I have all the DLL and libs files in the Qt installed location bin/lib folder.

SimonSchroeder

According to the documentation (https://doc.qt.io/qt-5/qsqldatabase.html) you should add

QT += sql

to your .pro file. This tells the compiler to link with the SQL plugin.

BAHRAMUDIN ADIL

@SimonSchroeder Thanks! I will try it.

SGaist

@BAHRAMUDIN-ADIL said in Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?:

@SimonSchroeder If you see carefully I have already added sql

To the wrong variable. You added it to CONFIG but you shall add it to QT as @SimonSchroeder wrote.

[edit: Answer to the original post SGaist]

BAHRAMUDIN ADIL

@SimonSchroeder Yes, I did not add the SQL module correctly in .pro file. But now I got this error:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7

BAHRAMUDIN ADIL

@SGaist Hmmm, yes, it was my fault, but now I got the next error, what is your opinion?
I have already added these two DLL files in Qt bin directory:

libmysqld.dll
libmysql.dll

And also I have tried these three as well:

ssleay32.dll
libeay32.dll
libmysql.lib

Also not solved the problem.

J.Hilk

@BAHRAMUDIN-ADIL
after modifying your pro file, ALWAYS clean and run qmake

you added a new module so I would go a step further and delete the build directory for a complete rebuild

BAHRAMUDIN ADIL

@J-Hilk Yes, I did that as you said, but the problem still exists. Can you tell me what files and libs I need to add and add them in which place? Thanks!

SGaist

@BAHRAMUDIN-ADIL said in Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?:

QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7

As you can see from the listing, you don't have the plugin at all.

As for why: the licensing of MySQL changed so only GPL and Commercial are available now. Since the pre-built binaries are usable also under the LGPL, the plugin can't be provided.

You also have the option of building it with MariaDB which fixes the licensing issue.

See QTBUG-78241

BAHRAMUDIN ADIL

@SGaist You mean that I need to build Qt from source with the needed plugins? Or I just need to build the MySQL plugin? If the second case is right, then to build the only plugin, what should I need, and how to build? Is there any guide to show how to build?
Thanks!

aha_1980

@BAHRAMUDIN-ADIL

you need to build the plugin as described here: https://doc.qt.io/qt-5/sql-driver.html#qmysql

Regards

BAHRAMUDIN ADIL

@aha_1980 Yes, before you send me the answer I saw this documentation, but can you tell me where is it?

cd %QTDIR%\qtbase\src\plugins\sqldrivers

I did not find in whole Qt installation directory.

Thank you so much!!!

Christian Ehrlicher

@BAHRAMUDIN-ADIL said in Qt already updated to 5.14.1, but why it still uses MSVC 2017 build tools?:

I did not find in whole Qt installation directory.

As you can see there is 'src' - you need the Qt sources...

BAHRAMUDIN ADIL

@Christian-Ehrlicher Hmmm, so for a small plugin I need to download the whole Qt source code? It definitely takes a lot of time and takes much space. I think the Qt team should think about it to make it easy just to download only what I need not all the source code or provide some other way to overcome this problem because MySql users are very a lot on all over the world. If all the users download the source code it will so be extra pressure on Qt side server and also not good user experience.

I hope the Qt becomes more beautiful in the feature!!

aha_1980

@BAHRAMUDIN-ADIL You don't need to tell us - we are just users like you and not related to the Qt company.

You might also want to use the MariaDB plugin which does not have the MySQL licence restrictions.

Btw: you can download the sources with the MaintenanceTool.

Regards

BAHRAMUDIN ADIL

@aha_1980 What is the problem with the following output? I did everything step by step as the document, but why I am getting this error?
Note: I am using MySql 8 and installed successfully and there is no problem with MySql server.

C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers>qmake -- MYSQL_INCDIR="C:/Program Files/MySQL/MySQL Server 8.0/include" MYSQL_LIBDIR="C:/Program Files/MySQL/MySQL Server 8.0/lib"
Info: creating stash file C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers\.qmake.stash

Running configuration tests...
Checking for DB2 (IBM)... no
Checking for InterBase... no
Checking for MySQL... no
Checking for OCI (Oracle)... no
Checking for ODBC... yes
Checking for PostgreSQL... no
Checking for SQLite (version 2)... no
Checking for TDS (Sybase)... no
Done running configuration tests.

Configure summary:

Qt Sql Drivers:
  DB2 (IBM) .............................. no
  InterBase .............................. no
  MySql .................................. no
  OCI (Oracle) ........................... no
  ODBC ................................... yes
  PostgreSQL ............................. no
  SQLite2 ................................ no
  SQLite ................................. yes
    Using system provided SQLite ......... no
  TDS (Sybase) ........................... no

Qt is now configured for building. Just run 'nmake'.
Once everything is built, you must run 'nmake install'.
Qt will be installed into 'C:\Qt\5.14.0\msvc2017_64'.

Prior to reconfiguration, make sure you remove any leftovers from
the previous build.


C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers>nmake sub-mysql

Microsoft (R) Program Maintenance Utility Version 14.24.28316.0
Copyright (C) Microsoft Corporation.  All rights reserved.

NMAKE : fatal error U1073: don't know how to make 'sub-mysql'
Stop.

C:\Qt\5.14.1\Src\qtbase\src\plugins\sqldrivers>

SGaist

Take a closer look at the configure test logs to see exactly why the detection failed.

BAHRAMUDIN ADIL

@SGaist Still it is throwing error, I going to not use Qt anymore, and go for Java, the best and the easy language all over the word it is why Java is always on the top of all of the languages.