Error : microsoft.jet.oledb.4.0 provider is not registered on local machine

remya1000

Well-known member
Joined
Mar 29, 2007
Messages
122
Programming Experience
Beginner
i have an VB.Net 2003 Application Program that use MS Access, that works fine in Windows XP and Windows 7.

But when i create that same program to VB.Net 2005 Application Program that use MS Access.

it works fine in Windows XP.

but in Windows 7 it shows this error
microsoft.jet.oledb.4.0 provider is not registered on local machine

This is how i used to connect to OleDbConnection
VB.NET:
    Dim Path As String = "C:\Project"
    Private strConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                                     "Data Source=" & Path & "\Term.mdb"
    Private myConn As New OleDbConnection(strConn)

installed these in Windows 7
.Net Framework 1.1
.Net Framework 2.0
.Net Framework 3.5

if you have any idea, why it's showing this error in windows 7, can you please let me know.

Thanks in advance.
 
It's because Windows 7 environment is x64. need to change the compile options to x86.

My Project > Compile > Advanced Compile Options > Target CPU
 
Back
Top