Skip to main content

"Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" Error on Windows 7 (64-bit) + Office 2010 (64-bit) + Visual Studio 2010

If you use

(1) Windows 7 (64-bit), and
(2) Office 2010 (64-bit), and 
(3) Visual Studio 2010

to write an ASP.NET code to connect to Access or Excel database using the Microsoft.ACE.OLEDB.12.0 provider

and

consistently get the "Microsoft.ACE.OLEDB.12.0 provider is not registered on the local machine" error,

try installing the 2007 Office System Driver: Data Connectivity Components, which is basically a Microsoft Access Database Engine 2007 Redistributable for Windows (32-bit) from

http://www.microsoft.com/download/en/details.aspx?id=23734

Many forums suggested by Google Search suggest installing the Microsoft Access Database Engine 2010 Redistributable for Windows (32-bit, 64-bit) downloadable from

http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=13255

but it wouldn't help because Visual Studio 2010 is a 32-bit application; what you need is a 32-bit Data Connectivity component. The 2010 download will not allow you to install its 32-bit component over an existing 64-bit installation of Office 2010. Its 64-bit component wouldn't help either.

Thanks to

http://stackoverflow.com/questions/9654399/everything-is-64-bit-yet-visual-studio-still-shows-microsoft-ace-oledb-12-0-not

for the clue!

Comments

Post a Comment

Popular posts from this blog

iTunes: Error 261 while Burning Data CDs/DVDs

Apple Discussions: 261 error while burning MP3 CD. I usually put an aphostrophe (') in the name of playlists and was having error 261 burning CD/DVD data discs since iTunes 5.1. Upgrading to iTunes 6.0 for Windows doesn't help. I was burning a music DVD this morning and had Error 261 again. So I went to Apple iTunes Discussions site and look for a thread on this. Viola! There are many people having the same problem as mine. The thread ends at a point where someone removing ampersands, the '&' symbols, from their playlists and could avoid this error. I tried removing aphostrophes from the name of my playlist because aphostrophe falls into the kind of non-alphabet characters that needs escaping in some programming languages. It works!! Keywords: itunes , windows
17 comments
Read more

Microsoft Office Outlook Connector 12.1 Beta 2 Crashes Thai Language Input in Outlook 2007

It's been more than a year since I last blogged. I've been busy with work and also don't know what to blog. Here comes my new findings: Microsoft Office Outlook Connector 12.1 Beta 2 + Outlook 2007 + Thai Language Input = CRASH This has also been proven here . I downloaded the Outlook Connector the other night for improved supports to Windows Live Hotmail -- only to find that whenever I start typing e-mails in Thai, i.e., hit the "language switch" key Outlook simply crashes! I googled for " outlook 2007 crash language switch " this morning and find someone having the same Outlook Connector insta.led and the same problem as mine. So, Outlook Connector is most likely the cause of trouble. I uninstalled Outlook Connector this morning and, yes, typing in Thai doesn't crash Outlook 2007 anymore! Keywords: Outlook , Thailand , Troubleshooting
5 comments
Read more

MPICH2: mpdboot failure due to conflicting /etc/hosts entry

One single line in the /etc/hosts file on my Ubuntu Linux machine wasted my precious whole afternoon. I had some assumptions about the cause of this problem but I don't want to spend too much time investigating on what really caused the trouble. Anyway, here are the listings of what worked and what didn't: /etc/hostname ubuntu mpd.hosts.cluster master worker-01 Bad /etc/hosts 127.0.0.1 localhost localhost.localdomain ubuntu 192.168.200.128 master 192.168.200.129 worker-01 Result thitiv@ubuntu:~$ mpdboot -n 2 -f mpd.hosts.cluster thitiv@master's password: mpdboot_ubuntu (handle_mpd_output 359): failed to ping mpd on master; recvd output={} Good /etc/hosts 127.0.0.1 localhost localhost.localdomain 192.168.200.128 ubuntu master 192.168.200.129 worker-01 Result thitiv@ubuntu:~$ mpdboot -n 2 -f mpd.hosts.cluster thitiv@worker-01's password: thitiv@ubuntu:~$ At this point, with the /etc/hosts now fixed, the MPICH2 cluster could be booted up successfully. I don't want t...
8 comments
Read more