Gets an error from Vista x64

[svedel77]

Hi,

I'm getting af weird error, when I'm trying to make a basic database program. I should say, I'm a total newbie to .NET and databases, but I've followed the steps from a book. I should also say that I'm running Vista 64 bit. When I run the program, it doesn't show any records on the screen. And when I try to make a new records it makes the error "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.".

Searced the web, but didn't find much. Tried installing MS AccessDatabaseEngine.exe, rebooted, but that didn't work either. Some say it's because there's no drivers for 64 bit, and that I should set target cpu to "x86", but I can't find it anywhere in Express 2008.

I've made a video, that shows every step I make : www.pionersoft.dk/DbError

Best regards
Søren

[si_the_geek]

I think the Express Edition only lets you compile for the same bit level as the version of Windows you are using.

However, you probably don't need to use Jet, as there is a more modern provider for Access that can be used instead - you can download it from here. For the kind of connection string you need for it, see the link in my signature.

[svedel77]

Hi Si,

Thank you very much. Can I install my program on another computer, without installing your linked program on that other computer too? Thinking of going SQL... But a bit difficult as newbie...

- Søren

[si_the_geek]

Whatever database system you use, you will need to make sure the provider (and any other software your program needs, such as SQL Server Express) is installed - but you can usually include that as part of your programs setup package.

I know that Express has limitations for installation, but apparently you can include and install SQL Server Express (and the provider) by simply ticking a box while building the installation package. I'm not sure what options are available for other database systems such as Access.