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. QSqlite driver does not load
Forum Updated to NodeBB v4.3 + New Features

QSqlite driver does not load

Scheduled Pinned Locked Moved General and Desktop
sqldesktopdllqsqldatabasedriversqliteplugindeployment
20 Posts 4 Posters 19.2k Views 2 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.
  • mrjjM mrjj

    @danks_
    :(
    if you
    qDebug() << QSqlDatabase::drivers();

    it does list sqlite?

    D Offline
    D Offline
    danks_
    wrote on last edited by
    #11

    @mrjj
    ("QSQLITE", "QMYSQL", "QMYSQL3", "QODBC", "QODBC3", "QPSQL", "QPSQL7") is what I see, but I guess it's because I'm running from inside Qt

    mrjjM 1 Reply Last reply
    0
    • D danks_

      @mrjj
      ("QSQLITE", "QMYSQL", "QMYSQL3", "QODBC", "QODBC3", "QPSQL", "QPSQL7") is what I see, but I guess it's because I'm running from inside Qt

      mrjjM Offline
      mrjjM Offline
      mrjj
      Lifetime Qt Champion
      wrote on last edited by mrjj
      #12

      @danks_ do you get same list from if you run it standalone ?
      I get only "QSQLITE" as expected.

      D 1 Reply Last reply
      1
      • mrjjM mrjj

        @danks_ do you get same list from if you run it standalone ?
        I get only "QSQLITE" as expected.

        D Offline
        D Offline
        danks_
        wrote on last edited by
        #13

        @mrjj Weirdly, I do get the same list from standalone...

        I wasn't sure about how to get the list from standalone, since standalone doesn't show qDebug, so I did the following:

         QStringList testStr;
         testStr << QSqlDatabase::drivers();
         QString str = testStr.join("");
         str = testStr.join(",");
         QMessageBox boxQry;
                    boxQry.setText(str);
                    boxQry.exec();
        

        Standalone folder only has sqlite.dll inside of sqldrivers folder, I'm really confused now.

        mrjjM 1 Reply Last reply
        0
        • D danks_

          @mrjj Weirdly, I do get the same list from standalone...

          I wasn't sure about how to get the list from standalone, since standalone doesn't show qDebug, so I did the following:

           QStringList testStr;
           testStr << QSqlDatabase::drivers();
           QString str = testStr.join("");
           str = testStr.join(",");
           QMessageBox boxQry;
                      boxQry.setText(str);
                      boxQry.exec();
          

          Standalone folder only has sqlite.dll inside of sqldrivers folder, I'm really confused now.

          mrjjM Offline
          mrjjM Offline
          mrjj
          Lifetime Qt Champion
          wrote on last edited by
          #14

          @danks_
          oh so it list all drivers even it should only see the lite one.
          That is not what I would expect.

          I also checked in release build and still only got QSQLITE.

          Also I wonder a bit about
          db.setDatabaseName (File Path); error as I use that call.

          db = QSqlDatabase::addDatabase ( "QSQLITE" );
              db.setDatabaseName ( DBPath );        
              if ( db.open() )  ...
          

          Also Im using qt 5.4 so I wonder if setDatabaseName was dropped.

          D 1 Reply Last reply
          1
          • mrjjM mrjj

            @danks_
            oh so it list all drivers even it should only see the lite one.
            That is not what I would expect.

            I also checked in release build and still only got QSQLITE.

            Also I wonder a bit about
            db.setDatabaseName (File Path); error as I use that call.

            db = QSqlDatabase::addDatabase ( "QSQLITE" );
                db.setDatabaseName ( DBPath );        
                if ( db.open() )  ...
            

            Also Im using qt 5.4 so I wonder if setDatabaseName was dropped.

            D Offline
            D Offline
            danks_
            wrote on last edited by
            #15

            @mrjj
            Maybe I should go to 5.4 and try my luck :)
            I guess I'll let you know, thanks a lot for your help!

            mrjjM 1 Reply Last reply
            0
            • D danks_

              @mrjj
              Maybe I should go to 5.4 and try my luck :)
              I guess I'll let you know, thanks a lot for your help!

              mrjjM Offline
              mrjjM Offline
              mrjj
              Lifetime Qt Champion
              wrote on last edited by
              #16

              @danks_
              Well, there is no reason it should not work in 5_5. but could be fun to test 5.4 just to see.
              tomorrow I will try 5_5 in virtual machine. I was planning to upgrade :)

              You are most welcome. Sadly we did not find a fix.

              D 1 Reply Last reply
              0
              • mrjjM mrjj

                @danks_
                Well, there is no reason it should not work in 5_5. but could be fun to test 5.4 just to see.
                tomorrow I will try 5_5 in virtual machine. I was planning to upgrade :)

                You are most welcome. Sadly we did not find a fix.

                D Offline
                D Offline
                danks_
                wrote on last edited by
                #17

                @mrjj It's all about learning, maybe someone will post a solution sometime :) if 5.4 gets it done, there's no real downside for me haha

                mrjjM 1 Reply Last reply
                0
                • D danks_

                  @mrjj It's all about learning, maybe someone will post a solution sometime :) if 5.4 gets it done, there's no real downside for me haha

                  mrjjM Offline
                  mrjjM Offline
                  mrjj
                  Lifetime Qt Champion
                  wrote on last edited by
                  #18

                  @danks_
                  Absolutely. Yeah if we are lucky someone will show us the light tomorrow :)
                  I have this feeling it is something very simple.

                  D 1 Reply Last reply
                  1
                  • mrjjM mrjj

                    @danks_
                    Absolutely. Yeah if we are lucky someone will show us the light tomorrow :)
                    I have this feeling it is something very simple.

                    D Offline
                    D Offline
                    danks_
                    wrote on last edited by
                    #19

                    @mrjj 5.4 worked flawlessly, maybe a bug to be reported? :p

                    mrjjM 1 Reply Last reply
                    0
                    • D danks_

                      @mrjj 5.4 worked flawlessly, maybe a bug to be reported? :p

                      mrjjM Offline
                      mrjjM Offline
                      mrjj
                      Lifetime Qt Champion
                      wrote on last edited by mrjj
                      #20

                      @danks_
                      That is good to hear !
                      Could also been some kind of setup problem with 5_5 but yeah it does
                      seems like a bug.

                      I will try with 5_5 and see it it fails for me too.

                      update:
                      Tested win pure 5_5 install
                      It worked by copying the DLLs ! ?
                      Even worked with no sub sqldrivers folder ...!
                      (in the release folder)

                      But when moved out of the virtual machines
                      it did want the sqldrivers folder to work.

                      So the current version of 5.5 via the online installer does seems to work in regards to sql.?!

                      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