Hi,
I would lke to established connection to Microsoft Access database.
I am using:
-QT bin installed(for which I thought include all drivers installed once the bin package is installed)
-Ubuntu operating system
-MS Access database on windows7 system.
db.setHostName("0.0.0.0");
db.setDatabaseName("data_source_name");
if (!db.open()) {
QString err
= db.
lastError().
text();
QMessageBox::warning(0, qApp
->tr
("Cannot open database"),
err, "OK");
return false;
}
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
qDebug() << QSqlDatabase::drivers();
db.setHostName("0.0.0.0");
db.setDatabaseName("data_source_name");
if (!db.open()) {
QString err = db.lastError().text();
QMessageBox::warning(0, qApp->tr("Cannot open database"),
err, "OK");
return false;
}
To copy to clipboard, switch view to plain text mode
I got this errors at QSqlDatabase::addDatabase("QODBC"):
QSqlDatabase: QODBC driver not loaded
QSqlDatabase: available drivers: QSQLITE QPSQL7 QPSQL
and this info at QSqlDatabase::drivers():
("QSQLITE", "QPSQL7", "QPSQL")
So, obviously I can not use QODBC. Could you please help me with some info like, where can I find this drivers and how to install them to be available in QT enviroment?
thanks
Bookmarks