操作系统是Windows 7 64位时，如何更改ODBC数据源管理员的路径 [英] How do I change the path of ODBC data source administrator when OS is windows 7 64 bit

问题描述

亲爱的，



我升级了我的电脑，现在我有64位Windows 7。以前，我有Windows XP Service Pack 3.



我安装了相同的visual studio 2008，我正在使用MS Access数据库。当我试图通过数据源ODBC连接数据库>使用SysWOW64的ODBC Data Sourse Administrator在V. S. 2008中给出了Microsoft.ACE.OLEDB.12.0提供程序未在本地计算机上注册的错误。我可以在odbc数据源管理员看到所有的数据库，但它显示相同的错误。



i尝试更改自定义跟踪DLL中的跟踪选项卡中的路径但是之后单击应用或确定，更改不会生效并保持与System32相同而不是SysWOW64。



我该怎么办？我应该用32位重新安装操作系统吗？

请帮助...



提前感谢。



Mayank



我的尝试：



谷歌搜索但没有成功。发现这么多解决方案，但没有人为我工作。

dear all,

i have upgraded my computer and now i have windows 7 64 bit. previously, i had windows xp service pack 3.

i have installed the same visual studio 2008 and i am using MS Access database. when i tried to connect the database through Data Source ODBC > ODBC Data Sourse Administrator with SysWOW64 it give an error in V. S. 2008 that "The Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine". i can see all the database are there in odbc data source administrator yet it shows the same error.

i tried to change the path in Tracing tab at Custom Trace DLL but after click Apply or ok, the change does not take effect and remains the same as System32 and not SysWOW64.

what should i do? should i reinstall the OS with 32 bit?
please help...

thanks in advance.

Mayank

What I have tried:

Googling but not succeeded. found so many solutions but no one is working for me.

推荐答案

如果你在64位系统上使用32位局，不太清楚如何访问数据库并且正在创建一个带有ODBC连接管理器的DSN，您需要运行32位版本的Odbcad32.exe，控制面板中的一个将是64位版本，并且注册表项存储在每个版本的不同位置。



您可以从MS下载ACE OLEDB 12文件并将其与您的应用程序一起安装，或者在没有Office模块的情况下使用OLEDB，结果是相同的，但您不需要安装Office或模块。



下载Microsoft Access数据库可从Microsoft官方下载中心重新发布的引擎2010 [ ^ ]



很多e xamples在线如果您搜索OLEDB和Access数据库但只是一个简单的连接字符串;

Not quite clear on how you access the database, if you are using 32 bit office on 64 bit system and are creating a DSN with ODBC connection manager you need to run the 32 bit version Odbcad32.exe, the one in control panel will be the 64 bit version and the registry keys are stored in different locations for each version.

You can download the ACE OLEDB 12 file from MS and install it with your application or use OLEDB without the Office module the result is the same but you do not need Office or the module installed.

Download Microsoft Access Database Engine 2010 Redistributable from Official Microsoft Download Center[^]

Lots of examples online if you search for OLEDB and Access database but a simple connection string;

"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=your database file name here;"

这篇关于操作系统是Windows 7 64位时，如何更改ODBC数据源管理员的路径的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！