QT & SQLite - driver not loaded[Win7 XP mode failed too]

Hello!

I'm trying to read from SQLite database. I've wrote simple function:

Qt Code:

Switch view

          
            
             void MainWindow
             ::
             odczytajBazeSQL
             (
             )
            

            
             {
            

                
             QSqlDatabase
             ::
             addDatabase
             (
             "QSQLITE"
             );
            

            
              
            

                
             QSqlDatabase bdb;
            

            
                 bdb.
             setDatabaseName
             (
             "/test.db"
             );
            

            
                 bdb.
             open
             (
             );
            

            
              
            

                
             QSqlQueryModel 
             *queryModel 
             = 
             new 
             QSqlQueryModel;
            

            
                 queryModel
             ->setQuery
             (
             "SELECT * FROM t1", bdb
             );
            

            
              
            

            
                 ui
             ->tableView
             ->setModel
             (queryModel
             );
            

            
             }

To copy to clipboard, switch view to plain text mode

test.db is a simple database with one table t1. When I'm trying to read with code above I get error:

Qt Code:

Switch view

          
            
             QSqlDatabase
             : QSQLITE driver not loaded
            

            
             QSqlDatabase
             : available drivers
             :
            

            
             QSqlQuery
             ::
             exec
             : database not open

To copy to clipboard, switch view to plain text mode

Normally I'm using sqlite3 to create and use databases. What should I do to make it work?

thanks in advance
best regards
Tomasz

wysota · 21st July 2010, 01:15

QSqlDatabase: available drivers:

You don't seem to have any Qt sql drivers installed. Maybe you need to install some additional packages for your distribution.

Tomasz · 21st July 2010, 10:22

I've copied compilled driver (it wasn't there), I've change my code to:

Qt Code:

Switch view

          
            
             QSqlDatabase bdb 
             = 
             QSqlDatabase
             ::
             addDatabase
             (
             "QSQLITE"
             );
            

            
              
            

            
             bdb.
             setDatabaseName
             (
             "./test.db"
             );
            

            
             ok 
             = bdb.
             open
             (
             );

To copy to clipboard, switch view to plain text mode

and now It works fine,

best regards
Tomasz

wysota · 21st July 2010, 10:28

Change your code to:

Qt Code:

Switch view

          
            
             QSqlDatabase bdb 
             = 
             QSqlDatabase
             ::
             addDatabase
             (
             "QSQLITE"
             );
            

            
             bdb.
             setDatabaseName
             (
             "/test.db"
             );
            

            
             bdb.
             open
             (
             );

To copy to clipboard, switch view to plain text mode

sadjoker · 22nd July 2010, 18:13

Hello all. As we are speaking about SQLITE driver i had a very stressful experience with that driver (4.6.2/4.6.3). I deployed over 100 copies of one program using latest sqlite driver. There was no problem anywhere... i put the dll file under the executable file in directory "sqldrivers".
Only in some particular systems this new driver wasn`t loading... i was like O_o. I`m talking about 2% of all the systems.
I`ve spent a lot of hours debugging remotely the machines and didn`t find a way to make it work. But i knew my old software worked on those machines before... then i switched to a sqlite dll from 4.4.0 and .. magically the driver was loaded!
Apparently something in the driver changed but i couldn`t find time to investigate further.

Edit: the machines were WinXP Pro SP3.

QT & SQLite - driver not loaded[Win7 XP mode failed too]

http://www.qtcentre.org/threads/32585-QT-amp-SQLite-driver-not-loaded

QT & SQLite - driver not loaded

Re: QT & SQLite - driver not loaded

The following user says thank you to wysota for this useful post:

Re: QT & SQLite - driver not loaded

Re: QT & SQLite - driver not loaded

The following user says thank you to wysota for this useful post:

Re: QT & SQLite - driver not loaded