I am doing a connection to the Access database, the program threw me a so bug--"not registered on the local computer" microsoft.et.oledb.4.0 ",
Ask the degree Niang, tell me may be the following factor:
One. " Set Application Pool Default Properties "/" General "/" Enable 32-bit application ", set to True. "(For installing IIS7.0 users)
I'm not a website, my concubine can't do it, Next
Two. Method two: Build, Configuration Manager, platform, click any CPU tab, new-new platform->x86. As shown in the following:
It is useful to mend or to be wooden! Go on
Three. My Excel is office2007, and "microsoft.et.oledb.4.0", only for versions below 2007, will be the original connection string: OleDbConnection cn = new OleDbConnection (" provider=microsoft.jet.oledb.4.0; Data source=e:\\works\\currentwork\\database\\idcardreaddb.mdb; "); Change to: OleDbConnection cn = new OleDbConnection ("provider=microsoft.ace.oledb.12.0; Data source=e:\\works\\currentwork\\database\\idcardreaddb.mdb; "); Then it throws down the "it brothers" appearance, "not registered on the local computer ' microsoft.et.jet.12.0 '", ouch, really call who work, who will resist!
Pass: Ensure that the prerequisites are as follows:
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 VS installation directory or up to Microsoft's official website)
Although I installed the AccessDatabaseEngine.exe, but my computer is 64 bit of worry, and from the Internet down a accessdatabaseengine (. exe), the wrong target has shifted,
Originally my office was installed by default 32-bit, had to uninstall, and then new install Accessdatabaseengine. exe, through, continue to install Office, success!
Remember: Be sure to install access well!
Finally, attach the relevant resources!
Accessdatabaseengine (+). exe Download:
Http://download.microsoft.com/download/7/0/3/703ffbcb-dc0c-4e19-b0da-1463960fdcdb/AccessDatabaseEngine.exe
Reference papers:
Http://www.cnblogs.com/jory/archive/2013/01/12/2857932.html
Https://www.kafan.cn/edu/84505296.html
More than one way, more than one possibility, even if some methods are not my bug medicine, thanks, teachable!
"The microsoft.et.oledb.4.0 provider is not registered on the local computer." "Large collection of solutions