[SQL Server] [Office] The "Microsoft. Jet. oledb.4.0" provider is not registered on the Local Computer

Microsoft. Jet. oledb.4.0 is not registered on the Local ComputerProgram

 

Environment: Window Server 2003 + iis6.0 + office2003

Development tools: vs2005

Language: C # Aspx. net2.0

Vs2005 developed the aspx Program (DOT net2.0) and encountered an error when accessing the Acess database. The "Microsoft. Jet. oledb.4.0" provider was not registered on the local computer.

The following is a process to solve this problem and post it for your reference:

 

1. Check whether the link string is correctly written ,"Provider= Microsoft.Jet. oledb.4.0; Data Source = database path"

The spelling is correct and the problem persists.

2. The registration component regsvr32 msjetoledb40.dll still exists.

 

3.reinstall mdac28.exe, but the problem persists.

 

The solution to this error on the internet is generally the above three methods. Where is my problem? Will it be a permission issue?

 

4. Open the Registry (Start Menu -- run -- Regedit) and search for "Microsoft.Jet. oledb.4.0", View permissions, and find that the iis_wpg permission is not read.

 

Therefore, "Microsoft.Jet. oledb.4.0.

Refresh the page and click OK .. Haha ..

After that: Do not give "Microsoft.Jet. oledb.4.0", Add the everyone read permission, and add the iis_wpg read permission only.