How to insert data in Microsoft Access file

[rockon209]

Hello Everyone,

How I can insert two columns in Microsoft access file. Users will enter the value in Qtextfield (for example name and age) and i want to store it in access database
Thanks in advance

[dheerendra]

There is no direct API available with Qt. Some third party C++ library may be available do this. You may check the same in Google.

[rockon209]

@dheerendra
I saw this in QT help but i dont know how to use it.
http://doc.qt.io/qt-4.8/qsqldatabase.html#addDatabase

...
db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb)};FIL={MS Access};DBQ=myaccessfile.mdb");
if (db.open()) {
// success!
}
...

[jsulm]

@rockon209 See here: http://stackoverflow.com/questions/22552302/how-to-use-m-s-access-in-qt

[rockon209]

@jsulm
I already saw this link but it doesnt work it still shows "Not ok"

[jsulm]

@rockon209 Try to use absolute path to the database file. Currently you're using a relative path:

DBQ=myaccessfile.mdb

try

DBQ=c:\\SOMEDIR\\myaccessfile.mdb

Also, you always should check the errors - it helps to find out what is the problem! See http://doc.qt.io/qt-5/qsqldatabase.html#lastError

[rockon209]

@jsulm
I am using the following code

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();

aand i got following the error
QSqlError("0", "QODBC3: Unable to connect", "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified")

[jsulm]

@rockon209 I'm not sure whether forward slashes are supported in this connection string, maybe you should try with back slashes:

db.setDatabaseName("DRIVER={Microsoft Access Driver(*.accdb)};FIL={MS Access};DBQ=C:\\...\\...\\....\\Database1.accdb");

Also is the path correct?

[rockon209]

@jsulm

I also tried with backslash but getting the same error and the path is also correct.