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

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

   QT & SQLite - driver not loaded

   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 
               
             
             

   
   Normally I'm using sqlite3 to create and use databases. What should I do to make it work?
   
   thanks in advance
   best regards
   Tomasz

   Reply With Quote
2. 21st July 2010,01:15 #2 wysota Master of Zen Join Date Jan 2006 Location Warsaw,Poland Posts 28,434 Thanks 3 Thanked 4,110 Times in 3,960 Posts Qt products Platforms Blog Entries 4 Wiki edits 10 Re: QT & SQLite - driver not loaded

   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.

   Your biological and technological distinctiveness will be added to our own. Resistance is futile.
   
   Please ask Qt related questions on the forum and not using private messages or visitor messages.
   
   

   Reply With Quote

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

   Tomasz(21st July 2010)

4. 10:22 #3 Tomasz Intermediate user Join Date Jul 2010 Location Poland Posts 184 Thanks 70 Thanked 4 Times in 4 Posts Qt products Platforms Re: QT & SQLite - driver not loaded

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

   QSqlDatabase bdb 
                = 
                ); 
               

6. bdb. "./test.db" );
7. ok = bdb. );

Last edited by Tomasz; 21st July 2010 at 10:30.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!