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. [SOLVED]QSqlDatabase

[SOLVED]QSqlDatabase

Scheduled Pinned Locked Moved General and Desktop
24 Posts 5 Posters 12.0k Views
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    panosk
    wrote on last edited by
    #14

    OK, got confused cause your sample code tries to connect to Postrgre and then all the discussion was about MySQL. As SGaist suggested, you need the sources, but don't know where you can get them as I use the SDK which includes the sqldriver sources.

    1 Reply Last reply
    0
    • F Offline
      F Offline
      FreeQy
      wrote on last edited by
      #15

      Can you than maybe link to me where to download the SDK from?
      'cause today i tried 3-4 different Qts....and nothing :S

      1 Reply Last reply
      0
      • P Offline
        P Offline
        panosk
        wrote on last edited by
        #16

        Well, at the top of the download page you can choose a Windows SDK, nothing confusing there. However, are you sure you are searching in the right place for the mysql driver? If you already have an SDK installation, the full path to the MySQL driver folder is this
        @
        QtRootInstallationFolder/Src/qtbase/src/plugins/sqldrivers/mysql
        @

        1 Reply Last reply
        0
        • F Offline
          F Offline
          FreeQy
          wrote on last edited by
          #17

          haha, that's nice :D
          ok, the files are there, so i just have to compile them with the 'qmake' through my windows terminal?
          compiled it (i saw that with the normal terminal the qmake command didn't work, so i did it with the terminal provided by Qt), but now the final make command gives me an error lol

          @C:\Qt\Qt5.0.2\5.0.2\Src\qtbase\src\plugins\sqldrivers\mysql>make
          make -f Makefile.Release all
          make[1]: Entering directory /c/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/sqldrive rs/mysql' g++ -c -pipe -fno-keep-inline-dllexport -O2 -std=c++0x -fno-exceptions -frtti -W all -Wextra -DUNICODE -DQT_NO_CAST_TO_ASCII -DQT_NO_CAST_FROM_ASCII -DQT_NO_EXCE PTIONS -DQT_NO_DEBUG -DQT_PLUGIN -DQT_SQL_LIB -DQT_CORE_LIB -I. -I'/usr/local/in clude' -I'C:/Qt/Qt5.0.2/5.0.2/mingw47_32/include' -I'C:/Qt/Qt5.0.2/5.0.2/mingw47 _32/include/QtSql' -I'C:/Qt/Qt5.0.2/5.0.2/mingw47_32/include/QtSql/5.0.2' -I'C:/ Qt/Qt5.0.2/5.0.2/mingw47_32/include/QtSql/5.0.2/QtSql' -I'C:/Qt/Qt5.0.2/5.0.2/mi ngw47_32/include/QtCore' -I'.moc/release_shared' -I'../../../../mkspecs/win32-g+ +' -o .obj/release_shared/main.o main.cpp In file included from main.cpp:44:0: ../../../sql/drivers/mysql/qsql_mysql.h:52:19: fatal error: mysql.h: No such fil e or directory compilation terminated. make[1]: *** [.obj/release_shared/main.o] Error 1 make[1]: Leaving directory /c/Qt/Qt5.0.2/5.0.2/Src/qtbase/src/plugins/sqldriver
          s/mysql'
          make: *** [release-all] Error 2
          @

          1 Reply Last reply
          0
          • P Offline
            P Offline
            panosk
            wrote on last edited by
            #18

            OK, one step closer :). I don't quite get what you mean with the terminal issue, but are you giving the path to the mysql include folder in your qmake command, as you wrote in a previous post?
            @
            "INCLUDEPATH+=C:/MySQL/include"
            @
            The mysql.h file should be in there.

            1 Reply Last reply
            0
            • F Offline
              F Offline
              FreeQy
              wrote on last edited by
              #19

              Well, there was no MySQL folder
              i just downloaded a lot of packages, and so i will now retry :D
              thanks

              1 Reply Last reply
              0
              • F Offline
                F Offline
                FreeQy
                wrote on last edited by
                #20

                OK

                everything done, compiling with both qmake and make, and no errors came out :D

                now, going back to Qt:

                i've put one line of code to try the DB:
                @void MainWindow::connectDB()
                {
                QSqlDatabase db = QSqlDatabase::addDatabase("QMYSQL");
                }
                @

                and the output is just:

                @C:\Users\Nick\Documents\QT_Projects\HotelManagement\mainwindow.cpp:39: error: undefined reference to `_imp___ZN12QSqlDatabase17defaultConnectionE'@

                is it something that i just don't get?

                EDIT: !http://i46.tinypic.com/14v4fuo.jpg(code)!

                1 Reply Last reply
                0
                • P Offline
                  P Offline
                  panosk
                  wrote on last edited by
                  #21

                  Are you including <QSqlDatabase> in the file where you are trying to establish the connection? Also,
                  try to get the list of available drivers with QSqlDatabase::drivers().

                  1 Reply Last reply
                  0
                  • F Offline
                    F Offline
                    FreeQy
                    wrote on last edited by
                    #22

                    That's what I include:
                    !http://i47.tinypic.com/2hfnyhk.jpg(include)!

                    And it still gives me error, for the drivers():
                    @C:\Users\Nick\Documents\QT_Projects\HotelManagement\mainwindow.cpp:38: error: undefined reference to `_imp___ZN12QSqlDatabase7driversEv'@

                    1 Reply Last reply
                    0
                    • F Offline
                      F Offline
                      FreeQy
                      wrote on last edited by
                      #23

                      OMG, that was crazy haha
                      i had in my .pro file
                      @QT += core gui@
                      and i thought that i had to just add the 'sql' like the methods below...
                      and that's why it didn't work...
                      ooooh my goood

                      thanks a lot guys, and sorry for disturbing so much

                      SOLVED

                      1 Reply Last reply
                      0
                      • P Offline
                        P Offline
                        panosk
                        wrote on last edited by
                        #24

                        Nice, don't forget to mark your thread's title as [SOLVED].

                        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