microsoft.jet.oledb.4.0 is not registered in the local machine

Question

0.00/5 (No votes)

See more:

Hello,

I am working on a windows application with Ms access database(.mdb) and Visual Studio 2012,when first time i run the application error occurred says :

"microsoft.jet.oledb.4.0 is not registered in the local machine"

After seeing all previous post i resolved this error by make a change from AnyCpu to X86,then its working fine when i run in Visual studio .....

But..Now i created a setup and when i run the setup then same error occurred here on the developer PC.

PC configuration :

Windows 8,VS2012,64bit

Please let me know what to do here.

Posted 4-Jul-13 21:24pm

nehas1jan

Add a Solution

Comments

Richard MacCutchan 5-Jul-13 4:18am

Have you installed Jet on the target system?

nehas1jan 5-Jul-13 4:34am

I dont think so,i have MS Office only and i have installed Microsoft Access Database Engine 2010 Redistributable.

Let me know from where i can install Jet??

Richard MacCutchan 5-Jul-13 5:34am

You don't think so? Maybe it would be an idea to check first. If you want the latest version then you need to get it from Microsoft.

nehas1jan 5-Jul-13 6:11am

Please elaborate more ..!!

Richard MacCutchan 5-Jul-13 6:13am

What do you mean "elaborate"; what more information are you looking for?

nehas1jan 5-Jul-13 6:31am

It's working fin eon 32 bit pc what to do to make it compatible with the 64 bit?

Richard MacCutchan 5-Jul-13 6:42am

Jet is 32 bit only; you can only use it in 32 bit applications. However, such applications will run quite happily on 64 bit systems.

nehas1jan 5-Jul-13 6:46am

I am asking for the solution and suggestion to know how to run this on 64 bit PC ??

Richard MacCutchan 5-Jul-13 7:27am

And I just told you how: you must create it as a 32-bit application, which will run perfectly well on 64-bit hardware.

nehas1jan 5-Jul-13 7:33am

But Sir,here it's not working on 64 bit PC and occurs error while running setup.. :(

Richard MacCutchan 5-Jul-13 7:52am

Then you need to explain exactly what errors you are receiving and what code is causing them. Use the Improve question link above to add the details to your question.

nehas1jan 5-Jul-13 7:58am

Question is same sir, i explained things in detail there.

Dave Kreskowiak 5-Jul-13 10:10am

There is no "thinking" allowed in development and debugging!! You either KNOW for sure or you need to find out!

After reading this entire thread, you haven't told us anything about the error you're getting DURING your installation. "error occurs during setup". So what is it?

nehas1jan 5-Jul-13 13:33pm

Hi, Sir sorry for your inconvenience but i have mentioned the problem in the question title that is : microsoft.jet.oledb.4.0 is not registered in the local machine

Dave Kreskowiak 5-Jul-13 14:35pm

That's not normally an error you get as setup time.

That means either your code is running as 64-bit (Jet is 32-bit only and you cannot mix 32- and 64-bit code in the same process), either because you're app is compiled as x64 or AnyCPU.

Your setup is doing something database related through a custom action and your setup has 64-bit components in it. What you do to fix this we can't tell you because we have no idea what you did in your setup and what you used to build it.

nehas1jan 6-Jul-13 8:55am

Yes i do agree Sir, with the statement that we can not make mix 32 bit in 64 bit , but what to do here so that my app setup also can run on 64 bit??

1 solution

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)

Maciej Los · Answer 1 · 2013-07-05T10:03:00

Solution 1

Have a look at similar question: The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine[^] (solution 1).

[EDIT #1}
Interesting solution is here: Microsoft.ACE.OLEDB.12.0 Provider can no longer open .mdb under Windows 8[^]. It might be helpful ;)

Other interesting articles:
HOW TO: FIX ERROR - "the 'microsoft.ace.oledb.12.0' provider is not registered on the local machine[^]

How to get a x64 version of Jet?[^]

If above links are useless in your case, try to create setup project using alternative software, like: Inno Setup[^]
More free tools: Best Free Setup Builder[^]

Posted 5-Jul-13 10:03am

Maciej Los

Updated 7-Jul-13 1:28am

v2

Comments

nehas1jan 6-Jul-13 3:43am

I'v tried it before but not useful for me ,, because when i tried to install Ms office 2010 redistributeable 32bit after installation no effect generated on my application i mean error is same..but when i install 64 bit error occurred that my office is 32 bit and this installation can not be done in 64bit.

Maciej Los 6-Jul-13 8:31am

Interesting...
Have you tried solution3 from above link (manually register dll's)?

nehas1jan 6-Jul-13 8:53am

Hi,

You are right i tried,i changed the connection string "Provider=Microsoft.ACE.OLEDB.12.0;" but when i run that in my PC(64bit)same error(question Title)

Maciej Los 6-Jul-13 8:59am

Do not change connection string, try to manually register dll's for OLEDB 4.0 ;)

nehas1jan 6-Jul-13 9:12am

Oh yes, i tried error occure..

"Msjetoledb40.dll failled to load,make sure that binary is stored in specified path or debug it to check for problems or binary or dependent.dll files.The specified module could not found."

Maciej Los 7-Jul-13 7:28am

See my update answer ;)
Please, mark it as "solved" if it's helpful ;)