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.
  • Christian EhrlicherC Offline
    Christian EhrlicherC Offline
    Christian Ehrlicher
    Lifetime Qt Champion
    wrote on last edited by
    #20

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

    C:/Program Files/MySQL/MySQL Connector C++ 8.0/include

    So why do you pass the wrong path to qmake then??

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

    J 2 Replies Last reply
    0
    • Christian EhrlicherC Christian Ehrlicher

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

      C:/Program Files/MySQL/MySQL Connector C++ 8.0/include

      So why do you pass the wrong path to qmake then??

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

      @Christian-Ehrlicher
      i tried both pathes because i wanted to eleminate other faults
      i also made the qmake call with the mariaDb connector

      1 Reply Last reply
      0
      • Christian EhrlicherC Christian Ehrlicher

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

        C:/Program Files/MySQL/MySQL Connector C++ 8.0/include

        So why do you pass the wrong path to qmake then??

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

        @Christian-Ehrlicher
        @jsulm
        now what should i do ?

        1 Reply Last reply
        0
        • Christian EhrlicherC Offline
          Christian EhrlicherC Offline
          Christian Ehrlicher
          Lifetime Qt Champion
          wrote on last edited by
          #23

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

          i tried both pathes because i wanted to eleminate other faults

          Then show the correct log ... really that hard?

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

          J 1 Reply Last reply
          0
          • Christian EhrlicherC Christian Ehrlicher

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

            i tried both pathes because i wanted to eleminate other faults

            Then show the correct log ... really that hard?

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

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

            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.

            E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers>

            Command line: "MYSQL_INCDIR=C:/Program Files/MySQL/MariaDB/include" "MYSQL_LIBDIR=C:/Program Files/MySQL/MariaDB/lib"
            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 ...
            mysql.h not found in ["C:/Program Files/MySQL/MariaDB/include"] and global paths.
            => source produced no result.
            Trying source 6 (type inline) of library mysql ...
            mysql.h not found in ["C:/Program Files/MySQL/MariaDB/include"] and global paths.
            => source produced no result.
            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

            B 1 Reply Last reply
            0
            • J JonnyQB

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

              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.

              E:\Programme\qt\Tools\5.15.0\Src\qtbase\src\plugins\sqldrivers>

              Command line: "MYSQL_INCDIR=C:/Program Files/MySQL/MariaDB/include" "MYSQL_LIBDIR=C:/Program Files/MySQL/MariaDB/lib"
              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 ...
              mysql.h not found in ["C:/Program Files/MySQL/MariaDB/include"] and global paths.
              => source produced no result.
              Trying source 6 (type inline) of library mysql ...
              mysql.h not found in ["C:/Program Files/MySQL/MariaDB/include"] and global paths.
              => source produced no result.
              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

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

              @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 1 Reply Last reply
              0
              • 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 Offline
                      JonBJ Offline
                      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