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. Problems with QSQLite
Forum Updated to NodeBB v4.3 + New Features

Problems with QSQLite

Scheduled Pinned Locked Moved General and Desktop
23 Posts 4 Posters 9.0k 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.
  • L Offline
    L Offline
    lgeyer
    wrote on last edited by
    #2

    Just have another read on "QSqlDatabase":http://developer.qt.nokia.com/doc/qt-4.8/qsqldatabase.html#details, especially the example, and I do not wonder that the compiler complains about QSmallInt, because there is no such class QSmallInt.

    1 Reply Last reply
    0
    • K Offline
      K Offline
      KillGabio
      wrote on last edited by
      #3

      i was wrong about QSmaillInt sorry about that (when i run mingw32-make says that QString is not a type)

      what ever, my real problem is the driver not loaded, i tried placing qsqlite4.dll 's in my app folder but nothing i dont know what to do i been reading all day and i cant get and answer

      i dont know why this happens cause i installed the Qt skd latest version this morning and its supposed to have qsqlite ready to be used...

      Hope you can help.

      1 Reply Last reply
      0
      • L Offline
        L Offline
        lgeyer
        wrote on last edited by
        #4

        No, your real problem is that your code is just wrong.
        @
        // example taken from the QSqlDatabase documentation

        QSqlDatabase db = QSqlDatabase::addDatabase("QPSQL");
        db.setHostName("acidalia");
        ...

        // your code

        QSqlDatabase db;
        db.addDatabase("QSQLITE");
        db.setDatabaseName("GestionVinoteca");
        ...
        @

        1 Reply Last reply
        0
        • G Offline
          G Offline
          goetz
          wrote on last edited by
          #5

          Port 1521 is Oracle. PostgreSQL is usually 5432.

          http://www.catb.org/~esr/faqs/smart-questions.html

          1 Reply Last reply
          0
          • B Offline
            B Offline
            bu7ch3r
            wrote on last edited by
            #6

            You can set credentials and port for sqllite database?

            for(int i = 200; i > 0;)
            try
            {
            //do something
            }
            catch(...)
            {
            i--;//try again
            }

            1 Reply Last reply
            0
            • K Offline
              K Offline
              KillGabio
              wrote on last edited by
              #7

              thank u all...the problem was the code :(

              but then again i have another question..i have an oracle database so the drivers i should use are QOCCI, right? the problem is that when i paste them on my plugins path of the QtSKD say`s that the drivers are not installed...

              what should i do? cause i read the documentation and i run the qmake it generates the files but when i run nmake the commandpromt tells that nmake is not a command...

              then again thank u all

              1 Reply Last reply
              0
              • G Offline
                G Offline
                goetz
                wrote on last edited by
                #8

                The Qt oracle driver must be built manually. See the "Manual":/doc/qt-4.8/sql-driver.html for the instructions.

                http://www.catb.org/~esr/faqs/smart-questions.html

                1 Reply Last reply
                0
                • K Offline
                  K Offline
                  KillGabio
                  wrote on last edited by
                  #9

                  i followed the guide and finally, in the last step i get the error: nmake is not known as a command intern extern, program or file...

                  so i tried to run mingw32-make and i get like tons of errors like it is not recognising any QT library

                  1 Reply Last reply
                  0
                  • K Offline
                    K Offline
                    KillGabio
                    wrote on last edited by
                    #10

                    i just downloaded nmake pasted on the folder that i did the qmake...when i run the command nmake i get the same error as running it with mingw32-make....

                    its my first time with Qt and im having a real headache

                    1 Reply Last reply
                    0
                    • B Offline
                      B Offline
                      bu7ch3r
                      wrote on last edited by
                      #11

                      Just run nmake from the visual studio command prompt.

                      for(int i = 200; i > 0;)
                      try
                      {
                      //do something
                      }
                      catch(...)
                      {
                      i--;//try again
                      }

                      1 Reply Last reply
                      0
                      • K Offline
                        K Offline
                        KillGabio
                        wrote on last edited by
                        #12

                        why should i have Visual Studio if im trying to install the OCI?? i think the problems are the dependencies with Qt cause the errors i get when trying to install them manually or building the .pro file with QtCreator are because it doesnt recognise QString and those libraries...

                        !http://www.qtcentre.org/attachment.php?attachmentid=7287&d=1326927709()!

                        1 Reply Last reply
                        0
                        • K Offline
                          K Offline
                          KillGabio
                          wrote on last edited by
                          #13

                          Ps: thanks everyone!

                          1 Reply Last reply
                          0
                          • G Offline
                            G Offline
                            goetz
                            wrote on last edited by
                            #14

                            Which toolchain are you using? Visual Studio or MinGW?

                            http://www.catb.org/~esr/faqs/smart-questions.html

                            1 Reply Last reply
                            0
                            • K Offline
                              K Offline
                              KillGabio
                              wrote on last edited by
                              #15

                              MinGW and i run the command mingw32-make and i get the errors of the image :/

                              1 Reply Last reply
                              0
                              • B Offline
                                B Offline
                                bu7ch3r
                                wrote on last edited by
                                #16

                                I can't remember my pass on qtcenter. I guess you are using qmake from QT console. The error you get using the console is normal. Run nmake or WhatEverYouWantMake using full path. c:/folder/builder/someting.exe.

                                for(int i = 200; i > 0;)
                                try
                                {
                                //do something
                                }
                                catch(...)
                                {
                                i--;//try again
                                }

                                1 Reply Last reply
                                0
                                • K Offline
                                  K Offline
                                  KillGabio
                                  wrote on last edited by
                                  #17

                                  same output...same fu*** errors.. sorry i dont know whats happening

                                  1 Reply Last reply
                                  0
                                  • B Offline
                                    B Offline
                                    bu7ch3r
                                    wrote on last edited by
                                    #18

                                    Hey, temper temper. You might have something wrong with your env variables when you run from QtCreator. You said that you have copied qsqllite4.dll into the folder of your app, but this won't help. When deploying you must make a subdir called "sqldrivers" there you have to copy qsqllite4.dll if you run the release version or qsqllite4d.dll if you run the debug version. To be sure just copy both.
                                    Another thing if you have those two dlls then you definetly have sqllite support. The SDK version has it. If nothing works try uninstalling all and reinstall it again. However when I have compiled Qt as static from the vanilla sources I didn't have any problem in using qsqllite(do not use: -no-sql-sqlite and or -system-sqlite).

                                    for(int i = 200; i > 0;)
                                    try
                                    {
                                    //do something
                                    }
                                    catch(...)
                                    {
                                    i--;//try again
                                    }

                                    1 Reply Last reply
                                    0
                                    • K Offline
                                      K Offline
                                      KillGabio
                                      wrote on last edited by
                                      #19

                                      lol yes sorry. I have no problem with sqlite. Someone solved it by changing my code (ty someone) the problem now is how to install occi drivers cause i follow the documentation but nothing happens. I have an oracle database and i want to use it :/

                                      1 Reply Last reply
                                      0
                                      • K Offline
                                        K Offline
                                        KillGabio
                                        wrote on last edited by
                                        #20

                                        i managed to get to this, but i cant solve the problem i cant find any lQtsqld in my system:
                                        @F:\QtSKD\QtSources\4.7.4\src\plugins\sqldrivers\oci>mingw32-make
                                        mingw32-make -f Makefile.Debug all
                                        mingw32-make[1]: Entering directory F:/QtSKD/QtSources/4.7.4/src/plugins/sqldri vers/oci' g++ -mthreads -shared -Wl,--out-implib,f:\QtSKD\QtSources\4.7.4\plugins\sqldrive rs\libqsqlocid4.a -o ..\..\..\..\plugins\sqldrivers\qsqlocid4.dll tmp/obj/debug_ shared/main.o tmp/obj/debug_shared/qsql_oci.o tmp/obj/debug_shared/moc_qsql_oci. o tmp/obj/debug_shared/moc_qsqldriverplugin.o -L"f:\QtSKD\QtSources\4.7.4\lib" -L"%LIB%" -L"f:\oraclexe\app\oracle\product\11.2.0\server\oci\lib\msvc" -L"f:\Qt SKD\QtSources\4.7.4\lib" tmp\obj\debug_shared\qsqlocid_resource_res.o -loci -lQt Sqld -lQtCored f:/qtskd/mingw/bin/../lib/gcc/mingw32/4.4.0/../../../../mingw32/bin/ld.exe: cann ot find -lQtSqld collect2: ld returned 1 exit status mingw32-make[1]: *** [..\..\..\..\plugins\sqldrivers\qsqlocid4.dll] Error 1 mingw32-make[1]: Leaving directory F:/QtSKD/QtSources/4.7.4/src/plugins/sqldriv
                                        ers/oci'
                                        mingw32-make: *** [debug-all] Error 2 @

                                        1 Reply Last reply
                                        0
                                        • K Offline
                                          K Offline
                                          KillGabio
                                          wrote on last edited by
                                          #21

                                          problem solved FUCK YEAH

                                          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