I use "microsoft.jet.oledb.4.0" in the Web app to connect to Excel files, import them to a database, and work in a Windows 2003+ Office 2007 environment, but in Windows R2 + office Beta, the error "The Microsoft.Jet.OLEDB.4.0 provider is not registered on the local computer"
The online solution is probably as follows, but it doesn't work:
Issues and workarounds to be aware of:
1.microsoft.jet.oledb.4.0 do not write miscrosoft.jet.oledb.4.0,;
2.Data source does not write "Data sourse",
3. Check if Office is installed
4. Reinstall the registration MDAC28.exe (usually in your installation directory or on the official website of Microsoft)
5. This may also occur if you are a 64-bit platform; Workaround: Build, configure manager, platform, click any CPU tab, new-New platform->x86
Because the program was originally in Windows 2003 is the line, the connection string itself should be correct, Office 2010 I installed, MDAC28 i downloaded, open execution when the decompression window is gone, do not know if there is no installation, and Microsoft official said MDAC28 support X86, Does not seem to support 64-bit systems, I am now a 64-bit system
-------
Resolved in the corresponding IIS application pool, set application pool default properties/General/enable 32-bit application, set to True.
It is estimated that the microsoft.jet.oledb.4.0,32 bit is already in Windows, but the application pool does not have a 32-bit program enabled by default, so the display does not have "microsoft.jet.oledb.4.0" installed.
Http://blog.crowe.co.nz/blog/archive/2007/04/16/728.aspx
The "microsoft.jet.oledb.4.0" provider is not registered on the local computer