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

Question

I have Visual Studio 2010 Beta 2 and Access 2010 Beta installed on my computer

I have Windows 7 64 bit but i hope both vs 2010 and Access 2010 Beta are 32 bit guessing from their process name
(devenv.exe *32 and MSACCESS.EXE *32)

I installed 2010 Office System Driver: Data Connectivity Components 32 Bit
And still in my C# program, the statement

OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;" + @"data source=C:\insructionSet.accdb");

and conn.Open() produces the error

"The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine"
The database was created in Access 2010

In another C# program
private OleDbConnection conn = new OleDbConnection(@"Provider=Microsoft.JET.OLEDB.4.0;" + @"data source=C:\tax.mdb");

and conn.Open() works fine

Please Help

Answer 1

hi,
may be this post can help you out:
http://ybbest.wordpress.com/2009/07/22/the-microsoft-ace-oledb-12-0-provider-is-not-registered-on-the-local-machine/

---

Manish Patil http://patilmanishrao.wordpress.com Posting is provided AS IS with no warranties, and confers no rights.

Answer 2

Thanks. I have a 64 Bit Windows 7 and that was my problem. Solved. Thanks a lot

Answer 3

hi, i've the ame issue when i move my web app to the hosting website is there a  way i could add reference  so that it  would be included in  my bin folder to work on the Production Server?

Answer 4

hi, i've the same issue of "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine. windows 7". But Manishrao suggestion has solved this issue.Bundle ofThnx.