ODBC drvers

**mak_user** · 22nd February 2011, 00:17

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.

Qt Code:

Switch view

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;
     }

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