Link to home
Start Free TrialLog in
Avatar of Anand Majmundar
Anand MajmundarFlag for India

asked on

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

Upgraded a working . NET 3.5 website on shared hosting to .NET 4.5 VPS. Getting the following error:


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







Avatar of gr8gonzo
gr8gonzo
Flag of United States of America image

This usually happens when you have 64-bit code that tries to access an Access database but you haven't installed the 64-bit Access drivers (or there is otherwise some mismatch). It's not the only possibility but the most common one, so first just download and install the redistributable from Microsoft:


https://www.microsoft.com/en-us/download/details.aspx?id=13255


You should get a 32-bit driver and a 64-bit one so make sure you install the one that matches the bitness of your website code.

Avatar of Anand Majmundar

ASKER

Thank you.

Meanwhile, my Web.Config has the following:

  <connectionStrings>
    <remove name="LocalSqlServer" />
    <remove name="LocalSqlServer" />
    <add name="LocalSqlServer" providerName="System.Data.SqlClient" connectionString="data source=103.133.214.169,1433;Initial Catalog=MyDB;Integrated Security=False;User=MyUsr;Password=MyPW" />
    <remove name="LocalMySqlServer" />
  </connectionStrings>

This worked fine in .NET 3.5 Shared Hosting. Now I am in .NET 4.5 VPS.

Any comments here?

ASKER CERTIFIED SOLUTION
Avatar of gr8gonzo
gr8gonzo
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial