Oledb 4.0 is not registered on the local machine (64 bit)

Question

I have created my setup in .net framework 2.0 and im using Windows 7 and its 64 Bit.Gives the error when i open the application Unhandled Exception:"Oledb 4.0 is not registered on the local machine"How to fix problem.(My works for 32 bit fine.. No problem)

Answer 1

I think the reason is that you're using Jet but there's no 64 bit version of Jet. The easiest way to fix this problem is to change your app to be compiled as 32 bit (in advanced compiler options I think).

Otherwise you might be able to do it by changing your code to use ACE instead (which is a continuation of Jet), but I'm not sure. You can find some details about Jet vs ACE in this Wiki article.