Connect to access data base in win32 and x64 with odbc driver

gemblev

Hello,

My Qt application designed on Win32 works fine to connect to an access database through odbc driver.
Since, I generated this application with x64, so it cannot connect with the access database.

versions

windows 7 pro
visual studio 2008
qt V4.6.2
toto.mdb is the access file generated by access 2003

The win32 configuration files :

odbccad32 in Windows\SysWOW64 with odbcad32 that drives Microsoft Access Driver (*.mdb) Version 6.01.7601.17632
odbc32.dll in Windows\SysWOW64 v6.1.7601.17514
odbcint.dll in Windows\SysWOW64 v6.1.7600.16385
The qt dll plugins is:
.\Debug\sqldrivers\qsqlodbcd4.dll

The x64 configuration files

I have installed Microsoft Access Database Engine 2010 Redistributable
odbccad32 in Windows\system32 with odbcad32 that drives Microsoft Access Driver (*.mdb, *.accdb) Version 14.00.4760.1000
odbc32.dll in Windows\system32 v6.1.7601.17514
odbcint.dll in Windows\system32 v6.1.7600.16385
The qt dll plugins is:
.\Debug\sqldrivers\qsqlodbcd4.dll
@QString dbName;
QSqlDatabase m_db;

m_db = QSqlDatabase::addDatabase("QODBC");
dbName = "DRIVER={Microsoft Access Driver (*.mdb)};DSN='';DBQ=toto.mdb";
m_db.setDatabaseName(dbName);
m_db.setConnectOptions("SQL_ATTR_ACCESS_MODE=SQL_MODE_READ_ONLY");

the source code
if(m_db.open())
{
qDebug() << "oK";
m_db.close();
}
else
{
qDebug() << m_db.lastError().text();
}@

Dll log is:

.\Debug\sqldrivers\qsqlodbcd4.dll is loaded
Windows\system32\odbc32.dll is loaded
Windows\system32\odbcint.dll is loaded

Error log is :

Error in french: [Microsoft][Gestionnaire de pilotes ODBC] Source de données introuvable et nom de pilote non spécifié QODBC3: Unable to connect
Error in english: [Microsoft] [ODBC Driver Manager] Data source name not found and no default driver specified.

Help please !

gemblev

I solved this problem, and now my application generated wih x64 connects to Access Data Base.

The name of the driver must be written exactly as you see on ODBC management: Windows\system32\odbccadd32. The ODBC driver for access shows : DRIVER={Microsoft Access Driver (*.mdb, *.accdb)

source code
@#ifdef _WIN64
dbName = "DRIVER={Microsoft Access Driver (*.mdb, .accdb)}'';DBQ=toto.mdb";
#else
dbName = "DRIVER={Microsoft Access Driver (.mdb)};DBQ=toto.mdb";
#endif@

The driver odbc for access x64:
http://www.microsoft.com/en-us/download/details.aspx?id=13255