Question "The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."

[Lums]

"The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine."

Im using windows 7 home premium 64bit how do i resolve this issue

 

[JuggaloBrotha]

Set your project's compile option to x86 instead of 'Both'. There isn't a 64Bit Jet provider available so your app needs to run in 32Bit mode, even on 64Bit comps.

 

[Lums]

how do i go about doing that, im using Visual Basic Express 2008 by the way

 

[JuggaloBrotha]

Ah, Visual Basic Express I had a fear that would be the case. You wont be able to do this using the IDE because that's one of the things they took out. Make sure VS is closed and right click the project file (*.vbproj) in windows and open it with notepad, it's a plain text xml file.

Under the

<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
</PropertyGroup>

and

<PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Release|AnyCPU' ">
</PropertyGroup>

groups add this:

<PlatformTarget>x86</PlatformTarget>

Now open the project in VS and try running it.

 

[Lums]

still no luck

 

[JuggaloBrotha]

Try these suggestions (the 2nd post in particular) VB Express target x86 Platform?

 

[Lums]

brilliant man it worked thanks alot

 

[JohnH]

Thread split to http://www.vbdotnetforums.com/oledb/40321-search-database.html Start new threads for new topics.

Visual Basic Express I had a fear that would be the case. You wont be able to do this using the IDE because that's one of the things they took out.

As the post you linked to shows that is not the case, it is just more hidden in Express (or is it? I can't recall Config Manager begin hidden in VB 2008 Express).