The ' microsoft.ace.oledb.12.0 ' provider is not a registered on the local machine.

Unexpected error in Excel microsoft.jet.oledb.4.0 external database driver (1)

Yesterday update the system bug, it is said that Microsoft is going to do something

Delete the following update on the line:
Win7 KB4041678 KB4041681
SERVER R2 KB4041678 KB4041681
WIN10 KB4041676 KB4041691
SERVER KB4041691

A web system developed using C #, which has the ability to upload Excel reports, read data from Excel, and import into a database.

Starting from the end of October, the user reaction is not working properly, the following error message is reported:

Unexpected error from external database driver (1)

After checking, all batch import has this error, cannot import, so it is judged that the system environment on the server has changed.

Online query, is due to the October 10 Microsoft released a new patch, after hitting this patch, will affect the reading of Excel engine.

If you use "Provider=Microsoft.Jet.OLEDB.4.0" in your program, you will be affected.

Workaround:

1. Uninstall this patch

I---> Remove Programs from the Control Panel and did not find this patch.

2. Using the new engine

Program changed to "provider=microsoft.ace.oledb.12.0"

With this modification, I have two systems that are deployed on a and B servers, respectively.

1), a server, System environment win R2 64bit English,office 32bit

On this server, after the program updates, the bulk import is back to normal.

2), B Server, System environment win R2 64bit English,office 64bit

On this server, the bulk import is still not available after the program is updated. The following error message is reported:

The ' microsoft.ace.oledb.12.0 ' provider is not a registered on the local machine.

Check IIS that the use of 32-bit programs is already enabled in the application pool.

According to the online inquiry downloaded the new engine AccessDatabaseEngine.exe, this is suitable for 32-bit, and downloaded Accessdatabaseengine_x64.exe (for 64-bit).

Install AccessDatabaseEngine.exe, prompting the server that is currently installed with 64-bit office and cannot install this engine.

Install Accessdatabaseengine_x64.exe, can install normally, but use batch import, still error.

Reported error message: The ' microsoft.ace.oledb.12.0 ' provider is not registered on the local machine.

Considering that the Web program was developed in a 32-bit development environment, the 32-bit engine should be used.

Through the online query, the following method to install the AccessDatabaseEngine.exe for 32-bit, add parameter/passive, you can bypass the check server is currently 64-bit office check

Run--->cmd, enter the DOS command line and enter the AccessDatabaseEngine.exe folder as follows:

C:\xxx\accessdatabaseengine.exe/passive

Batch import job returns to normal after successful installation

In the Control Panel, view, after installation, the following conditions are present:

Solution: 1, the online program is: In the Control Panel > Programs > Programs and Features > Installed updates, find the corresponding two patches, to uninstall. Different systems corresponding to the different patches, for specific reference: HTTP://WWW.CNBLOGS.COM/NET-GOD/P/7661313.HTML2, Microsoft's solution is to download a new driver engine (Microsoft Access Database Engine redistributable), change provider=microsoft.jet.oledb.4.0 to provider=microsoft.ace.oledb.12.0. Reference: 1, Excel microsoft.jet.oledb.4.0 unexpected error 2 in external database driver (1), import table Prompt "Unexpected error in external database driver (1)" Resolution 3, unexpected error in external database driver (1) 2, Unexpected error from external database driver (1) 3, error in Windows update kb4041681-unexpected error from external dat Abase Driver (1)

The ' microsoft.ace.oledb.12.0 ' provider is not registered on the local machine.