“Microsoft.jet.OLEDB.12.0”提供程序未在本地计算机上注册。 [英] The 'Microsoft.jet.OLEDB.12.0' provider is not registered on the local machine.

问题描述

我的程序中使用的连接字符串是---

Dim NewStr As String =" Provider = Microsoft.ACE.OLEDB.12.0; Data Source = | DataDirectory | \" &安培; myDB& " ;; Persist Security Info = True; Jet OLEDB：Database Password =" &安培; myPwd





程序设置在32位操作系统中工作正常..

但是没有工作64位操作系统。它显示错误消息为 - Microsoft.jet.OLEDB.12.0提供程序未在本地计算机上注册。

仅在安装64位访问数据库引擎后才能工作。



是否有任何方法可以在32位和64位操作系统中进行设置。

请帮助...

connection string used in my program is---
Dim NewStr As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\" & myDB & ";Persist Security Info=True;Jet OLEDB:Database Password=" & myPwd


the program setup is working fine in the 32 bit os..
but not working in 64 bit os. it shows the error msg as- The Microsoft.jet.OLEDB.12.0 provider is not registered on the local machine.
it works only after installing the access database engine 64 bit.

is there any way to make a setup which work in both 32 bit as well as 64 bit os.
please help...

推荐答案

您需要将项目配置为编译并专门针对32位。通过进入项目属性，编译选项卡，然后单击高级编译选项按钮来执行此操作。在高级编译器设置中找到目标CPU并将其设置为x86。



或者如果我误解了你的问题，你可以尝试一些these [ ^ ]解决方案。

You need to configure your project to compile and specifically target 32 bit. Do this by going into your Project Properties, the Compile tab, and click the Advanced Compile Options button. In the Advanced Compiler Settings find the Target CPU and set it to x86.

Or if I'm misunderstanding your problem, you could try some of these[^] solutions.

问题是你没有64系统上安装了-bit ACE提供程序。显然，目标系统只安装了32位版本，可能来自32位的Office安装。



您可以获得64位版本的ACE来自此处 [ ^ ]。当你在其上安装你的应用程序时，必须在系统上安装它。



您也可以同时选择32位和64位ACE安装程序，因为您的应用程序可能会运行到根本没有安装Office的系统，并且仍然需要为您的应用程序安装正确的ACE提供程序，具体取决于系统体系结构，32位或64位。

The problem is that you don't have a 64-bit ACE provider installed on the system. Apparently, the target system only has the 32-bit version installed, probably from a 32-bit installation of Office.

You can get the 64-bit version of ACE from here[^]. This will have to be installed on the system at the time you install your app on it.

You may as well pick up both the 32-bit and 64-bit ACE installers since your application may run into a system where Office isn't installed at all and will still need to install the correct ACE provider for your application, depending on the system architecture, either 32- or 64-bit.

hi


你可以试试这个



右键点击你的解决方案并点击属性



在配置属性中



选择要运行应用程序的平台

喜欢x86或任何cpu。



并建立你的项目。



试试这个



i希望它能帮到你。

hi
You can try this

Right click on your solution and click on properties

In configuration properties

Select Platform which you want to run your application
like x86 or any cpu.

And build your project.

try this

i hope it will help full for you.

这篇关于“Microsoft.jet.OLEDB.12.0”提供程序未在本地计算机上注册。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！