Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. QMYSQL driver not loaded and Library mysql is not defined

QMYSQL driver not loaded and Library mysql is not defined

Scheduled Pinned Locked Moved Solved General and Desktop
qmakeqmysqldriver not loadunknown qmake
44 Posts 6 Posters 9.3k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K KroMignon
    23 Jun 2021, 14:21

    @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

    Does anyone have an idea or some questions about it?

    It is not easy but follow this https://forum.qt.io/post/656068 and it should work

    M Offline
    M Offline
    Markyo
    wrote on 23 Jun 2021, 15:17 last edited by Markyo
    #7

    @KroMignon Yeah sorry I am restricted to a single post every 10 minutes..
    I tried your solution, uninstalled my connector version, installed the C connector v 6.1.5, but I connot find the Qt console you are talking about in your post.

    J K 2 Replies Last reply 23 Jun 2021, 15:24
    0
    • M Markyo
      23 Jun 2021, 15:17

      @KroMignon Yeah sorry I am restricted to a single post every 10 minutes..
      I tried your solution, uninstalled my connector version, installed the C connector v 6.1.5, but I connot find the Qt console you are talking about in your post.

      J Offline
      J Offline
      jsulm
      Lifetime Qt Champion
      wrote on 23 Jun 2021, 15:24 last edited by
      #8

      @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

      but I connot find the Qt console

      Look for Qt entry in Windows start menu

      https://forum.qt.io/topic/113070/qt-code-of-conduct

      1 Reply Last reply
      0
      • J jsulm
        23 Jun 2021, 14:59

        @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

        but what should I do with this path?

        Well, use it?

        C:\Qt\5.12.11\msvc2017\bin\qmake.exe -- MYSQL_INCDIR="C:\Program Files\MySQL\MySQL Server 8.0/include" MYSQL_LIBDIR="C:\Program Files\MySQL\MySQL Server 8.0\lib"
        

        But you also should read what @KroMignon suggested in the thread he linked.

        M Offline
        M Offline
        Markyo
        wrote on 23 Jun 2021, 15:39 last edited by
        #9

        @jsulm Ok sorry I missunderstood the way you were thinking of using absolute path.
        You solution works, but I have another error:
        SQL database drivers - mysql - qmake error

        C 1 Reply Last reply 23 Jun 2021, 15:50
        0
        • M Markyo
          23 Jun 2021, 15:17

          @KroMignon Yeah sorry I am restricted to a single post every 10 minutes..
          I tried your solution, uninstalled my connector version, installed the C connector v 6.1.5, but I connot find the Qt console you are talking about in your post.

          K Offline
          K Offline
          KroMignon
          wrote on 23 Jun 2021, 15:43 last edited by KroMignon
          #10

          @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

          I tried your solution, uninstalled my connector version, installed the C connector v 6.1.5, but I connot find the Qt console you are talking about in your post.

          This entry simply opens a command line window and directly calls qtenv2.bat.
          If you cannot find it, you can do it by hand.
          In you current console, simple execute C:\Qt\5.12.11\msvc2017\bin\qtenv2.bat
          After that, setup MSVC envrionnement, and then you can use qmake.

          It is an old maxim of mine that when you have excluded the impossible, whatever remains, however improbable, must be the truth. (Sherlock Holmes)

          1 Reply Last reply
          0
          • M Markyo
            23 Jun 2021, 15:39

            @jsulm Ok sorry I missunderstood the way you were thinking of using absolute path.
            You solution works, but I have another error:
            SQL database drivers - mysql - qmake error

            C Online
            C Online
            Christian Ehrlicher
            Lifetime Qt Champion
            wrote on 23 Jun 2021, 15:50 last edited by
            #11

            @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

            You solution works, but I have another error:

            Wrong directory. And please post the text, no screenshots.

            Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
            Visit the Qt Academy at https://academy.qt.io/catalog

            M 1 Reply Last reply 24 Jun 2021, 08:48
            0
            • C Christian Ehrlicher
              23 Jun 2021, 15:50

              @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

              You solution works, but I have another error:

              Wrong directory. And please post the text, no screenshots.

              M Offline
              M Offline
              Markyo
              wrote on 24 Jun 2021, 08:48 last edited by
              #12

              @Christian-Ehrlicher oh sorry for screen instead of text..
              I changed the INCDIR AND LIBDIR as followed:

               C:\Qt\5.12.11\msvc2017\bin\qmake.exe -- MYSQL_INCDIR="C:\Program Files\MySQL\MySQL Connector C 6.1\include" MYSQL_LIBDIR="C:\Program Files\MySQL\MySQL Connector C 6.1\lib"
              

              But I still get the same error:

              Cannot read C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/qtsqldrivers-config.pri: No such file or directory
              Project ERROR: Library 'mysql' is not defined.
              

              Did I misunderstood what you called wrong directory?

              1 Reply Last reply
              0
              • C Online
                C Online
                Christian Ehrlicher
                Lifetime Qt Champion
                wrote on 24 Jun 2021, 08:55 last edited by
                #13

                @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                Did I misunderstood what you called wrong directory?

                Yes. You have to call it in the sqldrivers directory as shown in the documentation.

                Qt Online Installer direct download: https://download.qt.io/official_releases/online_installers/
                Visit the Qt Academy at https://academy.qt.io/catalog

                M 1 Reply Last reply 28 Jun 2021, 09:02
                2
                • C Christian Ehrlicher
                  24 Jun 2021, 08:55

                  @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                  Did I misunderstood what you called wrong directory?

                  Yes. You have to call it in the sqldrivers directory as shown in the documentation.

                  M Offline
                  M Offline
                  Markyo
                  wrote on 28 Jun 2021, 09:02 last edited by
                  #14

                  @Christian-Ehrlicher Ok so update!
                  I'm doing this:

                  C:\Qt\5.12.11\msvc2017\bin\qmake.exe -- MYSQL_INCDIR="C:\Program Files\MySQL\MySQL Connector C 6.1\include" MYSQL_LIBDIR="C:\Program Files\MySQL\MySQL Connector C 6.1\lib"
                  

                  get this:

                  Running configuration tests...
                  Done running configuration tests.
                  
                  Configure summary:
                  
                  Qt Sql Drivers:
                    DB2 (IBM) .............................. no
                    InterBase .............................. no
                    MySql .................................. no
                    OCI (Oracle) ........................... no
                    ODBC ................................... no
                    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.12.11\msvc2017'.
                  
                  Prior to reconfiguration, make sure you remove any leftovers from
                  the previous build.
                  

                  Then, I run nmake:

                  "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe"
                  

                  get this:

                  Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  Copyright (C) Microsoft Corporation. Tous droits réservés.
                  
                          cd sqlite\ && ( if not exist Makefile C:\Qt\5.12.11\msvc2017\bin\qmake.exe -o Makefile C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile
                  
                  Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  Copyright (C) Microsoft Corporation. Tous droits réservés.
                  
                          "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile.Release all
                  
                  Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  Copyright (C) Microsoft Corporation. Tous droits réservés.
                  
                          rc /NOLOGO -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -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
                          cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -Zi -MD -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\release\qsqlite.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -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 -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\release -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\release\ @C:\Users\marco\AppData\Local\Temp\nmC4FC.tmp
                  qsql_sqlite.cpp
                  smain.cpp
                  Génération de code en cours...
                          cl -c -nologo -Zc:wchar_t -FS -Zc:strictStrings -O2 -Zi -MD -utf-8 -W3 -w44456 -w44457 -w44458 /Fd.obj\release\qsqlite.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -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 -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\release -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\release\ @C:\Users\marco\AppData\Local\Temp\nmD2C9.tmp
                  sqlite3.c
                          cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -Zi -MD -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\release\qsqlite.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -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 -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\release -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\release\ @C:\Users\marco\AppData\Local\Temp\nm17B.tmp
                  moc_qsql_sqlite_p.cpp
                          link /NOLOGO /DYNAMICBASE /NXCOMPAT /DEBUG /OPT:REF /INCREMENTAL:NO /DLL /SUBSYSTEM:WINDOWS /VERSION:5.12 /OUT:..\plugins\sqldrivers\qsqlite.dll @C:\Users\marco\AppData\Local\Temp\nm499.tmp
                     Création de la bibliothèque ..\plugins\sqldrivers\qsqlite.lib et de l'objet ..\plugins\sqldrivers\qsqlite.exp
                          "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile.Debug all
                  
                  Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  Copyright (C) Microsoft Corporation. Tous droits réservés.
                  
                          cl -BxC:\Qt\5.12.11\msvc2017\bin\qmake.exe -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -Zi -MDd -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 -E C:\Qt\5.12.11\msvc2017\mkspecs\features\data\dummy.cpp 2>NUL >.moc\debug\moc_predefs.h
                          C:\Qt\5.12.11\msvc2017\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/sqlite/.moc/debug/moc_predefs.h -IC:/Qt/5.12.11/msvc2017/mkspecs/win32-msvc -IC:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/sqlite -IC:/Qt/5.12.11/Src/qtbase/src/3rdparty/sqlite -IC:/Qt/5.12.11/msvc2017/include/QtSql/5.12.11 -IC:/Qt/5.12.11/msvc2017/include/QtSql/5.12.11/QtSql -IC:/Qt/5.12.11/msvc2017/include/QtCore/5.12.11 -IC:/Qt/5.12.11/msvc2017/include/QtCore/5.12.11/QtCore -IC:/Qt/5.12.11/msvc2017/include -IC:/Qt/5.12.11/msvc2017/include/QtSql -IC:/Qt/5.12.11/msvc2017/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.16.27023\include" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\winrt" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\cppwinrt" smain.cpp -o .moc\debug\smain.moc
                          C:\Qt\5.12.11\msvc2017\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/sqlite/.moc/debug/moc_predefs.h -IC:/Qt/5.12.11/msvc2017/mkspecs/win32-msvc -IC:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/sqlite -IC:/Qt/5.12.11/Src/qtbase/src/3rdparty/sqlite -IC:/Qt/5.12.11/msvc2017/include/QtSql/5.12.11 -IC:/Qt/5.12.11/msvc2017/include/QtSql/5.12.11/QtSql -IC:/Qt/5.12.11/msvc2017/include/QtCore/5.12.11 -IC:/Qt/5.12.11/msvc2017/include/QtCore/5.12.11/QtCore -IC:/Qt/5.12.11/msvc2017/include -IC:/Qt/5.12.11/msvc2017/include/QtSql -IC:/Qt/5.12.11/msvc2017/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.16.27023\include" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\winrt" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\cppwinrt" qsql_sqlite_p.h -o .moc\debug\moc_qsql_sqlite_p.cpp
                          rc /NOLOGO -D_DEBUG -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -fo .obj\debug\qsqlited_resource.res qsqlited_resource.rc
                          cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -Zi -MDd -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\debug\qsqlited.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\debug -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\debug\ @C:\Users\marco\AppData\Local\Temp\nmFC1.tmp
                  qsql_sqlite.cpp
                  smain.cpp
                  Génération de code en cours...
                          cl -c -nologo -Zc:wchar_t -FS -Zc:strictStrings -Zi -MDd -utf-8 -W3 -w44456 -w44457 -w44458 /Fd.obj\debug\qsqlited.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\debug -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\debug\ @C:\Users\marco\AppData\Local\Temp\nm1938.tmp
                  sqlite3.c
                          cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -Zi -MDd -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\debug\qsqlited.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\debug -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\debug\ @C:\Users\marco\AppData\Local\Temp\nm1E98.tmp
                  moc_qsql_sqlite_p.cpp
                          link /NOLOGO /DYNAMICBASE /NXCOMPAT /DEBUG /DLL /SUBSYSTEM:WINDOWS /VERSION:5.12 /OUT:..\plugins\sqldrivers\qsqlited.dll @C:\Users\marco\AppData\Local\Temp\nm21E5.tmp
                     Création de la bibliothèque ..\plugins\sqldrivers\qsqlited.lib et de l'objet ..\plugins\sqldrivers\qsqlited.exp
                  

                  run the install command:

                  C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers>"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" install
                  

                  get this output:

                  Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  Copyright (C) Microsoft Corporation. Tous droits réservés.
                  
                          cd sqlite\ && ( if not exist Makefile C:\Qt\5.12.11\msvc2017\bin\qmake.exe -o Makefile C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile install
                  
                  Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  Copyright (C) Microsoft Corporation. Tous droits réservés.
                  
                          "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile.Release install
                  
                  Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  Copyright (C) Microsoft Corporation. Tous droits réservés.
                  
                          copy /y ..\plugins\sqldrivers\qsqlite.dll C:\Qt\5.12.11\msvc2017\plugins\sqldrivers\qsqlite.dll
                          1 fichier(s) copié(s).
                          copy /y ..\plugins\sqldrivers\qsqlite.pdb C:\Qt\5.12.11\msvc2017\plugins\sqldrivers\qsqlite.pdb
                          1 fichier(s) copié(s).
                          C:\Qt\5.12.11\msvc2017\bin\qmake.exe -install qinstall C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake C:\Qt\5.12.11\msvc2017\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake
                          "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile.Debug install
                  
                  Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  Copyright (C) Microsoft Corporation. Tous droits réservés.
                  
                          copy /y ..\plugins\sqldrivers\qsqlited.dll C:\Qt\5.12.11\msvc2017\plugins\sqldrivers\qsqlited.dll
                          1 fichier(s) copié(s).
                          copy /y ..\plugins\sqldrivers\qsqlited.pdb C:\Qt\5.12.11\msvc2017\plugins\sqldrivers\qsqlited.pdb
                          1 fichier(s) copié(s).
                          C:\Qt\5.12.11\msvc2017\bin\qmake.exe -install qinstall C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake C:\Qt\5.12.11\msvc2017\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake
                  

                  I checked the config.log, as said in the doc, and lines talking about mysql are:

                  looking for library mysql
                  Trying source 0 (type mysqlConfig) of library mysql ...
                  mysql_config not found.
                    => source produced no result.
                  Trying source 1 (type mysqlConfig) of library mysql ...
                  mysql_config not found.
                    => source produced no result.
                  Trying source 2 (type mysqlConfig) of library mysql ...
                  mysql_config not found.
                    => source produced no result.
                  Trying source 3 (type mysqlConfig) of library mysql ...
                  mysql_config not found.
                    => source produced no result.
                  Trying source 4 (type inline) of library mysql ...
                    => source failed condition '!config.win32'.
                  Trying source 5 (type inline) of library mysql ...
                  + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Qt\5.12.11\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.6.11-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.6.11-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"C:\\Program Files\\MySQL\\MySQL Connector C 6.1\\lib/libmysql.lib\"" "QMAKE_INCDIR_MYSQL = \"C:\\Program Files\\MySQL\\MySQL Connector C 6.1\\include\"" C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
                  > Info: creating stash file C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\.qmake.stash
                  + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& nmake
                  > Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                  > Copyright (C) Microsoft Corporation. Tous droits réservés.
                  > 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -I"C:\Program Files\MySQL\MySQL Connector C 6.1\include" -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\marco\AppData\Local\Temp\nmAFE1.tmp
                  > main.cpp
                  > 	link /NOLOGO /DYNAMICBASE /NXCOMPAT /INCREMENTAL:NO /SUBSYSTEM:CONSOLE "/MANIFESTDEPENDENCY:type='win32' name='Microsoft.Windows.Common-Controls' version='6.0.0.0' publicKeyToken='6595b64144ccf1df' language='*' processorArchitecture='*'" /MANIFEST:embed /OUT:mysql.exe @C:\Users\marco\AppData\Local\Temp\nmB1C6.tmp
                  > main.obj : error LNK2019: symbole externe non r‚solu _mysql_get_client_version@0 r‚f‚renc‚ dans la fonction _main
                  > C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.lib : warning LNK4272: type d'ordinateur bibliothÅ que 'x64' en conflit avec le type d'ordinateur cible 'x86'
                  > mysql.exe : fatal error LNK1120: 1 externes non r‚solus
                  > NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\HostX86\x86\link.EXE"' : code retour '0x460'
                  > Stop.
                   => source failed verification.
                  Trying source 6 (type inline) of library mysql ...
                    => source failed condition '!config.win32'.
                  test config.sqldrivers.libraries.mysql FAILED
                  

                  I tried to delete config.cache as said in doc, but same results..

                  And of course, while trying to run my app:

                  QML debugging is enabled. Only use this in a safe environment.
                  QSqlDatabase: QMYSQL driver not loaded
                  QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7
                  

                  Honnestly I'm kinda lost in technical informations..

                  J 1 Reply Last reply 28 Jun 2021, 09:04
                  0
                  • M Markyo
                    28 Jun 2021, 09:02

                    @Christian-Ehrlicher Ok so update!
                    I'm doing this:

                    C:\Qt\5.12.11\msvc2017\bin\qmake.exe -- MYSQL_INCDIR="C:\Program Files\MySQL\MySQL Connector C 6.1\include" MYSQL_LIBDIR="C:\Program Files\MySQL\MySQL Connector C 6.1\lib"
                    

                    get this:

                    Running configuration tests...
                    Done running configuration tests.
                    
                    Configure summary:
                    
                    Qt Sql Drivers:
                      DB2 (IBM) .............................. no
                      InterBase .............................. no
                      MySql .................................. no
                      OCI (Oracle) ........................... no
                      ODBC ................................... no
                      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.12.11\msvc2017'.
                    
                    Prior to reconfiguration, make sure you remove any leftovers from
                    the previous build.
                    

                    Then, I run nmake:

                    "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe"
                    

                    get this:

                    Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    Copyright (C) Microsoft Corporation. Tous droits réservés.
                    
                            cd sqlite\ && ( if not exist Makefile C:\Qt\5.12.11\msvc2017\bin\qmake.exe -o Makefile C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile
                    
                    Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    Copyright (C) Microsoft Corporation. Tous droits réservés.
                    
                            "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile.Release all
                    
                    Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    Copyright (C) Microsoft Corporation. Tous droits réservés.
                    
                            rc /NOLOGO -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -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
                            cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -Zi -MD -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\release\qsqlite.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -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 -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\release -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\release\ @C:\Users\marco\AppData\Local\Temp\nmC4FC.tmp
                    qsql_sqlite.cpp
                    smain.cpp
                    Génération de code en cours...
                            cl -c -nologo -Zc:wchar_t -FS -Zc:strictStrings -O2 -Zi -MD -utf-8 -W3 -w44456 -w44457 -w44458 /Fd.obj\release\qsqlite.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -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 -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\release -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\release\ @C:\Users\marco\AppData\Local\Temp\nmD2C9.tmp
                    sqlite3.c
                            cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -Zi -MD -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\release\qsqlite.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -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 -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\release -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\release\ @C:\Users\marco\AppData\Local\Temp\nm17B.tmp
                    moc_qsql_sqlite_p.cpp
                            link /NOLOGO /DYNAMICBASE /NXCOMPAT /DEBUG /OPT:REF /INCREMENTAL:NO /DLL /SUBSYSTEM:WINDOWS /VERSION:5.12 /OUT:..\plugins\sqldrivers\qsqlite.dll @C:\Users\marco\AppData\Local\Temp\nm499.tmp
                       Création de la bibliothèque ..\plugins\sqldrivers\qsqlite.lib et de l'objet ..\plugins\sqldrivers\qsqlite.exp
                            "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile.Debug all
                    
                    Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    Copyright (C) Microsoft Corporation. Tous droits réservés.
                    
                            cl -BxC:\Qt\5.12.11\msvc2017\bin\qmake.exe -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -Zi -MDd -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 -E C:\Qt\5.12.11\msvc2017\mkspecs\features\data\dummy.cpp 2>NUL >.moc\debug\moc_predefs.h
                            C:\Qt\5.12.11\msvc2017\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/sqlite/.moc/debug/moc_predefs.h -IC:/Qt/5.12.11/msvc2017/mkspecs/win32-msvc -IC:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/sqlite -IC:/Qt/5.12.11/Src/qtbase/src/3rdparty/sqlite -IC:/Qt/5.12.11/msvc2017/include/QtSql/5.12.11 -IC:/Qt/5.12.11/msvc2017/include/QtSql/5.12.11/QtSql -IC:/Qt/5.12.11/msvc2017/include/QtCore/5.12.11 -IC:/Qt/5.12.11/msvc2017/include/QtCore/5.12.11/QtCore -IC:/Qt/5.12.11/msvc2017/include -IC:/Qt/5.12.11/msvc2017/include/QtSql -IC:/Qt/5.12.11/msvc2017/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.16.27023\include" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\winrt" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\cppwinrt" smain.cpp -o .moc\debug\smain.moc
                            C:\Qt\5.12.11\msvc2017\bin\moc.exe -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL --compiler-flavor=msvc --include C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/sqlite/.moc/debug/moc_predefs.h -IC:/Qt/5.12.11/msvc2017/mkspecs/win32-msvc -IC:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/sqlite -IC:/Qt/5.12.11/Src/qtbase/src/3rdparty/sqlite -IC:/Qt/5.12.11/msvc2017/include/QtSql/5.12.11 -IC:/Qt/5.12.11/msvc2017/include/QtSql/5.12.11/QtSql -IC:/Qt/5.12.11/msvc2017/include/QtCore/5.12.11 -IC:/Qt/5.12.11/msvc2017/include/QtCore/5.12.11/QtCore -IC:/Qt/5.12.11/msvc2017/include -IC:/Qt/5.12.11/msvc2017/include/QtSql -IC:/Qt/5.12.11/msvc2017/include/QtCore -I"C:\Program Files (x86)\Microsoft Visual Studio\2017\BuildTools\VC\Tools\MSVC\14.16.27023\include" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\ucrt" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\shared" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\um" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\winrt" -I"C:\Program Files (x86)\Windows Kits\10\include\10.0.18362.0\cppwinrt" qsql_sqlite_p.h -o .moc\debug\moc_qsql_sqlite_p.cpp
                            rc /NOLOGO -D_DEBUG -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -fo .obj\debug\qsqlited_resource.res qsqlited_resource.rc
                            cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -Zi -MDd -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\debug\qsqlited.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\debug -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\debug\ @C:\Users\marco\AppData\Local\Temp\nmFC1.tmp
                    qsql_sqlite.cpp
                    smain.cpp
                    Génération de code en cours...
                            cl -c -nologo -Zc:wchar_t -FS -Zc:strictStrings -Zi -MDd -utf-8 -W3 -w44456 -w44457 -w44458 /Fd.obj\debug\qsqlited.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\debug -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\debug\ @C:\Users\marco\AppData\Local\Temp\nm1938.tmp
                    sqlite3.c
                            cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -Zi -MDd -std:c++17 -utf-8 /wd4530 /wd4577 -W3 -w34100 -w34189 -w44996 -w44456 -w44457 -w44458 -wd4577 -wd4467 /Fd.obj\debug\qsqlited.vc.pdb -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DSQLITE_ENABLE_COLUMN_METADATA -DSQLITE_OMIT_LOAD_EXTENSION -DSQLITE_OMIT_COMPLETE -DSQLITE_ENABLE_FTS3 -DSQLITE_ENABLE_FTS3_PARENTHESIS -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_RTREE -DQT_DEPRECATED_WARNINGS -DQT_NO_NARROWING_CONVERSIONS_IN_CONNECT -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCEPTIONS -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -D_WINDLL -I. -IC:\Qt\5.12.11\Src\qtbase\src\3rdparty\sqlite -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtSql\5.12.11\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11 -IC:\Qt\5.12.11\msvc2017\include\QtCore\5.12.11\QtCore -IC:\Qt\5.12.11\msvc2017\include -IC:\Qt\5.12.11\msvc2017\include\QtSql -IC:\Qt\5.12.11\msvc2017\include\QtCore -I.moc\debug -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo.obj\debug\ @C:\Users\marco\AppData\Local\Temp\nm1E98.tmp
                    moc_qsql_sqlite_p.cpp
                            link /NOLOGO /DYNAMICBASE /NXCOMPAT /DEBUG /DLL /SUBSYSTEM:WINDOWS /VERSION:5.12 /OUT:..\plugins\sqldrivers\qsqlited.dll @C:\Users\marco\AppData\Local\Temp\nm21E5.tmp
                       Création de la bibliothèque ..\plugins\sqldrivers\qsqlited.lib et de l'objet ..\plugins\sqldrivers\qsqlited.exp
                    

                    run the install command:

                    C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers>"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" install
                    

                    get this output:

                    Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    Copyright (C) Microsoft Corporation. Tous droits réservés.
                    
                            cd sqlite\ && ( if not exist Makefile C:\Qt\5.12.11\msvc2017\bin\qmake.exe -o Makefile C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\sqlite\sqlite.pro ) && "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile install
                    
                    Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    Copyright (C) Microsoft Corporation. Tous droits réservés.
                    
                            "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile.Release install
                    
                    Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    Copyright (C) Microsoft Corporation. Tous droits réservés.
                    
                            copy /y ..\plugins\sqldrivers\qsqlite.dll C:\Qt\5.12.11\msvc2017\plugins\sqldrivers\qsqlite.dll
                            1 fichier(s) copié(s).
                            copy /y ..\plugins\sqldrivers\qsqlite.pdb C:\Qt\5.12.11\msvc2017\plugins\sqldrivers\qsqlite.pdb
                            1 fichier(s) copié(s).
                            C:\Qt\5.12.11\msvc2017\bin\qmake.exe -install qinstall C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake C:\Qt\5.12.11\msvc2017\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake
                            "C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\Hostx64\x86\nmake.exe" -f Makefile.Debug install
                    
                    Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    Copyright (C) Microsoft Corporation. Tous droits réservés.
                    
                            copy /y ..\plugins\sqldrivers\qsqlited.dll C:\Qt\5.12.11\msvc2017\plugins\sqldrivers\qsqlited.dll
                            1 fichier(s) copié(s).
                            copy /y ..\plugins\sqldrivers\qsqlited.pdb C:\Qt\5.12.11\msvc2017\plugins\sqldrivers\qsqlited.pdb
                            1 fichier(s) copié(s).
                            C:\Qt\5.12.11\msvc2017\bin\qmake.exe -install qinstall C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake C:\Qt\5.12.11\msvc2017\lib\cmake\Qt5Sql\Qt5Sql_QSQLiteDriverPlugin.cmake
                    

                    I checked the config.log, as said in the doc, and lines talking about mysql are:

                    looking for library mysql
                    Trying source 0 (type mysqlConfig) of library mysql ...
                    mysql_config not found.
                      => source produced no result.
                    Trying source 1 (type mysqlConfig) of library mysql ...
                    mysql_config not found.
                      => source produced no result.
                    Trying source 2 (type mysqlConfig) of library mysql ...
                    mysql_config not found.
                      => source produced no result.
                    Trying source 3 (type mysqlConfig) of library mysql ...
                    mysql_config not found.
                      => source produced no result.
                    Trying source 4 (type inline) of library mysql ...
                      => source failed condition '!config.win32'.
                    Trying source 5 (type inline) of library mysql ...
                    + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Qt\5.12.11\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.6.11-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.6.11-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"C:\\Program Files\\MySQL\\MySQL Connector C 6.1\\lib/libmysql.lib\"" "QMAKE_INCDIR_MYSQL = \"C:\\Program Files\\MySQL\\MySQL Connector C 6.1\\include\"" C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
                    > Info: creating stash file C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\.qmake.stash
                    + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& nmake
                    > Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                    > Copyright (C) Microsoft Corporation. Tous droits réservés.
                    > 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -I"C:\Program Files\MySQL\MySQL Connector C 6.1\include" -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\marco\AppData\Local\Temp\nmAFE1.tmp
                    > main.cpp
                    > 	link /NOLOGO /DYNAMICBASE /NXCOMPAT /INCREMENTAL:NO /SUBSYSTEM:CONSOLE "/MANIFESTDEPENDENCY:type='win32' name='Microsoft.Windows.Common-Controls' version='6.0.0.0' publicKeyToken='6595b64144ccf1df' language='*' processorArchitecture='*'" /MANIFEST:embed /OUT:mysql.exe @C:\Users\marco\AppData\Local\Temp\nmB1C6.tmp
                    > main.obj : error LNK2019: symbole externe non r‚solu _mysql_get_client_version@0 r‚f‚renc‚ dans la fonction _main
                    > C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.lib : warning LNK4272: type d'ordinateur bibliothÅ que 'x64' en conflit avec le type d'ordinateur cible 'x86'
                    > mysql.exe : fatal error LNK1120: 1 externes non r‚solus
                    > NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\HostX86\x86\link.EXE"' : code retour '0x460'
                    > Stop.
                     => source failed verification.
                    Trying source 6 (type inline) of library mysql ...
                      => source failed condition '!config.win32'.
                    test config.sqldrivers.libraries.mysql FAILED
                    

                    I tried to delete config.cache as said in doc, but same results..

                    And of course, while trying to run my app:

                    QML debugging is enabled. Only use this in a safe environment.
                    QSqlDatabase: QMYSQL driver not loaded
                    QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7
                    

                    Honnestly I'm kinda lost in technical informations..

                    J Offline
                    J Offline
                    jsulm
                    Lifetime Qt Champion
                    wrote on 28 Jun 2021, 09:04 last edited by
                    #15

                    @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                    MySql .................................. no

                    As you can see MySql was disabled.
                    Check the config.log file to see why.

                    https://forum.qt.io/topic/113070/qt-code-of-conduct

                    M 1 Reply Last reply 28 Jun 2021, 09:17
                    0
                    • J jsulm
                      28 Jun 2021, 09:04

                      @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                      MySql .................................. no

                      As you can see MySql was disabled.
                      Check the config.log file to see why.

                      M Offline
                      M Offline
                      Markyo
                      wrote on 28 Jun 2021, 09:17 last edited by
                      #16

                      @jsulm I thought it was the already installed ones.
                      I've put the part about mysql from the config.log in my previous message, but I will link the whole file bellow.

                      Command line: "MYSQL_INCDIR=C:\Program Files\MySQL\MySQL Connector C 6.1\include" "MYSQL_LIBDIR=C:\Program Files\MySQL\MySQL Connector C 6.1\lib"
                      Global lib dirs: [C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.6.11-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib] ["C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\BuildTools\\VC\\Tools\\MSVC\\14.16.27023\\lib\\x64" "C:\\Program Files (x86)\\Windows Kits\\10\\lib\\10.0.18362.0\\ucrt\\x64" "C:\\Program Files (x86)\\Windows Kits\\10\\lib\\10.0.18362.0\\um\\x64"]
                      Global inc dirs: [C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.6.11-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include] ["C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\BuildTools\\VC\\Tools\\MSVC\\14.16.27023\\include" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\ucrt" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\shared" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\um" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\winrt" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\cppwinrt"]
                      looking for library db2
                      Trying source 0 (type inline) of library db2 ...
                      None of [db2cli.lib] found in [] and global paths.
                        => source produced no result.
                      Trying source 1 (type inline) of library db2 ...
                        => source failed condition '!config.win32'.
                      test config.sqldrivers.libraries.db2 FAILED
                      looking for library ibase
                      Trying source 0 (type inline) of library ibase ...
                      None of [gds32_ms.lib] found in [] and global paths.
                        => source produced no result.
                      Trying source 1 (type inline) of library ibase ...
                        => source failed condition '!config.win32'.
                      test config.sqldrivers.libraries.ibase FAILED
                      looking for library mysql
                      Trying source 0 (type mysqlConfig) of library mysql ...
                      mysql_config not found.
                        => source produced no result.
                      Trying source 1 (type mysqlConfig) of library mysql ...
                      mysql_config not found.
                        => source produced no result.
                      Trying source 2 (type mysqlConfig) of library mysql ...
                      mysql_config not found.
                        => source produced no result.
                      Trying source 3 (type mysqlConfig) of library mysql ...
                      mysql_config not found.
                        => source produced no result.
                      Trying source 4 (type inline) of library mysql ...
                        => source failed condition '!config.win32'.
                      Trying source 5 (type inline) of library mysql ...
                      + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Qt\5.12.11\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.6.11-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.6.11-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"C:\\Program Files\\MySQL\\MySQL Connector C 6.1\\lib/libmysql.lib\"" "QMAKE_INCDIR_MYSQL = \"C:\\Program Files\\MySQL\\MySQL Connector C 6.1\\include\"" C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
                      > Info: creating stash file C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\.qmake.stash
                      + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& nmake
                      > Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                      > Copyright (C) Microsoft Corporation. Tous droits réservés.
                      > 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -I"C:\Program Files\MySQL\MySQL Connector C 6.1\include" -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\marco\AppData\Local\Temp\nmAFE1.tmp
                      > main.cpp
                      > 	link /NOLOGO /DYNAMICBASE /NXCOMPAT /INCREMENTAL:NO /SUBSYSTEM:CONSOLE "/MANIFESTDEPENDENCY:type='win32' name='Microsoft.Windows.Common-Controls' version='6.0.0.0' publicKeyToken='6595b64144ccf1df' language='*' processorArchitecture='*'" /MANIFEST:embed /OUT:mysql.exe @C:\Users\marco\AppData\Local\Temp\nmB1C6.tmp
                      > main.obj : error LNK2019: symbole externe non r‚solu _mysql_get_client_version@0 r‚f‚renc‚ dans la fonction _main
                      > C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.lib : warning LNK4272: type d'ordinateur bibliothÅ que 'x64' en conflit avec le type d'ordinateur cible 'x86'
                      > mysql.exe : fatal error LNK1120: 1 externes non r‚solus
                      > NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\HostX86\x86\link.EXE"' : code retour '0x460'
                      > Stop.
                       => source failed verification.
                      Trying source 6 (type inline) of library mysql ...
                        => source failed condition '!config.win32'.
                      test config.sqldrivers.libraries.mysql FAILED
                      looking for library oci
                      Trying source 0 (type inline) of library oci ...
                      None of [oci.lib] found in [] and global paths.
                        => source produced no result.
                      Trying source 1 (type inline) of library oci ...
                        => source failed condition '!config.win32'.
                      test config.sqldrivers.libraries.oci FAILED
                      looking for library odbc
                      Trying source 0 (type inline) of library odbc ...
                      + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && C:\Qt\5.12.11\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.6.11-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.6.11-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = \"C:\\Program Files ^(x86^)\\Windows Kits\\10\\lib\\10.0.18362.0\\um\\x64/odbc32.lib\"" C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
                      + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& nmake
                      > Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                      > Copyright (C) Microsoft Corporation. Tous droits réservés.
                      > 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\marco\AppData\Local\Temp\nmB33C.tmp
                      > main.cpp
                      > 	link /NOLOGO /DYNAMICBASE /NXCOMPAT /INCREMENTAL:NO /SUBSYSTEM:CONSOLE "/MANIFESTDEPENDENCY:type='win32' name='Microsoft.Windows.Common-Controls' version='6.0.0.0' publicKeyToken='6595b64144ccf1df' language='*' processorArchitecture='*'" /MANIFEST:embed /OUT:odbc.exe @C:\Users\marco\AppData\Local\Temp\nmB502.tmp
                      > main.obj : error LNK2019: symbole externe non r‚solu _SQLAllocHandle@12 r‚f‚renc‚ dans la fonction _main
                      > C:\Program Files (x86)\Windows Kits\10\lib\10.0.18362.0\um\x64\odbc32.lib : warning LNK4272: type d'ordinateur bibliothÅ que 'x64' en conflit avec le type d'ordinateur cible 'x86'
                      > odbc.exe : fatal error LNK1120: 1 externes non r‚solus
                      > NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\HostX86\x86\link.EXE"' : code retour '0x460'
                      > Stop.
                       => source failed verification.
                      Trying source 1 (type inline) of library odbc ...
                        => source failed condition 'config.darwin'.
                      Trying source 2 (type inline) of library odbc ...
                        => source failed condition '!config.win32 && !config.darwin'.
                      test config.sqldrivers.libraries.odbc FAILED
                      looking for library psql
                      Trying source 0 (type pkgConfig) of library psql ...
                      pkg-config use disabled globally.
                        => source produced no result.
                      Trying source 1 (type psqlConfig) of library psql ...
                      pg_config not found.
                        => source produced no result.
                      Trying source 2 (type psqlEnv) of library psql ...
                      None of [libpq.lib] found in [] and global paths.
                        => source produced no result.
                      Trying source 3 (type psqlEnv) of library psql ...
                        => source failed condition '!config.win32'.
                      test config.sqldrivers.libraries.psql FAILED
                      looking for library sqlite2
                      Trying source 0 (type inline) of library sqlite2 ...
                      None of [sqlite.lib] found in [] and global paths.
                        => source produced no result.
                      test config.sqldrivers.libraries.sqlite2 FAILED
                      looking for library tds
                      Trying source 0 (type sybaseEnv) of library tds ...
                      None of [NTWDBLIB.lib] found in [] and global paths.
                        => source produced no result.
                      Trying source 1 (type sybaseEnv) of library tds ...
                        => source failed condition '!config.win32'.
                      test config.sqldrivers.libraries.tds FAILED
                      
                      

                      I don't really understand all of this.

                      J 1 Reply Last reply 28 Jun 2021, 09:19
                      0
                      • M Markyo
                        28 Jun 2021, 09:17

                        @jsulm I thought it was the already installed ones.
                        I've put the part about mysql from the config.log in my previous message, but I will link the whole file bellow.

                        Command line: "MYSQL_INCDIR=C:\Program Files\MySQL\MySQL Connector C 6.1\include" "MYSQL_LIBDIR=C:\Program Files\MySQL\MySQL Connector C 6.1\lib"
                        Global lib dirs: [C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.6.11-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib] ["C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\BuildTools\\VC\\Tools\\MSVC\\14.16.27023\\lib\\x64" "C:\\Program Files (x86)\\Windows Kits\\10\\lib\\10.0.18362.0\\ucrt\\x64" "C:\\Program Files (x86)\\Windows Kits\\10\\lib\\10.0.18362.0\\um\\x64"]
                        Global inc dirs: [C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.6.11-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include] ["C:\\Program Files (x86)\\Microsoft Visual Studio\\2017\\BuildTools\\VC\\Tools\\MSVC\\14.16.27023\\include" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\ucrt" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\shared" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\um" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\winrt" "C:\\Program Files (x86)\\Windows Kits\\10\\include\\10.0.18362.0\\cppwinrt"]
                        looking for library db2
                        Trying source 0 (type inline) of library db2 ...
                        None of [db2cli.lib] found in [] and global paths.
                          => source produced no result.
                        Trying source 1 (type inline) of library db2 ...
                          => source failed condition '!config.win32'.
                        test config.sqldrivers.libraries.db2 FAILED
                        looking for library ibase
                        Trying source 0 (type inline) of library ibase ...
                        None of [gds32_ms.lib] found in [] and global paths.
                          => source produced no result.
                        Trying source 1 (type inline) of library ibase ...
                          => source failed condition '!config.win32'.
                        test config.sqldrivers.libraries.ibase FAILED
                        looking for library mysql
                        Trying source 0 (type mysqlConfig) of library mysql ...
                        mysql_config not found.
                          => source produced no result.
                        Trying source 1 (type mysqlConfig) of library mysql ...
                        mysql_config not found.
                          => source produced no result.
                        Trying source 2 (type mysqlConfig) of library mysql ...
                        mysql_config not found.
                          => source produced no result.
                        Trying source 3 (type mysqlConfig) of library mysql ...
                        mysql_config not found.
                          => source produced no result.
                        Trying source 4 (type inline) of library mysql ...
                          => source failed condition '!config.win32'.
                        Trying source 5 (type inline) of library mysql ...
                        + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && C:\Qt\5.12.11\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.6.11-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.6.11-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = \"C:\\Program Files\\MySQL\\MySQL Connector C 6.1\\lib/libmysql.lib\"" "QMAKE_INCDIR_MYSQL = \"C:\\Program Files\\MySQL\\MySQL Connector C 6.1\\include\"" C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
                        > Info: creating stash file C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\.qmake.stash
                        + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& nmake
                        > Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                        > Copyright (C) Microsoft Corporation. Tous droits réservés.
                        > 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -I"C:\Program Files\MySQL\MySQL Connector C 6.1\include" -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\marco\AppData\Local\Temp\nmAFE1.tmp
                        > main.cpp
                        > 	link /NOLOGO /DYNAMICBASE /NXCOMPAT /INCREMENTAL:NO /SUBSYSTEM:CONSOLE "/MANIFESTDEPENDENCY:type='win32' name='Microsoft.Windows.Common-Controls' version='6.0.0.0' publicKeyToken='6595b64144ccf1df' language='*' processorArchitecture='*'" /MANIFEST:embed /OUT:mysql.exe @C:\Users\marco\AppData\Local\Temp\nmB1C6.tmp
                        > main.obj : error LNK2019: symbole externe non r‚solu _mysql_get_client_version@0 r‚f‚renc‚ dans la fonction _main
                        > C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.lib : warning LNK4272: type d'ordinateur bibliothÅ que 'x64' en conflit avec le type d'ordinateur cible 'x86'
                        > mysql.exe : fatal error LNK1120: 1 externes non r‚solus
                        > NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\HostX86\x86\link.EXE"' : code retour '0x460'
                        > Stop.
                         => source failed verification.
                        Trying source 6 (type inline) of library mysql ...
                          => source failed condition '!config.win32'.
                        test config.sqldrivers.libraries.mysql FAILED
                        looking for library oci
                        Trying source 0 (type inline) of library oci ...
                        None of [oci.lib] found in [] and global paths.
                          => source produced no result.
                        Trying source 1 (type inline) of library oci ...
                          => source failed condition '!config.win32'.
                        test config.sqldrivers.libraries.oci FAILED
                        looking for library odbc
                        Trying source 0 (type inline) of library odbc ...
                        + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && C:\Qt\5.12.11\msvc2017\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\\opensslx86\\lib C:\\Utils\\my_sql\\mysql-5.6.11-win32\\lib C:\\Utils\\postgresqlx86\\pgsql\\lib" "INCLUDEPATH += C:\\opensslx86\\include C:\\Utils\\my_sql\\mysql-5.6.11-win32\\include C:\\Utils\\postgresqlx86\\pgsql\\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = \"C:\\Program Files ^(x86^)\\Windows Kits\\10\\lib\\10.0.18362.0\\um\\x64/odbc32.lib\"" C:/Qt/5.12.11/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
                        + cd /d C:\Qt\5.12.11\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& nmake
                        > Microsoft (R) Program Maintenance Utility Version 14.26.28806.0
                        > Copyright (C) Microsoft Corporation. Tous droits réservés.
                        > 	cl -c -nologo -Zc:wchar_t -FS -Zc:rvalueCast -Zc:inline -Zc:strictStrings -Zc:throwingNew -Zc:referenceBinding -Zc:__cplusplus -O2 -MD -W0 -EHsc -DUNICODE -D_UNICODE -DWIN32 -D_ENABLE_EXTENDED_ALIGNED_STORAGE -DNDEBUG -I. -IC:\opensslx86\include -IC:\Utils\my_sql\mysql-5.6.11-win32\include -IC:\Utils\postgresqlx86\pgsql\include -IC:\Qt\5.12.11\msvc2017\mkspecs\win32-msvc -Fo @C:\Users\marco\AppData\Local\Temp\nmB33C.tmp
                        > main.cpp
                        > 	link /NOLOGO /DYNAMICBASE /NXCOMPAT /INCREMENTAL:NO /SUBSYSTEM:CONSOLE "/MANIFESTDEPENDENCY:type='win32' name='Microsoft.Windows.Common-Controls' version='6.0.0.0' publicKeyToken='6595b64144ccf1df' language='*' processorArchitecture='*'" /MANIFEST:embed /OUT:odbc.exe @C:\Users\marco\AppData\Local\Temp\nmB502.tmp
                        > main.obj : error LNK2019: symbole externe non r‚solu _SQLAllocHandle@12 r‚f‚renc‚ dans la fonction _main
                        > C:\Program Files (x86)\Windows Kits\10\lib\10.0.18362.0\um\x64\odbc32.lib : warning LNK4272: type d'ordinateur bibliothÅ que 'x64' en conflit avec le type d'ordinateur cible 'x86'
                        > odbc.exe : fatal error LNK1120: 1 externes non r‚solus
                        > NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\VC\Tools\MSVC\14.26.28801\bin\HostX86\x86\link.EXE"' : code retour '0x460'
                        > Stop.
                         => source failed verification.
                        Trying source 1 (type inline) of library odbc ...
                          => source failed condition 'config.darwin'.
                        Trying source 2 (type inline) of library odbc ...
                          => source failed condition '!config.win32 && !config.darwin'.
                        test config.sqldrivers.libraries.odbc FAILED
                        looking for library psql
                        Trying source 0 (type pkgConfig) of library psql ...
                        pkg-config use disabled globally.
                          => source produced no result.
                        Trying source 1 (type psqlConfig) of library psql ...
                        pg_config not found.
                          => source produced no result.
                        Trying source 2 (type psqlEnv) of library psql ...
                        None of [libpq.lib] found in [] and global paths.
                          => source produced no result.
                        Trying source 3 (type psqlEnv) of library psql ...
                          => source failed condition '!config.win32'.
                        test config.sqldrivers.libraries.psql FAILED
                        looking for library sqlite2
                        Trying source 0 (type inline) of library sqlite2 ...
                        None of [sqlite.lib] found in [] and global paths.
                          => source produced no result.
                        test config.sqldrivers.libraries.sqlite2 FAILED
                        looking for library tds
                        Trying source 0 (type sybaseEnv) of library tds ...
                        None of [NTWDBLIB.lib] found in [] and global paths.
                          => source produced no result.
                        Trying source 1 (type sybaseEnv) of library tds ...
                          => source failed condition '!config.win32'.
                        test config.sqldrivers.libraries.tds FAILED
                        
                        

                        I don't really understand all of this.

                        J Offline
                        J Offline
                        jsulm
                        Lifetime Qt Champion
                        wrote on 28 Jun 2021, 09:19 last edited by
                        #17

                        @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                        C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.lib : warning LNK4272: type d'ordinateur bibliothÅ que 'x64' en conflit avec le type d'ordinateur cible 'x86'

                        This is the problem: your Qt and MySql lib are for different architectures.

                        https://forum.qt.io/topic/113070/qt-code-of-conduct

                        M 1 Reply Last reply 28 Jun 2021, 09:27
                        1
                        • J jsulm
                          28 Jun 2021, 09:19

                          @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                          C:\Program Files\MySQL\MySQL Connector C 6.1\lib\libmysql.lib : warning LNK4272: type d'ordinateur bibliothÅ que 'x64' en conflit avec le type d'ordinateur cible 'x86'

                          This is the problem: your Qt and MySql lib are for different architectures.

                          M Offline
                          M Offline
                          Markyo
                          wrote on 28 Jun 2021, 09:27 last edited by
                          #18

                          @jsulm x64 vs x86?
                          Is there a way to solve this? Installing both in the same architectures? Wich one should I choose?

                          J 1 Reply Last reply 28 Jun 2021, 09:28
                          0
                          • M Markyo
                            28 Jun 2021, 09:27

                            @jsulm x64 vs x86?
                            Is there a way to solve this? Installing both in the same architectures? Wich one should I choose?

                            J Offline
                            J Offline
                            jsulm
                            Lifetime Qt Champion
                            wrote on 28 Jun 2021, 09:28 last edited by
                            #19

                            @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                            Wich one should I choose?

                            The one you need.
                            It looks like you installed Qt x86, right? Install Qt x86_64 and use that one.

                            https://forum.qt.io/topic/113070/qt-code-of-conduct

                            M 1 Reply Last reply 28 Jun 2021, 09:47
                            0
                            • J jsulm
                              28 Jun 2021, 09:28

                              @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                              Wich one should I choose?

                              The one you need.
                              It looks like you installed Qt x86, right? Install Qt x86_64 and use that one.

                              M Offline
                              M Offline
                              Markyo
                              wrote on 28 Jun 2021, 09:47 last edited by
                              #20

                              @jsulm to install this version, should I use the qt-unified-windows-x86-4.1.1-online.exe? and untick all x86 components in custom installation?
                              Or is there an x86_64 installer?

                              J 1 Reply Last reply 28 Jun 2021, 09:50
                              0
                              • M Markyo
                                28 Jun 2021, 09:47

                                @jsulm to install this version, should I use the qt-unified-windows-x86-4.1.1-online.exe? and untick all x86 components in custom installation?
                                Or is there an x86_64 installer?

                                J Offline
                                J Offline
                                jsulm
                                Lifetime Qt Champion
                                wrote on 28 Jun 2021, 09:50 last edited by
                                #21

                                @Markyo Since you already installed x86 Qt simply start the Qt Maintenance Tool and deselct the x86 version and select x86_64 one.

                                https://forum.qt.io/topic/113070/qt-code-of-conduct

                                M 1 Reply Last reply 28 Jun 2021, 10:07
                                0
                                • J jsulm
                                  28 Jun 2021, 09:50

                                  @Markyo Since you already installed x86 Qt simply start the Qt Maintenance Tool and deselct the x86 version and select x86_64 one.

                                  M Offline
                                  M Offline
                                  Markyo
                                  wrote on 28 Jun 2021, 10:07 last edited by
                                  #22

                                  @jsulm While waiting to be able to repost, I uninstalled my qt..
                                  So right now, I'm on this page:
                                  Qt installer
                                  Qt installer next

                                  As you can see, I've unticked the x86 in version I want, is it ok? Plus, is there some things to tick?

                                  J 1 Reply Last reply 28 Jun 2021, 10:10
                                  0
                                  • M Markyo
                                    28 Jun 2021, 10:07

                                    @jsulm While waiting to be able to repost, I uninstalled my qt..
                                    So right now, I'm on this page:
                                    Qt installer
                                    Qt installer next

                                    As you can see, I've unticked the x86 in version I want, is it ok? Plus, is there some things to tick?

                                    J Offline
                                    J Offline
                                    jsulm
                                    Lifetime Qt Champion
                                    wrote on 28 Jun 2021, 10:10 last edited by
                                    #23

                                    @Markyo Why did you install everything?! Do you really need all these Qt versions?
                                    What compiler do you want to use? Select only Qt for the compiler you want to use...
                                    Also, you did not unticked the MSVC and MINGW x86 versions.

                                    https://forum.qt.io/topic/113070/qt-code-of-conduct

                                    M 1 Reply Last reply 28 Jun 2021, 11:33
                                    0
                                    • J jsulm
                                      28 Jun 2021, 10:10

                                      @Markyo Why did you install everything?! Do you really need all these Qt versions?
                                      What compiler do you want to use? Select only Qt for the compiler you want to use...
                                      Also, you did not unticked the MSVC and MINGW x86 versions.

                                      M Offline
                                      M Offline
                                      Markyo
                                      wrote on 28 Jun 2021, 11:33 last edited by
                                      #24

                                      @jsulm I don't know, I thought I had to to install the correct version.
                                      What do you mean about MSVC and MINGW x86? isn't there only 32 and 64?
                                      And for the compiler, honestly I don't know, I think it is the visual studio one, but not sure.

                                      J 1 Reply Last reply 28 Jun 2021, 11:35
                                      0
                                      • M Markyo
                                        28 Jun 2021, 11:33

                                        @jsulm I don't know, I thought I had to to install the correct version.
                                        What do you mean about MSVC and MINGW x86? isn't there only 32 and 64?
                                        And for the compiler, honestly I don't know, I think it is the visual studio one, but not sure.

                                        J Offline
                                        J Offline
                                        jsulm
                                        Lifetime Qt Champion
                                        wrote on 28 Jun 2021, 11:35 last edited by
                                        #25

                                        @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                                        isn't there only 32 and 64?

                                        x86 IS 32bit and x86_64 is 64bit.
                                        Please check what Visual Studio you have and install 64bit Qt version for that Visual Studio version.

                                        https://forum.qt.io/topic/113070/qt-code-of-conduct

                                        M 1 Reply Last reply 28 Jun 2021, 11:49
                                        0
                                        • J jsulm
                                          28 Jun 2021, 11:35

                                          @Markyo said in QMYSQL driver not loaded and Library mysql is not defined:

                                          isn't there only 32 and 64?

                                          x86 IS 32bit and x86_64 is 64bit.
                                          Please check what Visual Studio you have and install 64bit Qt version for that Visual Studio version.

                                          M Offline
                                          M Offline
                                          Markyo
                                          wrote on 28 Jun 2021, 11:49 last edited by
                                          #26

                                          @jsulm Oh ok I understand!
                                          My visual studio is 2019 version 16.6.2, but if I'm reading well, the highest available here is 2017, should I upgrade Qt to 5.15?

                                          J 1 Reply Last reply 28 Jun 2021, 11:51
                                          0

                                          16/44

                                          28 Jun 2021, 09:17

                                          • Login

                                          • Login or register to search.
                                          16 out of 44
                                          • First post
                                            16/44
                                            Last post
                                          0
                                          • Categories
                                          • Recent
                                          • Tags
                                          • Popular
                                          • Users
                                          • Groups
                                          • Search
                                          • Get Qt Extensions
                                          • Unsolved