ODBC driver for MS Access seems missing (Windows 64 bit)
I am simply trying to connect a java application to MS Access in the Eclipse IDE. From what I have read and done on other computers I need to go to the ODBC Data source administrator and add user DSN MS Access Database. The problem I have is that I recieve an error indicating that the ODBC Driver is not installed.
Now I assumed it would be as simple as downloading and ins开发者_Go百科talling it like say MySQL ODBC driver, this doesnt seem to be the case. From what I have read it is somthing to do with 32 and 64 bit windows 7 o.s.
I would appreciate if someone could identify the problem.
Thanks in advance
S
Could this help?
http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/685eacc1-a670-42d4-8392-924230fa90cb
solution found on this website: https://stackoverflow.com/questions/6721702/windows-7-64-bit-odbc-drivers-for-ms-access-missing
It's likely the shortcut for setting ODBC data sources is pointing to the 32bit data sources instead of 64bit.
Go to control panel -> administrative tools --> select data sources(ODBC) --> then right click on that file --> go to properties --> in the shortcut tab -> change the path from %windir%\System32\odbcad32.exe to
%windir%\SysWOW64\odbcad32.exe
and make your connection. the driver for MS Access will work fine now.
精彩评论