Solution for “Microsoft. Ace. OLEDB. 12.0” provider not registered on local machine “

Time:2020-3-29

“The” “Microsoft. Ace. OLEDB. 12.0” “provider is not registered on the local computer, whether it is connected to an access database or a SQL Server database.” This problem has puzzled me for many years since office 2016.

My software version: win10 (x64) system + office 2019 (x64) software + Visual Studio 2019

It’s finally settled today.

Resolvent(two steps are crucial)

1. Install Microsoft Access 2010 database engine redistributable package

Download address: https://www.microsoft.com/zh-cn/download/details.aspx? Id = 13255

You are?64Bit Office, you will install accessdatabaseengine? X64.exe.

If you are a 32-bit office, you should install accessdatabaseengine.exe.

You can only choose one from the other. After you install one, you cannot install the other.

I’m 64 bit office. That must be to install accessdatabaseengine? X64.exe.

2. In visual studio, after you open a project / solution.

Solution Explorer in the upper right part of the software → select the project name → right click Properties → generate → target platformChange “any CPU” to “x64”(it can only be changed to x64, not other options.)

3. Rebuild, start the program, it’s all right.

Supplement:

About step 2

In fact, it can also be solved by changing the active platform of the solution to x64 platform (the target platform of the project will automatically change to x64)

In the upper right part of the software, “Solution Explorer” → select the solution → right click “properties” → click “configuration manager” → select “new” in the “active solution platform” drop-down list → select “x64” as the new platform, and keep the other defaults → click “OK” → regenerate the solution.

I started this article with Zhihu, and now I’m moving here.

I have learned a lot of knowledge in blog Park, and now I should make some contributions.

Recommended Today

Python basics Chinese series tutorial · translation completed

Original: Python basics Python tutorial Protocol: CC by-nc-sa 4.0 Welcome anyone to participate and improve: a person can go very fast, but a group of people can go further. Online reading Apache CN learning resources catalog introduce Seven reasons to learn Python Why Python is great Learn Python introduction Executing Python scripts variable character string […]