Original address:
Http://blog.163.com/[email protected]/blog/static/10407267820111011150183/
Http://www.mycodes.net/78/6296.htm
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.
Proven method one is available.
Windows (64-bit IIS) does not register the "microsoft.jet.oledb.4.0" provider on the local computer