QMYSQL driver not found Qt 6.5.1, I've tried all I found online, without success
-
@JonB @thecodemonkey I really feel so stupid when you talk you obviously know more on this topic than me, please could you explain what I have to do because I am not understanding anything. what should I do now? should I download any other file? I am really sick of this plugin but I need to understand... I know I am boring, I always say the same thing, but it's because I don't understand, it's so difficult..if it is just coding I learn pretty fast, but these things are new to me
@cpplegend you can use different C++ compilers with Qt. On Windows by default these are Microsoft Visual C++ or MinGW. During Installation in Qt maintenance tool you choose if you install the Qt version for MSVC or for MinGW (or both):
.If you are a beginner, I recommend to install only one of them to avoid confusion. In Qt Creator under "Projects" you should be able to see, which Qt version is used for the current project:
depending on that, you need to copy the correct qsqlmysql.dll (plus libmysql.dll):
If it's MSVC2019 then for example copy the files from https://github.com/thecodemonkey86/qt_mysql_driver/files/11768056/qsqlmysql.dll_Qt_SQL_driver_6.5.1_MSVC2019_64-bit.zip,
if MinGW then the files from https://github.com/thecodemonkey86/qt_mysql_driver/files/11768059/qsqlmysql.dll_Qt_SQL_driver_6.5.1_MinGW_11.2.0_64-bit.zip
to sqldrivers folder and application folder respectively
-
@cpplegend you can use different C++ compilers with Qt. On Windows by default these are Microsoft Visual C++ or MinGW. During Installation in Qt maintenance tool you choose if you install the Qt version for MSVC or for MinGW (or both):
.If you are a beginner, I recommend to install only one of them to avoid confusion. In Qt Creator under "Projects" you should be able to see, which Qt version is used for the current project:
depending on that, you need to copy the correct qsqlmysql.dll (plus libmysql.dll):
If it's MSVC2019 then for example copy the files from https://github.com/thecodemonkey86/qt_mysql_driver/files/11768056/qsqlmysql.dll_Qt_SQL_driver_6.5.1_MSVC2019_64-bit.zip,
if MinGW then the files from https://github.com/thecodemonkey86/qt_mysql_driver/files/11768059/qsqlmysql.dll_Qt_SQL_driver_6.5.1_MinGW_11.2.0_64-bit.zip
to sqldrivers folder and application folder respectively
@thecodemonkey sqldrivers from plugin folder in src from qtbase folder, right? and then as you Said the Application folder of the Project I am creating, is it right?
-
@thecodemonkey sqldrivers from plugin folder in src from qtbase folder, right? and then as you Said the Application folder of the Project I am creating, is it right?
@cpplegend by application folder I mean the folder, where the compiler creates the .exe file of your project, like this:
the sqldrivers folder can be either a subdirectory of the application folder (like this:
) ,or in the installation binary folder of Qt. On my system that would be for
MSVC: C:\Qt\6.5.1\msvc2019_64\plugins\sqldrivers (and for MinGW: C:\Qt\6.5.1\mingw_64\plugins\sqldrivers)both options (application folder and installation folder) should work
-
@cpplegend by application folder I mean the folder, where the compiler creates the .exe file of your project, like this:
the sqldrivers folder can be either a subdirectory of the application folder (like this:
) ,or in the installation binary folder of Qt. On my system that would be for
MSVC: C:\Qt\6.5.1\msvc2019_64\plugins\sqldrivers (and for MinGW: C:\Qt\6.5.1\mingw_64\plugins\sqldrivers)both options (application folder and installation folder) should work
@thecodemonkey ok when I return home I will try
-
@cpplegend by application folder I mean the folder, where the compiler creates the .exe file of your project, like this:
the sqldrivers folder can be either a subdirectory of the application folder (like this:
) ,or in the installation binary folder of Qt. On my system that would be for
MSVC: C:\Qt\6.5.1\msvc2019_64\plugins\sqldrivers (and for MinGW: C:\Qt\6.5.1\mingw_64\plugins\sqldrivers)both options (application folder and installation folder) should work
@thecodemonkey now when I include the QSqlDatabase header file these errors occures: :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x3b): undefined reference to
__imp__ZN12QSqlDatabaseD1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x8b): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0xef): undefined reference to__imp__ZN12QSqlDatabaseD1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x14f): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x1a9): undefined reference to__imp__ZN12QSqlDatabaseC1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x1ee): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: collect2.exe: error: ld returned 1 exit status
:-1: error: ninja: build stopped: subcommand failed. -
@thecodemonkey now when I include the QSqlDatabase header file these errors occures: :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x3b): undefined reference to
__imp__ZN12QSqlDatabaseD1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x8b): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0xef): undefined reference to__imp__ZN12QSqlDatabaseD1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x14f): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x1a9): undefined reference to__imp__ZN12QSqlDatabaseC1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x1ee): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: collect2.exe: error: ld returned 1 exit status
:-1: error: ninja: build stopped: subcommand failed.@cpplegend Did you link the Sql module in CMakeLists ?
-
@thecodemonkey now when I include the QSqlDatabase header file these errors occures: :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x3b): undefined reference to
__imp__ZN12QSqlDatabaseD1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x8b): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0xef): undefined reference to__imp__ZN12QSqlDatabaseD1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x14f): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x1a9): undefined reference to__imp__ZN12QSqlDatabaseC1Ev' :-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x1ee): undefined reference to__imp__ZN12QSqlDatabaseD1Ev'
:-1: error: collect2.exe: error: ld returned 1 exit status
:-1: error: ninja: build stopped: subcommand failed.@cpplegend
If I am not mistaken::-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x3b): undefined reference to __imp__ZN12QSqlDatabaseD1Ev'widget.cpp.objindicates this has been compiled with MSVC (MSVC does.objfiles, MinGW does.o) and__imp__ZN12QSqlDatabaseD1Evleading__imp_also indicates MSVC rather than MinGW. [Also if you really have a file namedwidget.cpp.objsomewhere per the error message that is wrong, MSVC should be generatingwidget.objfromwidget.cpp, but that's another matter.]:-1: error: collect2.exe: error: ld returned 1 exit statuscollect2/ldindicates MinGW linker.(Assuming I am right) You really need to sort out whether you are using MSVC or MinGW once and for all, and make it consistent....
-
@cpplegend
If I am not mistaken::-1: error: CMakeFiles/untitled1.dir/widget.cpp.obj:widget.cpp:(.text+0x3b): undefined reference to __imp__ZN12QSqlDatabaseD1Ev'widget.cpp.objindicates this has been compiled with MSVC (MSVC does.objfiles, MinGW does.o) and__imp__ZN12QSqlDatabaseD1Evleading__imp_also indicates MSVC rather than MinGW. [Also if you really have a file namedwidget.cpp.objsomewhere per the error message that is wrong, MSVC should be generatingwidget.objfromwidget.cpp, but that's another matter.]:-1: error: collect2.exe: error: ld returned 1 exit statuscollect2/ldindicates MinGW linker.(Assuming I am right) You really need to sort out whether you are using MSVC or MinGW once and for all, and make it consistent....
-
@JonB I am using mingw, I know that because its the only package I have installed between mingw and msvc
@cpplegend Then what about as @thecodemonkey said?
-
@cpplegend Did you link the Sql module in CMakeLists ?
-
@thecodemonkey @JonB how do I make it?
@cpplegend maybe it gets us further if you post your project here first, incl CMakeLists.txt
