'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine RSS

• • Reply
  

  aarsh

  Participant

  1547 Points

  435 Posts

  Re: 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine

  Dec 18, 2012 01:30 PM|LINK

  pranathis

   PC configuration 64 -bit formate and MS- Office formate is 32 - bit formate. And i install AccessDataBaseEnginee also 32 bit formate .

  Is it ok or any issue in that also

  Looks like you have not refered the link I provided:

  This link may be the all in one referance I think. ( http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/4fbd905f-f877-4bd9-b44c-97a61acd2b3f/#181ac1cb-134b-406a-be79-cfd089ce1461 )

  If you are experiencing : " <strong >The 'Microsoft.Jet.Oldedb.4.0' provider is not registered on the local machine." kind of error due your 64 bit machine, HERE IS THE SOLUTION ... !

  • please convert your Target Framework from "Any CPU" to "x86" in project properties and make sure the same by right clicking solution and going to "Configuration Manager" OR
  • Installing 2007 / 2010 Office System Driver: Data Connectivity Components (2007 / 2010 )

  With the 2nd alternative you may want to change  the Provider argument of the ConnectionString property to “Microsoft.ACE.OLEDB.12.0”.  (I had to do this)

  Resulting the Connection String to look like below:
  

  string strAccessConnectionString= @"Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data Source=C:\Database\TestDB.mdb;";

  • Edited by aarsh on Dec 18, 2012 01:31 PM
  • Edited by aarsh on Dec 18, 2012 01:31 PM
  • Edited by aarsh on Dec 18, 2012 01:33 PM
  • Edited by aarsh on Dec 18, 2012 01:33 PM