Building database driver, IT difficulties
-
You're dev environment is not properly set up. You did not open it via 'Visual Studio command prompt' so the variables for your compiler are not there. Nothing Qt-related.
wrote on 26 Apr 2021, 11:28 last edited by@Christian-Ehrlicher , where would I find that option? I've right clicked in the File Explorer and the only options appearing in the context menu are:
Open with Visual Studio Git GUI Here Git Bash HereMaybe something else the installer couldn't complete due to IT restrictions?
-
@J-Hilk , its like mission impossible, the laptop is so locked down its very difficult. I've cleaned out the cache:
rm -R config.*Then run nmake. result is:
Microsoft (R) Program Maintenance Utility Version 14.00.24245.0 Copyright (C) Microsoft Corporation. All rights reserved. cd sqlite\ && ( if not exist Makefile c:\Qt\Qt5.9.2\5.9.2\msvc2015\bin\qmake.exe -o Makefile C:\Qt\Qt5.9.2\5.9.2\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\nmake.exe" -f Makefile Microsoft (R) Program Maintenance Utility Version 14.00.24245.0 Copyright (C) Microsoft Corporation. All rights reserved. "C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\nmake.exe" -f Makefile.Release all Microsoft (R) Program Maintenance Utility Version 14.00.24245.0 Copyright (C) Microsoft Corporation. All rights reserved. rc /NOLOGO -DUNICODE -D_UNICODE -DWIN32 -DNDEBUG -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -fo .obj\release\qsqlite_resource.res qsqlite_resource.rc qsqlite_resource.rc(1) : fatal error RC1015: cannot open include file 'windows.h'. NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\rc.EXE"' : return code '0x1' Stop. NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio 14.0\VC\bin\nmake.exe"' : return code '0x2' Stop. NMAKE : fatal error U1077: 'cd' : return code '0x2' Stop.wrote on 26 Apr 2021, 11:29 last edited by@SPlatten said in Building database driver, IT difficulties:
its like mission impossible, the laptop is so locked down its very difficult. I've cleaned out the cache:
It is not easy but follow this https://forum.qt.io/post/656068 and it should work
-
@SPlatten said in Building database driver, IT difficulties:
its like mission impossible, the laptop is so locked down its very difficult. I've cleaned out the cache:
It is not easy but follow this https://forum.qt.io/post/656068 and it should work
wrote on 26 Apr 2021, 11:57 last edited by@KroMignon , excellent, thank you.
-
@KroMignon , excellent, thank you.
wrote on 26 Apr 2021, 11:58 last edited by -
wrote on 26 Apr 2021, 12:21 last edited by
@KroMignon , now it all appears to have built without any issues, I'm using source that I wrote on my iMAC when doing the same thing, have put in the database details using driver name QMYSQL, but when I try to connect I get the output:
QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 -
@KroMignon , now it all appears to have built without any issues, I'm using source that I wrote on my iMAC when doing the same thing, have put in the database details using driver name QMYSQL, but when I try to connect I get the output:
QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 -
@SPlatten
Whenever you getQMYSQL driver not loaded, start by setting environment variableQT_DEBUG_PLUGINS=1, run application, look at diagnostic output, especially at end.wrote on 26 Apr 2021, 12:29 last edited by@JonB said in Building database driver, IT difficulties:
QT_DEBUG_PLUGINS
Thats easier said than done, on this system I cannot set environment variables....
-
@KroMignon , now it all appears to have built without any issues, I'm using source that I wrote on my iMAC when doing the same thing, have put in the database details using driver name QMYSQL, but when I try to connect I get the output:
QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7wrote on 26 Apr 2021, 12:31 last edited by@SPlatten said in Building database driver, IT difficulties:
QSqlDatabase: QMYSQL driver not loaded
QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7I guess the mysql-connector dynamic library (libmysql.dll) is not in your path
-
@JonB said in Building database driver, IT difficulties:
QT_DEBUG_PLUGINS
Thats easier said than done, on this system I cannot set environment variables....
wrote on 26 Apr 2021, 12:33 last edited by JonB@SPlatten said in Building database driver, IT difficulties:
Thats easier said than done, on this system I cannot set environment variables....
That is an unusual statement, I have not heard of such a system. You will have problems if you cannot set environment variables....
You should be able to do so. Even if you have to write a one-line "wrapper" program....
-
@JonB said in Building database driver, IT difficulties:
QT_DEBUG_PLUGINS
Thats easier said than done, on this system I cannot set environment variables....
wrote on 26 Apr 2021, 12:35 last edited by@SPlatten said in Building database driver, IT difficulties:
Thats easier said than done, on this system I cannot set environment variables....
You can do it with Qt-Creator: Projects / Build & Run, Select "Run", than in "Run Settings"/Environment you can add as many environment variable as you want => cf. https://doc.qt.io/qtcreator/creator-project-settings-environment.html
-
@SPlatten said in Building database driver, IT difficulties:
Thats easier said than done, on this system I cannot set environment variables....
That is an unusual statement, I have not heard of such a system. You will have problems if you cannot set environment variables....
You should be able to do so. Even if you have to write a one-line "wrapper" program....
-
@JonB , tell me about it, please read the first post on this thread for more information.
wrote on 26 Apr 2021, 12:51 last edited by JonB@SPlatten
If you meanI cannot modify system environment variables
there is no need to set a system variable, only an environment variable for the duration of running your program. Either in a Command Prompt, or as @KroMignon wrote in Qt Creator if you are running from there. Or in a
.batscript, or in a one-line "wrapper" C/C++ program. heck, you're runningnmake, that I believe sets environment variables, you could even do so from there....And, depending on when Qt produces that runtime error, if it's on the statement which creates a
QSqlDatabase, as I think it might be, then you can just set the environment variable in the Qt program you are writing beforehand. -
@SPlatten
If you meanI cannot modify system environment variables
there is no need to set a system variable, only an environment variable for the duration of running your program. Either in a Command Prompt, or as @KroMignon wrote in Qt Creator if you are running from there. Or in a
.batscript, or in a one-line "wrapper" C/C++ program. heck, you're runningnmake, that I believe sets environment variables, you could even do so from there....And, depending on when Qt produces that runtime error, if it's on the statement which creates a
QSqlDatabase, as I think it might be, then you can just set the environment variable in the Qt program you are writing beforehand. -
@JonB , setting an environment variable doesn't help when Qt Creator is running at the system level. Any environment variable added to the console, is only visible to the environment of the console.
wrote on 26 Apr 2021, 12:58 last edited by JonB@SPlatten
I have tried to show you a number of places you can set the environment variable. If you really say you cannot from Qt Creator (I don't understand why not and I don't understand what you are saying), try any of the others.... -
@JonB , setting an environment variable doesn't help when Qt Creator is running at the system level. Any environment variable added to the console, is only visible to the environment of the console.
wrote on 26 Apr 2021, 13:06 last edited by@SPlatten said in Building database driver, IT difficulties:
setting an environment variable doesn't help when Qt Creator is running at the system level. Any environment variable added to the console, is only visible to the environment of the console.
Have you only try it out?
Based on your first post on this thread, you are using Qt Creator 4.4.1.
Settings environment variables with QtCreator works for me, on any system I am using (WindowsXP/7/10 and Linux).
So I cannot imagine it will not work for you. -
@SPlatten said in Building database driver, IT difficulties:
setting an environment variable doesn't help when Qt Creator is running at the system level. Any environment variable added to the console, is only visible to the environment of the console.
Have you only try it out?
Based on your first post on this thread, you are using Qt Creator 4.4.1.
Settings environment variables with QtCreator works for me, on any system I am using (WindowsXP/7/10 and Linux).
So I cannot imagine it will not work for you.wrote on 26 Apr 2021, 13:16 last edited by@KroMignon , just created the variable and verified that it is there using EXPORT, rebuilt project in Qt Creator and executed, no new / additional output in Application Output and the console just contains:
QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 -
@KroMignon , just created the variable and verified that it is there using EXPORT, rebuilt project in Qt Creator and executed, no new / additional output in Application Output and the console just contains:
QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 -
@KroMignon , just created the variable and verified that it is there using EXPORT, rebuilt project in Qt Creator and executed, no new / additional output in Application Output and the console just contains:
QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7wrote on 26 Apr 2021, 13:26 last edited by KroMignon@SPlatten said in Building database driver, IT difficulties:
just created the variable and verified that it is there using EXPORT, rebuilt project in Qt Creator and executed, no new / additional output in Application Output and the console just contains:
You don't have to recompile your application, just setup the environment variable for you project
And the run the application with F5 or Ctrl+R, that's it.
But as I have written before, I am quiet sure your problem is that the mysql-connector dynamic library is not in your path.
The easiest way to solve this is to copylibmysql.dllin to Qt lib path, which should be for Qt 5.9.2 ==>C:\Qt\5.9.2\msvc2015\bin\ -
@SPlatten said in Building database driver, IT difficulties:
just created the variable and verified that it is there using EXPORT, rebuilt project in Qt Creator and executed, no new / additional output in Application Output and the console just contains:
You don't have to recompile your application, just setup the environment variable for you project
And the run the application with F5 or Ctrl+R, that's it.
But as I have written before, I am quiet sure your problem is that the mysql-connector dynamic library is not in your path.
The easiest way to solve this is to copylibmysql.dllin to Qt lib path, which should be for Qt 5.9.2 ==>C:\Qt\5.9.2\msvc2015\bin\wrote on 26 Apr 2021, 13:39 last edited by SPlatten@KroMignon thank you...again!
This is the output from my application:
Client name - Training Server Initialising application core... QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms" ... QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2d.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2d.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "direct2d" ] }, "className": "QWindowsDirect2DIntegrationPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2d.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2dd.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2dd.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "direct2d" ] }, "className": "QWindowsDirect2DIntegrationPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("direct2d") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimal.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimal.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "minimal" ] }, "className": "QMinimalIntegrationPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimal.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimald.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimald.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "minimal" ] }, "className": "QMinimalIntegrationPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("minimal") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreen.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreen.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "offscreen" ] }, "className": "QOffscreenIntegrationPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreen.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreend.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreend.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "offscreen" ] }, "className": "QOffscreenIntegrationPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("offscreen") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindows.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindows.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "windows" ] }, "className": "QWindowsIntegrationPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindows.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindowsd.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindowsd.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "windows" ] }, "className": "QWindowsIntegrationPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("windows") QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/simon.platten/Documents/vechicle-training-server-application/build-training-server-application-Desktop_Qt_5_9_2_MSVC2015_32bit-Debug/debug/platforms" ... loaded library "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindowsd.dll" QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platformthemes" ... QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/simon.platten/Documents/vechicle-training-server-application/build-training-server-application-Desktop_Qt_5_9_2_MSVC2015_32bit-Debug/debug/platformthemes" ... QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/styles" ... QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/simon.platten/Documents/vechicle-training-server-application/build-training-server-application-Desktop_Qt_5_9_2_MSVC2015_32bit-Debug/debug/styles" ... Connecting to database... QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers" ... QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlite.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlite.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QSQLITE" ] }, "className": "QSQLiteDriverPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlite.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlited.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlited.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QSQLITE" ] }, "className": "QSQLiteDriverPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("QSQLITE") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysql.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysql.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QMYSQL3", "QMYSQL" ] }, "className": "QMYSQLDriverPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysql.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysqld.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysqld.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QMYSQL3", "QMYSQL" ] }, "className": "QMYSQLDriverPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("QMYSQL3", "QMYSQL") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbc.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbc.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QODBC3", "QODBC" ] }, "className": "QODBCDriverPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbc.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbcd.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbcd.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QODBC3", "QODBC" ] }, "className": "QODBCDriverPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("QODBC3", "QODBC") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsql.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsql.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QPSQL7", "QPSQL" ] }, "className": "QPSQLDriverPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsql.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsqld.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsqld.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QPSQL7", "QPSQL" ] }, "className": "QPSQLDriverPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("QPSQL7", "QPSQL") QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/simon.platten/Documents/vechicle-training-server-application/build-training-server-application-Desktop_Qt_5_9_2_MSVC2015_32bit-Debug/debug/sqldrivers" ... Cannot load library C:\Qt\Qt5.9.2\5.9.2\msvc2015\plugins\sqldrivers\qsqlmysqld.dll: The specified module could not be found. QLibraryPrivate::loadPlugin failed on "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysqld.dll" : "Cannot load library C:\\Qt\\Qt5.9.2\\5.9.2\\msvc2015\\plugins\\sqldrivers\\qsqlmysqld.dll: The specified module could not be found." QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7 -
@KroMignon thank you...again!
This is the output from my application:
Client name - Training Server Initialising application core... QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms" ... QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2d.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2d.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "direct2d" ] }, "className": "QWindowsDirect2DIntegrationPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2d.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2dd.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qdirect2dd.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "direct2d" ] }, "className": "QWindowsDirect2DIntegrationPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("direct2d") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimal.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimal.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "minimal" ] }, "className": "QMinimalIntegrationPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimal.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimald.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qminimald.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "minimal" ] }, "className": "QMinimalIntegrationPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("minimal") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreen.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreen.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "offscreen" ] }, "className": "QOffscreenIntegrationPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreen.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreend.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qoffscreend.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "offscreen" ] }, "className": "QOffscreenIntegrationPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("offscreen") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindows.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindows.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "windows" ] }, "className": "QWindowsIntegrationPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindows.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindowsd.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindowsd.dll, metadata= { "IID": "org.qt-project.Qt.QPA.QPlatformIntegrationFactoryInterface.5.3", "MetaData": { "Keys": [ "windows" ] }, "className": "QWindowsIntegrationPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("windows") QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/simon.platten/Documents/vechicle-training-server-application/build-training-server-application-Desktop_Qt_5_9_2_MSVC2015_32bit-Debug/debug/platforms" ... loaded library "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platforms/qwindowsd.dll" QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/platformthemes" ... QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/simon.platten/Documents/vechicle-training-server-application/build-training-server-application-Desktop_Qt_5_9_2_MSVC2015_32bit-Debug/debug/platformthemes" ... QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/styles" ... QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/simon.platten/Documents/vechicle-training-server-application/build-training-server-application-Desktop_Qt_5_9_2_MSVC2015_32bit-Debug/debug/styles" ... Connecting to database... QFactoryLoader::QFactoryLoader() checking directory path "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers" ... QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlite.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlite.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QSQLITE" ] }, "className": "QSQLiteDriverPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlite.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlited.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlited.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QSQLITE" ] }, "className": "QSQLiteDriverPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("QSQLITE") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysql.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysql.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QMYSQL3", "QMYSQL" ] }, "className": "QMYSQLDriverPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysql.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysqld.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysqld.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QMYSQL3", "QMYSQL" ] }, "className": "QMYSQLDriverPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("QMYSQL3", "QMYSQL") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbc.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbc.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QODBC3", "QODBC" ] }, "className": "QODBCDriverPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbc.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbcd.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlodbcd.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QODBC3", "QODBC" ] }, "className": "QODBCDriverPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("QODBC3", "QODBC") QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsql.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsql.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QPSQL7", "QPSQL" ] }, "className": "QPSQLDriverPlugin", "debug": false, "version": 329986 } "The plugin 'C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsql.dll' uses incompatible Qt library. (Cannot mix debug and release libraries.)" not a plugin QFactoryLoader::QFactoryLoader() looking at "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsqld.dll" Found metadata in lib C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlpsqld.dll, metadata= { "IID": "org.qt-project.Qt.QSqlDriverFactoryInterface", "MetaData": { "Keys": [ "QPSQL7", "QPSQL" ] }, "className": "QPSQLDriverPlugin", "debug": true, "version": 329986 } Got keys from plugin meta data ("QPSQL7", "QPSQL") QFactoryLoader::QFactoryLoader() checking directory path "C:/Users/simon.platten/Documents/vechicle-training-server-application/build-training-server-application-Desktop_Qt_5_9_2_MSVC2015_32bit-Debug/debug/sqldrivers" ... Cannot load library C:\Qt\Qt5.9.2\5.9.2\msvc2015\plugins\sqldrivers\qsqlmysqld.dll: The specified module could not be found. QLibraryPrivate::loadPlugin failed on "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysqld.dll" : "Cannot load library C:\\Qt\\Qt5.9.2\\5.9.2\\msvc2015\\plugins\\sqldrivers\\qsqlmysqld.dll: The specified module could not be found." QSqlDatabase: QMYSQL driver not loaded QSqlDatabase: available drivers: QSQLITE QMYSQL QMYSQL3 QODBC QODBC3 QPSQL QPSQL7wrote on 26 Apr 2021, 13:52 last edited by KroMignon@SPlatten said in Building database driver, IT difficulties:
Cannot load library C:\Qt\Qt5.9.2\5.9.2\msvc2015\plugins\sqldrivers\qsqlmysqld.dll: The specified module could not be found.
QLibraryPrivate::loadPlugin failed on "C:/Qt/Qt5.9.2/5.9.2/msvc2015/plugins/sqldrivers/qsqlmysqld.dll" : "Cannot load library C:\Qt\Qt5.9.2\5.9.2\msvc2015\plugins\sqldrivers\qsqlmysqld.dll: The specified module could not be found."
QSqlDatabase: QMYSQL driver not loaded
It looks like your are running debug version, but did not build plugin for debug, only release build is done.
I think you have to (re)build mysql plugin and add"CONFIG+=debug"to ensure building version of plugin.
Something like:qmake "CONFIG+=debug" -- MYSQL_INCDIR=c:/mysql-connector-6.1.5/include MYSQL_LIBDIR=c:/mysql-connector-6.1.5/lib
19/45