Could anyone tell me why I cant execute the SQL query?

DrizzleX

Lab Rat
2 posts

#include <QtCore/QCoreApplication>
#include <QtSql/QSqlDatabase>
#include <QtSql>
#include <QStringList>
#include <QDebug>
struct Student
{
QString id;
QString name;
QString sex;
};
int main(int argc, char *argv[])
{
QCoreApplication a(argc, argv);
QSqlDatabase db=QSqlDatabase::addDatabase("QODBC");
QString dsn = QString::fromLocal8Bit("DRIVER={SQL SERVER};SERVER=127.0.0.1;DATABASE=mydb");
db.setDatabaseName(dsn);
db.setUserName("admin");
db.setPassword("123456");
if(db.open()) {
qDebug()<<"OK!";
}
else{
qDebug()<<"Error!";
}
QSqlQuery query(db);
query.exec("select * from NewStudent");
QSqlError error=query.lastError();
qDebug()<<error.number();
if(!query.isValid()){
qDebug()<<"Invalid!";
}
while(query.next()){
Student student;
student.id=query.value(0).toString();
student.name=query.value(1).toString();
student.sex=query.value(2).toString();
qDebug()<<"ID: "<<student.id<<" Name: "<<student.name<<" Sex: "<<student.sex;
}
return a.exec();
}

the output of qDebug()<<error.number();
is 16945，and Invalid is printed

1 reply

qxoz

Area 51 Engineer
585 posts

Where do you get the QODBC driver(how you build and from which source)?

You must log in to post a reply. Not a member yet? Register here!

Tags what is this? Undo?