Windows (64-bit IIS) does not register the "microsoft.jet.oledb.4.0" provider workaround on the local computer

Environment: Windows Server 2008r2 64-bit IIS Access 2003

Issue: Windows (64-bit IIS) does not register the "microsoft.jet.oledb.4.0" provider on the local computer

Solution: Search the Internet

In Windows 7 (32-bit) with the. NET developed Excel import datasheet feature, after testing everything is OK, site publishing moved to Windows Server 2008 (64-bit) on the unexpected, an error message, run the program, throw an exception: not registered on the local computer Microsoft.Jet.OLEDB.4.0 provider, engaged in long time, do not know what reason, and then searched a bit, only to find a solution to the problem is so simple:

One of the workarounds:

Compile project specifies target platform for x86 is over, cannot use any CPU

Build, Configuration Manager, platform-click any CPU tab, new-New platform->x86

Solution Two:

Set the application pool default properties/General/enable 32-bit application to true in the corresponding IIS application pool. Link: http://blog.163.com/[email protected]/blog/static/10407267820111011150183/

On the Internet, some say Office 2003 does not support 64-bit and the like is not credible ah

Windows (64-bit IIS) does not register the "microsoft.jet.oledb.4.0" provider workaround on the local computer