@manhnguyenv

Welcome to my blog!

Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine

May 19, 2017 13:03

Error/Problem/Issue:

Microsoft.Jet.OLEDB.4.0 provider is not registered on the local machine

 

Solution/Resolve:

I found a solution for this problem. The issue I described in my question occured basically due to the incompatibility of the Microsoft.Jet.OLEDB.4.0 driver in 64 bit OS.

So if we are using Microsoft.Jet.OLEDB.4.0 driver in a 64 bit server, we have to force our application to build in in 32 bit mode (This is the answer I found when I did an extensive search for this known issue) and that causes other part of my code to break.

Fortunately, now Microsoft has released a 64 bit compatible 2010 Office System Driver which can be used as replacement for the traditional Microsoft.Jet.OLEDB.4.0 driver. It works both in 32 bit as well as 64 bit servers. I have used it for Excel file manipulation and it worked fine for me in both the environments. But this driver is in BETA.

You can download this driver from Microsoft Access Database Engine 2010 Redistributable

 

or https://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=23734

No such host is known

May 17, 2017 13:22

Type: System.Net.Sockets.SocketException

Message: No such host is known

Detail:

System.Net.Sockets.SocketException (0x80004005): No such host is known
at System.Net.Dns.InternalGetHostByAddress(IPAddress address, Boolean includeIPv6)
at System.Net.Dns.GetHostEntry(String hostNameOrAddress)
at BulletWeb.Controllers.HomeController.VB$StateMachine_3_Main.MoveNext()

 

The SqlParameter is already contained by another SqlParameterCollection

May 16, 2017 17:27

System.ArgumentException: The SqlParameter is already contained by another SqlParameterCollection

Categories

Recent posts