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. QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7 I need QMYSQL
Forum Updated to NodeBB v4.3 + New Features

QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7 I need QMYSQL

Scheduled Pinned Locked Moved Solved General and Desktop
35 Posts 9 Posters 6.6k Views 1 Watching
  • 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.
  • B Bonnie

    @JonnyQB said in QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7 I need QMYSQL:

    Command line: "MYSQL_INCDIR=C:/Program Files/MySQL/MariaDB/include" "MYSQL_LIBDIR=C:/Program Files/MySQL/MariaDB/lib"

    From the picture your posted above, your include dir should be C:/Program Files/MySQL/MariaDB/include/mariadb
    (Or should it be C:/Programme/MySQL/MariaDB/include/mariadb ? I'm not sure with that.)
    Just make sure there is a "mysql.h" in the dir you pass as MYSQL_INCDIR...
    I don't know what your lib dir should be though, but it should have a corresponding .lib file in it.

    J Offline
    J Offline
    JonnyQB
    wrote on last edited by
    #26

    @Bonnie
    yeah this time was better it tried loading mysql but it says no :(

    E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers>qmake -- MYSQL_INCDIR="C:/Program Files/MySQL/MariaDB/include/mariadb" MYSQL_LIBDIR="C:/Program Files/MySQL/MariaDB/lib/mariadb"

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

    Configure summary:

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

    Qt is now configured for building. Just run 'mingw32-make'.
    Once everything is built, you must run 'mingw32-make install'.
    Qt will be installed into 'E:\Programme\qt\Tools\5.15.0\mingw81_64'.

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

    Command line: "MYSQL_INCDIR=C:/Program Files/MySQL/MariaDB/include/mariadb" "MYSQL_LIBDIR=C:/Program Files/MySQL/MariaDB/lib/mariadb"
    Global lib dirs: [C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-winx64\lib C:\Utils\postgresql\pgsql\lib] [E:/Programme/qt/Tools/Tools/mingw810_64/lib/gcc/x86_64-w64-mingw32/8.1.0 E:/Programme/qt/Tools/Tools/mingw810_64/lib/gcc E:/Programme/qt/Tools/Tools/mingw810_64/x86_64-w64-mingw32/lib E:/Programme/qt/Tools/Tools/mingw810_64/lib]
    Global inc dirs: [C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-winx64\include C:\Utils\postgresql\pgsql\include] [E:/Programme/qt/Tools/Tools/mingw810_64/lib/gcc/x86_64-w64-mingw32/8.1.0/include/c++ E:/Programme/qt/Tools/Tools/mingw810_64/lib/gcc/x86_64-w64-mingw32/8.1.0/include/c++/x86_64-w64-mingw32 E:/Programme/qt/Tools/Tools/mingw810_64/lib/gcc/x86_64-w64-mingw32/8.1.0/include/c++/backward E:/Programme/qt/Tools/Tools/mingw810_64/lib/gcc/x86_64-w64-mingw32/8.1.0/include E:/Programme/qt/Tools/Tools/mingw810_64/lib/gcc/x86_64-w64-mingw32/8.1.0/include-fixed E:/Programme/qt/Tools/Tools/mingw810_64/x86_64-w64-mingw32/include]
    looking for library db2
    Trying source 0 (type inline) of library db2 ...
    sqlcli.h not found in [] and global paths.
    sqlcli1.h not 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 ...
    ibase.h not 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 E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && E:\Programme\qt\Tools\5.15.0\mingw81_64\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-winx64\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-winx64\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = "-LC:/Program Files/MySQL/MariaDB/lib/mariadb" -llibmariadb" "QMAKE_INCDIR_MYSQL = "C:/Program Files/MySQL/MariaDB/include/mariadb"" E:/Programme/qt/Tools/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
    • cd /d E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& mingw32-make

    g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -I"C:\Program Files\MySQL\MariaDB\include\mariadb" -IE:\Programme\qt\Tools\5.15.0\mingw81_64\mkspecs\win32-g++ -o main.o main.cpp
    g++ -Wl,-s -Wl,-subsystem,console -mthreads -o mysql.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-winx64\lib -LC:\Utils\postgresql\pgsql\lib -L"C:\Program Files\MySQL\MariaDB\lib\mariadb" -llibmariadb
    E:/Programme/qt/Tools/mingw810_64/bin/../lib/gcc/x86_64-w64-mingw32/8.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -llibmariadb
    collect2.exe: error: ld returned 1 exit status
    mingw32-make: *** [Makefile:69: mysql.exe] Error 1
    => source failed verification.
    Trying source 6 (type inline) of library mysql ...

    • cd /d E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && E:\Programme\qt\Tools\5.15.0\mingw81_64\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-winx64\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-winx64\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += mysql" "QMAKE_LIBS_MYSQL = "-LC:/Program Files/MySQL/MariaDB/lib/mariadb" -llibmysql" "QMAKE_INCDIR_MYSQL = "C:/Program Files/MySQL/MariaDB/include/mariadb"" E:/Programme/qt/Tools/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/mysql
    • cd /d E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\mysql && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

    del main.o
    g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -I"C:\Program Files\MySQL\MariaDB\include\mariadb" -IE:\Programme\qt\Tools\5.15.0\mingw81_64\mkspecs\win32-g++ -o main.o main.cpp
    g++ -Wl,-s -Wl,-subsystem,console -mthreads -o mysql.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-winx64\lib -LC:\Utils\postgresql\pgsql\lib -L"C:\Program Files\MySQL\MariaDB\lib\mariadb" -llibmysql
    E:/Programme/qt/Tools/mingw810_64/bin/../lib/gcc/x86_64-w64-mingw32/8.1.0/../../../../x86_64-w64-mingw32/bin/ld.exe: cannot find -llibmysql
    collect2.exe: error: ld returned 1 exit status
    mingw32-make: *** [Makefile:69: mysql.exe] Error 1
    => source failed verification.
    Trying source 7 (type inline) of library mysql ...
    => source failed condition '!config.win32'.
    Trying source 8 (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 ...
    oci.h not 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 E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && E:\Programme\qt\Tools\5.15.0\mingw81_64\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-winx64\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-winx64\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += odbc" "QMAKE_LIBS_ODBC = -lodbc32" E:/Programme/qt/Tools/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/odbc
    • cd /d E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\odbc && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

    del main.o
    g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -IE:\Programme\qt\Tools\5.15.0\mingw81_64\mkspecs\win32-g++ -o main.o main.cpp
    g++ -Wl,-s -Wl,-subsystem,console -mthreads -o odbc.exe main.o -LC:\openssl\lib -LC:\Utils\my_sql\mysql-5.7.25-winx64\lib -LC:\Utils\postgresql\pgsql\lib -lodbc32
    => source accepted.
    test config.sqldrivers.libraries.odbc succeeded
    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 ...
    libpq-fe.h not 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 ...
    sqlite.h not 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 ...

    • cd /d E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && E:\Programme\qt\Tools\5.15.0\mingw81_64\bin\qmake.exe "CONFIG -= qt debug_and_release app_bundle lib_bundle" "CONFIG += shared warn_off console single_arch" "QMAKE_LIBDIR += C:\openssl\lib C:\Utils\my_sql\mysql-5.7.25-winx64\lib C:\Utils\postgresql\pgsql\lib" "INCLUDEPATH += C:\openssl\include C:\Utils\my_sql\mysql-5.7.25-winx64\include C:\Utils\postgresql\pgsql\include" "QMAKE_USE += tds" "QMAKE_LIBS_TDS = -lNTWDBLIB" E:/Programme/qt/Tools/5.15.0/Src/qtbase/src/plugins/sqldrivers/config.tests/tds
    • cd /d E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds && set MAKEFLAGS=& mingw32-make clean && set MAKEFLAGS=& mingw32-make

    del main.o
    E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers\config.tests\tds\main.o konnte nicht gefunden werden
    g++ -c -fno-keep-inline-dllexport -O2 -w -fexceptions -mthreads -DUNICODE -D_UNICODE -DWIN32 -DMINGW_HAS_SECURE_API=1 -I. -IC:\openssl\include -IC:\Utils\my_sql\mysql-5.7.25-winx64\include -IC:\Utils\postgresql\pgsql\include -IE:\Programme\qt\Tools\5.15.0\mingw81_64\mkspecs\win32-g++ -o main.o main.cpp
    main.cpp:2:10: fatal error: sybfront.h: No such file or directory
    #include <sybfront.h>
    ^~~~~~~~~~~~
    compilation terminated.
    mingw32-make: *** [Makefile:498: main.o] Error 1
    => source failed verification.
    Trying source 1 (type sybaseEnv) of library tds ...
    => source failed condition '!config.win32'.
    test config.sqldrivers.libraries.tds FAILED

    1 Reply Last reply
    0
    • B Offline
      B Offline
      Bonnie
      wrote on last edited by
      #27

      @JonnyQB said in QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7 I need QMYSQL:

      MYSQL_LIBDIR=C:/Program Files/MySQL/MariaDB/lib/mariadb

      Are you sure this folder exists?
      If yes what's in it?

      J 1 Reply Last reply
      0
      • B Bonnie

        @JonnyQB said in QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7 I need QMYSQL:

        MYSQL_LIBDIR=C:/Program Files/MySQL/MariaDB/lib/mariadb

        Are you sure this folder exists?
        If yes what's in it?

        J Offline
        J Offline
        JonnyQB
        wrote on last edited by
        #28

        @Bonnie Unbenannt2.PNG

        JonBJ B 2 Replies Last reply
        0
        • J JonnyQB

          @Bonnie Unbenannt2.PNG

          JonBJ Online
          JonBJ Online
          JonB
          wrote on last edited by
          #29

          @JonnyQB
          Your screenshot shows the word Programme. The output shows MYSQL_LIBDIR=C:/Program Files/MySQL/MariaDB/lib/mariadb. Are these the same paths, through some sort of Windows translation (I don't know)?

          1 Reply Last reply
          0
          • J JonnyQB

            @Bonnie Unbenannt2.PNG

            B Offline
            B Offline
            Bonnie
            wrote on last edited by Bonnie
            #30

            @JonnyQB
            Those don't look like Windows binaries, where do you get them?
            You cannot use linux binaries such as those for centos/debian/ubuntu.....

            J 1 Reply Last reply
            0
            • B Bonnie

              @JonnyQB
              Those don't look like Windows binaries, where do you get them?
              You cannot use linux binaries such as those for centos/debian/ubuntu.....

              J Offline
              J Offline
              JonnyQB
              wrote on last edited by
              #31

              @Bonnie
              from the mariadb website i just klicked on win 64 c++ connector

              B 1 Reply Last reply
              0
              • J JonnyQB

                @Bonnie
                from the mariadb website i just klicked on win 64 c++ connector

                B Offline
                B Offline
                Bonnie
                wrote on last edited by Bonnie
                #32

                @JonnyQB
                Which link?
                I've tried "mariadb-connector-c-3.1.9-win64.msi"
                This will install .lib and .dll, not .a and .so.
                If you have also installed the win 64 msi, you may check if the path "C:\Program Files\MariaDB\MariaDB Connector C 64-bit" exists.

                J 1 Reply Last reply
                1
                • B Bonnie

                  @JonnyQB
                  Which link?
                  I've tried "mariadb-connector-c-3.1.9-win64.msi"
                  This will install .lib and .dll, not .a and .so.
                  If you have also installed the win 64 msi, you may check if the path "C:\Program Files\MariaDB\MariaDB Connector C 64-bit" exists.

                  J Offline
                  J Offline
                  JonnyQB
                  wrote on last edited by
                  #33

                  @Bonnie
                  now it worked wtf but thank you all guys i only need to build it now thanks :)

                  1 Reply Last reply
                  0
                  • S Offline
                    S Offline
                    Sunil kumar verma
                    wrote on last edited by
                    #34

                    I also stuck same problem if your problem resolved it .can you help me???

                    Christian EhrlicherC 1 Reply Last reply
                    0
                    • S Sunil kumar verma

                      I also stuck same problem if your problem resolved it .can you help me???

                      Christian EhrlicherC Offline
                      Christian EhrlicherC Offline
                      Christian Ehrlicher
                      Lifetime Qt Champion
                      wrote on last edited by
                      #35

                      @Sunil-kumar-verma said in QSqlDatabase: available drivers: QSQLITE QODBC QODBC3 QPSQL QPSQL7 I need QMYSQL:

                      I also stuck same problem

                      Where exactly do you stuck? What did you do?

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

                      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