error in c#

[User3490]

hi i have error when i run my c# program. the error is : The Microsoft ACE.OLEDB.12.0 provider is not registered on the local machine. and i have access 2010 on my laptop. what is the solution for this error ?

[Lost User]

Install JET[^]. Make sure you install the correct version; you'd want the 64-bit version if your CPU (and app!) support it, otherwise the 32-bit version.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[User3490]

i have the correct version in my laptop. my laptop has 64bit cpu and i have install access 2010 64 bit

[Lost User]

..and your app? Set to 64-bit?

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[User3490]

yes my c# that i use in visual studio 2010 is 64bit. Basically the error is not my laptop in my laptop run ok. but when i try to run my c# setup program in another laptop that is also 64 bit appears the error message that i said in my previous message. Also we have the same programs access 2010 in 64 bit cpu. i don't understand what maybe be the problem..

[Dave Kreskowiak]

Huh?? There is no 64-bit version of JET. It's 32-bit only and was replaced by ACE. ACE comes in both 32- and 64-bit flavors.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak

[Dave Kreskowiak]

The problem is bitness. Either the target machine doesn't have 64-bit ACE (Access) installed, or your code is running as 32-bit, not 64. You cannot mix 32- and 64-bit code in the same process. You have to match the ACE bitness to your application, or the other way around. If the target machine has 32-bit Office (Access) installed and your app is compiled as x64 or AnyCPU running on a 64-bit machine, you'll get this message. If your code is compiled x86 only and there is only 64-bit Office (Access) installed, you'll still get this error.

A guide to posting questions on CodeProject[^]
Dave Kreskowiak

[Lost User]

Didn't know, thanks for the info :)

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^]

[Abhinav S]

Nice little tip here - OLEDB Provider is Not Registered on the Local Machine[^]. Should solve your problem most likely.

WP Apps - Color Search | Arctic | XKCD | Sound Meter | Speed Dial

[Anna King]

If you are using Visual Studio 2010, then the issue should not arise. Maybe some of the files are corrupt and that is causing the problem.

[User3490]

Hi Thanks all for your help. I found the problem rely on your advice. I changed the target platform from configuration manager to x64 bit and the problem solved. thank you again!!