Not able to open Microsoft Access file
-
Hello everyone i am using the following code to open the Microsoft Access file
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Access Driver(*.accdb)};FIL={MS Access};DBQ=C:\..\...\....\Database1.accdb");if(db.open())
qDebug() << "oK";
else
qDebug() << db.lastError();and i am getting the following error
QSqlError("0", "QODBC3: Unable to connect", "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified")
please help- Thanks in advance -
Hello everyone i am using the following code to open the Microsoft Access file
QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Access Driver(*.accdb)};FIL={MS Access};DBQ=C:\..\...\....\Database1.accdb");if(db.open())
qDebug() << "oK";
else
qDebug() << db.lastError();and i am getting the following error
QSqlError("0", "QODBC3: Unable to connect", "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified")
please help- Thanks in advance@rockon209 said in Not able to open Microsoft Access file:
ODBC Driver Manager] Data source name not found and no default driver specified
Sometimes Google is your best friend
Considering the relative path you are using that link will probably give a hint (found with the Google search above)
OK, just saw that your relative path might be a stripped down absolute path and trying to hide the details.
Checkout the details there. The db has to be there where you expect it.
Note: Single backslash are typically not a good idea in C/C++ and for absolute and relative file path, they are deadly. Use single forward slashes which are also supported by Windows and common on other OS.