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

          
          

           
           
 
            
 
             : QSQLITE driver not loaded 
            

           
           
 
            
 
             : available drivers 
             : 
            

           
           
 
            
 
             QSqlQuery 
             exec 
             : database not open 
            
          
          

sqlite3 to create and use databases. What should I do to make it work?

thanks in advance
best regards
Tomasz