How can i use microsoft access database in Qt?

[pratik041]

I was trying the following but i get (success = false.)
@ QSqlDatabase db = QSqlDatabase::addDatabase("QSQLITE");
db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=C:/Users/pratik041/MyDocuments/pratik.accdb");
bool Success = db.open();
qDebug()<<Success;
@ what may be wrong in this?

[dangelog]

The fact that you're trying to use the Sqlite driver with an ODBC handle?

[pratik041]

[quote author="peppe" date="1324924360"]The fact that you're trying to use the Sqlite driver with an ODBC handle? (hint, ihnt)[/quote]
but if i am using QODBC driver it is showing the driver is not loaded.

[Rahul Das]

@QSqlDatabase::isDriverAvailable("QODBC")@

will help you to make sure if ODBC driver is 'really' there.

[pratik041]

I have checked. It is not available. So what i have to do now?

[Rahul Das]

Build the ODBC plugin.

EDIT : you can start here : http://developer.qt.nokia.com/doc/qt-4.8/sql-driver.html#how-to-build-the-odbc-plugin-on-windows

[pratik041]

where I have to write that in command prompt in the project or any other place?

[Rahul Das]

startmenu -> All Programs -> Qt SDK -> Desktop -> cmd