HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine"

The problem arises when you have your application compiled for AnyCPU Platform, you are running on a 64bit system and the installed ADO.NET provider (Microsoft ACE.OLEDB.12.0) is the 32bit version.



Fig. 1


To resolve the issue, you need 64-bit Windows along with 64-bit MS Office. And download and install "
Microsoft Access Database Engine 2010 Redistributable" from here: 


Another option is to deinstall the 32bit version and install the 64bit version of ACE from hereand then run you application as AnyCPU on 64bit systems. But this could be a nightmare for your deployment scenarios

But wait, there is a simple workaround to resolve the issue.

The simplest workaround is to change the Target Platform of your 64-bit application to 32-bit through Visual Studio menu

BUILD -> Configuration Manager -> Active Solution Platform -> x86

Fig. 2



Fig. 3


If the x86 option is not already there, then select NEW, name it x86, Copy Settings from AnyCPUand check Create new project platforms

Fig. 4


Enjoy the programming with this simple workaround.

Comments

  1. Unknown13 September 2014 at 22:28

    Does this work in a 32-bit computer?

    ReplyDelete
    Replies
    1. taimooradilbadshah19 September 2014 at 11:48

      If u have 32-bit computer, then the issue will NOT occurred as U have 32-bit version application and 32-bit version Microsoft.ace.oledb.12.0. :)

      Delete

Post a Comment

Popular posts from this blog

Data Bound Controls in ASP.Net - Part 4 (FormView and DetailsView controls)

FormView The FormView control is used to display a single record from a data source. It is similar to the DetailsView control, except it displays user-defined templates instead of row fields. Creating your own templates gives you greater flexibility in controlling how the data is displayed. The FormView control supports the following features: ·          Binding to data source controls, such as SqlDataSource and ObjectDataSource. ·          Built-in inserting, updating and deleting capabilities. ·          Built-in paging capabilities. ·          Programmatic access to the FormView object model to dynamically set properties, handle events, and so on. ·          Customizable appearance through user-defined templates, themes, and styles. Templates For the FormView control ...
Read more

JavaScript - ES2015 (aka ES6)

The ES2015 Since this long time passed between ES5.1 and ES6, the release is full of important new features and major changes in suggested best practices in developing JavaScript programs. To understand how fundamental ES2015 is, just keep in mind that with this version, the specification document went from 250 pages to ~600. In this blog, we describe the most important changes. Arrow Functions A new  this   scope Promises Generators let   and  const Classes Constructor Super Getters and setters Modules Importing modules Exporting modules Template Literals Default parameters The spread operator Destructuring assignments Enhanced Object Literals Simpler syntax to include variables Prototype super() Dynamic properties For-of loop Map and Set New String methods New Object methods Arrow functions Arrow functions since their introduction changed how most JavaScript code looks (and works). Visually, it’s a simple and welcome ...
Read more

The Clickjacking attack and X-Frame-Options

Clickjacking  Clickjacking is a type of “web framing” or “UI redressing” attack. What that simply means in practice is that: 1. A user (victim) is shown an innocuous, but enticing web page (think watch online video) 2. Another web page (that generally does something important – think add friends on social network) is layered on top of the first page and set to be transparent 3. When the user thinks they are clicking on the web page they see (video), they are actually clicking on the higher layered (framed) page that is transparent There are two main ways to prevent clickjacking: 1.     Sending the proper X-Frame-Options HTTP response headers that instruct the browser to not allow framing from other domains 2.     Employing defensive code in the UI to ensure that the current frame is the most top level window Using X-Frame-Options X-Frame-Options  originally invented by Microsoft for IE8, but supported by a number ...
Read more