I do not have the mySql driver so i am trying to connect to mySql using odbc. It seems to connect and open but i can not query the database. can someone please help me out?


Qt Code: 
  1. {
  2.     QSqlDatabase Db = QSqlDatabase::addDatabase("QODBC", "Calendar");
  3.  
  4.     Db.setHostName("localhost");
  5.     Db.setDatabaseName("mySql");
  6.     Db.setUserName("root");
  7.  
  8.    bool goodQuery;
  9.    bool validrec;
  10. int x;
  11. x=1;
  12.  
  13. if(Db.open())    // database is open
  14.    {
  15.     QSqlQuery query(Db);
  16.     query.exec("SELECT * from artist" );
  17.     goodQuery=query.isActive();          // this returns true
  18.     query.first();
  19.     validrec=query.isValid();   // this returns false
  20.     x=query.size();    // this returns -1
  21.  
  22.     while(query.next()){
  23.      new QListWidgetItem(tr("Hazel"), ui->listWidget);  //this never executes
  24.       }
  25.    }
  26. Db.close();
  27. }
To copy to clipboard, switch view to plain text mode