ODBC driver use in Qt

Question

Hi all,

I wanted to use read and write mdb file (Ms Access file) and I am completely new in using ODBC in Qt.

So can anyone help me to know whether should i need to download the drivers and if yes then from where can i download ? and if you know about connectivity then any help would be appriciated.

Answer 1

• You will get all the info for Driver you needed here

• Here is the complete example with explanation

Answer 2

If you need to access an MS Access database with Qt, you don't need (if I'm not mistaken) to install anything regarding drivers (everything should be already there).

You can connect to a database with a connection string. Something like this :

QSqlDatabase db = QSqlDatabase::addDatabase("QODBC");
db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DSN='';DBQ=C:\\path\\to\\mydatabase.mdb");
bool Success = db.open();