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.5k 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 Christian Ehrlicher

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

    mysql.h not found in ["C:/Program Files/MySQL/MySQL Connector C++ 8.0/include"]

    So is your mysql.h in this directory or did you install it in another place?

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

    @Christian-Ehrlicher
    i tried 2 seperate connectsUnbenannt.PNG

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