PowerShell – The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine

If you get this error

Exception calling “Open” with “0” argument(s): “The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine.”

image

Background
Microsoft OLEDB Drivers work on 32 or 64 bit architecture, running Windows XP, Vista, 7 or Windows 8.

Some of the drivers are only 32 Bit compatible ! like this above one.

Additionally on some Windows 64 bit systems, it is possible that some of the Microsoft OLEDB DLLs have not been registered.

Solution No. 1

Check that you are running the 32 bit PowerShell Console or ISE. In the past with Powershell v1.0 you could start it form here :

image

 

 

 

 

 

 

 

But later on after upgrading to v3.0 it disappeared.There are still 2 hints where you can see if you are running x64 or x86.After starting the ISE

image

you will see it here in the Title Bar it says … x86image

The command window you see the location SysWOW64

You can start it from here :

image

The Solution No. 2.
The solution is to manually register those DLLs.
go to Start->Run and type cmd
this starts the Command Prompt

Go to a special folder
cd c:\windows\sysWOW64

Now you need to register the OLE DB 4.0 DLLs by typing these commands and pressing return after each. Might be only the first 2 will register, no problem.

regsvr32 Msjetoledb40.dll
regsvr32 Msjet40.dll
regsvr32 Mswstr10.dll
regsvr32 Msjter40.dll
regsvr32 Msjint40.dll

http://support.microsoft.com/kb/278604

image

If errors appear.

Install AccessDatabaseEngine.exe from the MS site and try again.

http://www.microsoft.com/en-us/download/details.aspx?id=13255

x86 for MS Office x32 bit and

x64 for MS Office x64 bit

image

Hope this will help solving some frustrations.

Advertisements

One Response to PowerShell – The ‘Microsoft.Jet.OLEDB.4.0’ provider is not registered on the local machine

  1. varsha says:

    Thank You…

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: