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
QtWS25 Last Chance

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.
  • Christian EhrlicherC Christian Ehrlicher

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

    Maybe you forgot to setup the environment?

    You did not set up the MSVC environment as the error tells you - you have to run it from a MSVC command prompt. Nothing Qt specific - if you want to use a compiler in an environment you have to properly set it up.

    Honestly, I don't understand why it is so hard to use the MySQL driver..

    Ask Oracle why they changed their license so it can be shipped as pre-build library

    M Offline
    M Offline
    Markyo
    wrote on last edited by
    #41

    @Christian-Ehrlicher thx so much it worked, the command tell me this:

    Running configuration tests...
    Checking for DB2 (IBM)... no
    Checking for InterBase... no
    Checking for MySQL... yes
    Checking for OCI (Oracle)... no
    Checking for ODBC... yes
    Checking for PostgreSQL... no
    Checking for SQLite (version 2)... no
    Checking for TDS (Sybase)... no
    Done running configuration tests.
    
    Configure summary:
    
    Qt Sql Drivers:
      DB2 (IBM) .............................. no
      InterBase .............................. no
      MySql .................................. yes
      OCI (Oracle) ........................... no
      ODBC ................................... yes
      PostgreSQL ............................. no
      SQLite2 ................................ no
      SQLite ................................. yes
        Using system provided SQLite ......... no
      TDS (Sybase) ........................... no
    
    Qt is now configured for building. Just run 'nmake'.
    Once everything is built, you must run 'nmake install'.
    Qt will be installed into 'C:\Qt\5.12.5\msvc2017'.
    
    Prior to reconfiguration, make sure you remove any leftovers from
    the previous build.
    

    So, MySQL is available, I typed nmake, then nmake install, then nmake install in mysql directory, everything seems to work.

    I rebuilt my app, and ran the app and get this:

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

    Don't understand why it is available but not loaded.

    1 Reply Last reply
    0
    • SGaistS Offline
      SGaistS Offline
      SGaist
      Lifetime Qt Champion
      wrote on last edited by
      #42

      The driver needs the dlls to be loaded.

      You can help finding them modifying the PATH environment variable in the Run part of the Project panel in Qt Creator.

      Interested in AI ? www.idiap.ch
      Please read the Qt Code of Conduct - https://forum.qt.io/topic/113070/qt-code-of-conduct

      M 2 Replies Last reply
      0
      • SGaistS SGaist

        The driver needs the dlls to be loaded.

        You can help finding them modifying the PATH environment variable in the Run part of the Project panel in Qt Creator.

        M Offline
        M Offline
        Markyo
        wrote on last edited by
        #43

        @SGaist After editing PATH variable to add dll's path, it finally worked !

        Thank you so much everyone for your time and helpful responses !

        1 Reply Last reply
        0
        • SGaistS SGaist

          The driver needs the dlls to be loaded.

          You can help finding them modifying the PATH environment variable in the Run part of the Project panel in Qt Creator.

          M Offline
          M Offline
          Markyo
          wrote on last edited by Markyo
          #44

          @SGaist Hello! I'm building a second app using QMySQL database, the first app (the one about this topic) works perfectly as expected, but the second tells me that the driver isn't loaded.

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

          I added mysql dll dir in PATH environment variable, but same problem stay the same..

          Have you an idea please?

          EDIT: nevermind, I'm just stupid, I forgot the "Q" before "MYSQL" call in code line:

          QSqlDatabase db = QSqlDatabase::addDatabase("MYSQL");
          

          Now it's:

          QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
          

          and strangely, works better..

          Again, thank you all for your help!

          1 Reply Last reply
          0

          • Login

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