[Qt-interest] problem with QSqlQuery

[mierdatutis mi]

Hi,

I'm trying to do a select of a database like this:

db.setHostName("xx.xx.xx.xx");
      db.setDatabaseName("prueba");
      db.setUserName("xxxxxxx");
      db.setPassword("yyyyyy");
      if (!db.open())
      {
      QMessageBox::information(this, "Application name","not connected");
      QMessageBox::information(this,"",db.lastError().text());
      }

      QSqlQuery query;

      if( db.open() ) {
      query = QSqlQuery("select * from USERSGROUPS");
      bool prueba = query.exec();
      qDebug() << query.lastError().text();
      QMessageBox::information(this,"",query.lastError().text());
 ............................
..........................
...........................

it gives me: [Microsoft][ODBC controllers admin] Function sequence error
QODBC3: Unable to execute statement

Could you help me please?
Many thanks and sorry for my english!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.qt-project.org/pipermail/qt-interest-old/attachments/20100525/1c566891/attachment.html