Is it not possible to open M.S. access file?

rockon209

I tried what you suggested but getting the same error.

Yes the odbc is available and wroking.
and i just access the the file locally not via any server my file is in the same computer where i am writing the code

hskoglund

Hi, I googled a bit and found this thread

So if you do not have Microsoft Office installed you need to download the driver for MS Access .accdb files

Andy314

Indeed you must install the Access ODBC driver. The driver is independent from installed Office !
(Be aware Windows like to kill this driver after windows-update. So you must reinstall it sometimes.)

Then you must look in the ODBC tool from windows to find out the correct driver name. This is the correct for me (is not the same as you use):
"DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};"

rockon209

@hskoglund

i already tried downloaded and intalled the drivers, even though i have M.S Office installed on my computer. But getting the same error.

Andy314

Hi @rockon209
which Qt Version do you use?

rockon209

@Andy314
I am using Qt 5.7.0

Andy314

Hi @rockon209
the QtCompany had the idea to do not distribute the binarys for the ODBC driver anymore. That was in Version 5.5 and 5.6 I think. I initiated a discussion about it. The result was that the driver should be integrated again. I dont know if this is in 5.7 really the case.

Look if you have in the path like C:\Qt2\5.6\msvc2015\plugins\sqldrivers
the qsqlodbc files.

rockon209

@Andy314

yes the file is present in the path.

Andy314

Hello @rockon209,
oh I am happy :-)

Now your Problem:
It must work ! I use it since 1 year.

We must find the error systhematic.
First you should try a connection via the windows Windows-ODBC tool.
I there is something wrong we must not look on Qt.

rockon209

@Andy314
How to do that bcoz i new to this database access. I dont know how it works. Could you help me?

Andy314

Hi @rockon209

Search in Windows for "ODBC".
Open the Program, dont know the english name. Something like "ODBC-Datasource 32-bit"
Tabpage Drivers: Is there a entry like Microsoft Access Driver (*.mdb, *.accdb) ?

more later...

Devopia53

@rockon209

Hi.

Perhaps, you have a very minor problem.
Compare the connection strings below.

db.setDatabaseName("Driver={Microsoft Access Driver(*.mdb, *.accdb)}; DBQ=C:/MyFolder/Database1.accdb;"); // It's not OK!

db.setDatabaseName("Driver={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=C:/MyFolder/Database1.accdb;"); // It's OK!

The ODBC driver is installed by default on Windows.

rockon209

@Andy314

Yes entry is there in the Drivers Tab

@Devopia53
i tried it doest work same error again

Andy314

Jup, use exactly the name shown in the ODBC tool !!!!!

rockon209

ok thank you very much guys it worked i was not using the proper syntax.
Thank you very much.

Andy314

Go in the ODBC tool to the File-DSN tab.

Top right button like Add or Create new
choose the Access odbc driver -> click >>
as next set a filename -> click >>
next windows choose a *.accdb file
ready -> you have a DSN file which defines the connection.

I thought the ODBC tool has a function to test this connection directly, but it has not. So a file.dsn testing program would be nice ....
I found out a testing methode with Excel Data Tab->Extern Data -> Data connection Assistant -> ODBC DSN -> and choosed the pervious integrated dsn-file.

Nevertheless you should use the content of this file as the connect string in Qt.
only DRIVER and DBQ are important here.

and you should check in Qt:
```
bool ok=QSqlDatabase::isDriverAvailable("QODBC");
if(!ok)
{
ErrorMsg="No ODBC driver available!";
return 1;
}

konglyn

i guess your os is win7 x64 and you are using Qt 5.7 x64 with access 2013 x86
try installing access 2013 runtime x64 , you can download it from microsoft