microsoft.oledb.12.0 not registered on local machine

Question

4.00/5 (1 vote)

See more:

hi
i'm running
os: sql server 2012 x64
sql server: microsoft sql server 2008 r2

i created an application in asp.net framework 4.0

when i try to import an excel file it is giving error

"microsoft.oledb.12.0 not registered on local machine"

i installed
http://www.microsoft.com/en-us/download/details.aspx?id=13255[^]
but it is still giving the error

please tell me which version of microsoft.oledb to install in the server

thank you

Posted 4-Oct-13 0:53am

write2varun

Updated 4-Oct-13 0:56am

v2

Add a Solution

Comments

Richard MacCutchan 4-Oct-13 7:12am

The message tells you which version to install, so you need to make sure you get the right one. Where does the message appear - server or client?

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sampath Lokuge · Answer 1 · 2013-10-04T00:58:00

Solution 1

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

http://social.msdn.microsoft.com/Forums/en-US/1d5c04c7-157f-4955-a14b-41d912d50a64/how-to-fix-error-the-microsoftaceoledb120-provider-is-not-registered-on-the-local-machine[^]

I hope this will help to you.

Posted 4-Oct-13 0:58am

Sampath Lokuge

Comments

write2varun 4-Oct-13 7:01am

i tried it's not working

Sampath Lokuge 4-Oct-13 7:02am

Have you tried with 2nd option also?

write2varun 4-Oct-13 7:06am

yes

Sampath Lokuge 4-Oct-13 7:12am

OK then,You have to remove previously installed components completely and restart the machine.After that try again for install "Microsoft Access Database Engine 2010 Redistributable
" component.Try it.May be some corruption of your installation caused for above error.

write2varun 4-Oct-13 7:25am

installed 3 times,restarted 3 times

write2varun 4-Oct-13 7:25am

no luck

Sampath Lokuge 4-Oct-13 7:27am

:(

Raja Sekhar S · Answer 2 · 2013-10-04T01:30:00

To check the driver is installed or not open ODBC Data Source Administrator
(ODBCADM.EXE or ODBCAD32.EXE)
(Start > Run > type ODBCAD32.EXE and hit enter) and check under the Drivers tab
Click the "Drivers" button
Choose the desired ODBC driver
Click the "About" button
Version information will be displayed for the selected driver.

Check This[^]

write2varun · Answer 3 · 2013-10-04T01:43:00

Solution 3

i installed 32 bit
its working

Posted 4-Oct-13 1:43am