java 似乎缺少 MS Access 的 ODBC 驱动程序(Windows 64 位)

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/5474319/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-10-30 11:17:26  来源:igfitidea点击:

ODBC driver for MS Access seems missing (Windows 64 bit)

javams-accessodbc

提问by London Student

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.

我只是想在 Eclipse IDE 中将 Java 应用程序连接到 MS Access。根据我在其他计算机上阅读和完成的内容,我需要转到 ODBC 数据源管理员并添加用户 DSN MS Access 数据库。我遇到的问题是我收到一条错误消息,指出未安装 ODBC 驱动程序。

Now I assumed it would be as simple as downloading and installing 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.

现在我认为它就像下载和安装它一样简单,比如 MySQL ODBC 驱动程序,但情况似乎并非如此。从我读过的内容来看,它与 32 位和 64 位 Windows 7 操作系统有关

I would appreciate if someone could identify the problem.

如果有人能找出问题,我将不胜感激。

Thanks in advance

提前致谢

S

回答by nick

solution found on this website: https://stackoverflow.com/questions/6721702/windows-7-64-bit-odbc-drivers-for-ms-access-missing

在本网站上找到的解决方案: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.

设置 ODBC 数据源的快捷方式很可能指向 32 位数据源而不是 64 位。

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

转到控制面板-> 管理工具--> 选择数据源(ODBC)--> 然后右键单击该文件--> 转到属性--> 在快捷方式选项卡中-> 将路径从%windir%\System32 更改\odbcad32.exe 到

%windir%\SysWOW64\odbcad32.exe

%windir%\SysWOW64\odbcad32.exe

and make your connection. the driver for MS Access will work fine now.

并建立联系。MS Access 的驱动程序现在可以正常工作。