problem in using QODBC ???????

[saeed]

hi
i want to use QODBC for use ms Access database.

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=Data.mdb");
    if(!db.open())
        QMessageBox::information(this,"",db.lastError().text());

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=Data.mdb");
    if(!db.open())
        QMessageBox::information(this,"",db.lastError().text());

To copy to clipboard, switch view to plain text mode 

but have this error : QSqlError(0, "QODBC3: Unable to connect", " [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified").

please help me for solve this problem.
Thanks.

[Rhayader]

Is your Data.mdb in the same directory with your executable? Try setting a full path and see if it throws an error.

[ChrisW67]

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=Data.mdb");  // <<<<<< DSN=''
    if(!db.open())
        QMessageBox::information(this,"",db.lastError().text());

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=Data.mdb");  // <<<<<< DSN=''
    if(!db.open())
        QMessageBox::information(this,"",db.lastError().text());

To copy to clipboard, switch view to plain text mode 

but have this error : QSqlError(0, "QODBC3: Unable to connect", " [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified").

I have emphasised the two pieces of information that I would put together. Do you really have a predefined data source (in your ODBC admin) that is called ''?

Here is an ODBC connection string that I use on a legacy database:

// construct an ODBC connection string for the Access Db
        QString conn = QString("Driver={Microsoft Access Driver (*.mdb)};Dbq=%1;Uid=Admin;Pwd=;").arg(fileName);

// construct an ODBC connection string for the Access Db
        QString conn = QString("Driver={Microsoft Access Driver (*.mdb)};Dbq=%1;Uid=Admin;Pwd=;").arg(fileName);

To copy to clipboard, switch view to plain text mode 

but you could start by just removing the DSN=''.

[saeed]

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=Data.mdb");
    if(!db.open())
        qDebug() <<db.lastError();

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
    db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=Data.mdb");
    if(!db.open())
        qDebug() <<db.lastError();

To copy to clipboard, switch view to plain text mode 

I use this code and got my issue was resolved
Thank you for your assistance