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
    #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
                                      • K Offline
                                        K Offline
                                        KillGabio
                                        wrote on last edited by
                                        #22

                                        http://www.qtcentre.org/threads/46910-weird-weird-mingw32-make?p=212065#post212065

                                        solution there

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

                                          Man, I have asked for help about MYSQL driver about 1 month ago(I am using qt static and want to obtain a lib not a dll). I have compiled and recompiled that small sqldriver project about 100 times:) Finally I got it, and released just an .exe with all QT features :)) I am glad you have managed to build a sqldriver on you own and hope that in future you will share your adventures :P

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

                                          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