It always popup a the dialog "Driver not loaded Driver not loaded" I had copy all dirvers (QTDIR / plugins/ sqldrivers) 4 dll(qsqlite4.dll qsqlited4.dll,
qsqlodbc4.dll,qsqlodbc4d.dll) to my local debug directory (debug/sqldirvers/).
At first, In .Pro file I add the one line "LIBS += QtSql.lib"
bool createConnection()
{
QSqlQuery query;
bool bResult = false;
QSqlDatabase db = QSqlDatabase::addDatabase("ODBC","staffManager") // staffManager is my database name.
db.setHostName("sever"); // sever is my server name;
db.setDatabaseName("Pet");
if(!db.open()) // it can open database but can not query table it says "Driver not loaded Driver not loaded"
{
QMessage::about (0,Object::tr("DataBase error"),db.lastError().text());
return false;
}
else
{
bResult = query.exec("select * from department");// department is table of database staffManager ; // bResult is false
if(!query.isActive())
{
QMessage::warning(0,Object::tr("DataBase error"),db.lastError().text()); // here it popup the error info."Driver not loaded Driver not loaded"
}
}
}
I hope experts can give me some good solution.
Thank you.