"Microsoft.Jet.OLEDB.4.0" is a database interface driver that is used to connect to a database and is typically used for even access and Excel.
when I was developing WinForm, I did not have a problem running locally, but I was deployed to another server with the error "microsoft.jet.oledb.4.0 is not registered on the local computer".
issues and workarounds to be aware of:
1.microsoft.jet.oledb.4.0 do not write miscrosoft.jet.oledb.4.0,
2.data source do not write "Data sourse ",
3. Check if Office is installed
4. Reinstall the Registration mdac28.exe (usually in your installation directory or up to Microsoft's official website)
5. If it is a 64-bit platform, this situation may also occur; Workaround: Build, Configuration Manager, platform, click any New platform->x86
6, CPU tab, new. If you are a web-side program, you can configure it through the application pool for IIS. Enable 32-bit application enabled
I found that my symptoms met fifth, and after compiling the program into 64 bits, I found that the problem was still there.
But then I tried to change 4.0 to a higher version of the 12.0 problem resolution.