Drive sql

[lucasbemo]

Hi,

How do I get driver to connect my QT application with a database (preferably MySql) ?
I really can not find. : /

Tks.

[tbscope]

http://doc.qt.nokia.com/4.7/qt-sql.html

[Aleksandar]

Here are SQL drivers:
C:\Qt\2010.05\qt\plugins\sqldrivers\
You should copy dll files from this folder in to C:\...\project_name-build-desktop\sqldrivers

You will probably also need some dll files from the folder:
C:\Qt\2010.05\qt\bin\

Don't forget to write Qt += core sql into .pro file

Here is an example:

static bool createConnection()
{
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC", "DatabaseName");
db.setHostName("HostName");
db.setDatabaseName("Database_ODBC_Name");
db.setUserName("user");
db.setPassword("password");
bool status;
status = db.open();

return status;
}

int main(int argc, char *argv[])
{
QApplication a(argc, argv);

if (!createConnection())
{
QMessageBox::information(0, "Error", "Database not openned" );
return 1;
}
else
QMessageBox::information(0, "All fine", "Database openned" );
}


return a.exec();
}

[lucasbemo]

tbscope and Aleksandar thanks (obrigado).