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

I have a problem with my application. When it starts, an error message is displayed

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

I tried to change the platform to the X86 processor, but it could not be changed, the only available option is any processor.

Please advise how to get rid of this error.

thanks

+7
source share
5 answers

the Jet.OLEDB.4.0 driver is used, which gives this error when working on a 64-bit system, it is better to install the new Microsoft Access Database Engine 2010 Redistributable driver

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

you will also need to change the link bar with "Provider = Microsoft.Jet.OLEDB.4.0;" on "Provider = Microsoft.ACE.OLEDB.12.0;"

link from my blog : 64-bit version of Microsoft.Jet.OLEDB.4.0 Office 2007/2010 Jet drivers

hope this helps.

+5
source

Open IIS Manager, select Application Pools , select the application pool you are using, click Advanced Settings in the right menu. In the "General" section, set "Enable 32-Bit Applications" to "True".

Now the x86 option will be visible and will create your application in this mode

+3
source

Access to the system is not installed. you need to install either the Microsoft office or access the database (which is free and much less) here is the link to install it for 2010 access:

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

+2
source

Microsoft.Jet.OLEDB.4.0 provider is not registered on the local computer

The RNT client is designed to run on 32 or 64-bit PCs running Windows XP, Windows Vista, Windows 7, or Windows 8 Pro, but on the 64-bit version of Windows XP (and possibly other operating systems) it is possible that some of Microsoft OLEDB DLLs are not registered.

Decision No. 1

The solution is to manually register these DLL files.

go to Start-> Run and type cmd this launches the command line (also available in Start-> Programs-> Accessories-> Command Prompt)

type cd \ and press return

The prompt should now appear C:\>

You need to go to a special folder that will look like

  • C: \ Windows \ system32
  • c: \ winnt \ system32
  • C: \ Windows \ SysWOW64

Try to enter each of them. If he says: "The system cannot find the path specified, try the next one," for example.

  • cd c: \ windows \ sysWOW64
  • cd c: \ windows \ system32
  • cd c: \ winnt \ system32

When one of them does not cause an error, stop, you have found the correct folder.

You need to register the OLE DB 4.0 DLL by typing these commands and pressing the return button after each

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

* Decision number 2 *

To fix this problem, open the project in Visual Studio, and then:

  • In Solution Explorer, right-click the project and select Properties
  • Go to the Assembly tab
  • Change target platform platform: any x86 processor
  • Recover your decision.
0
source

Reasons: Hosting the Asp.net application on a 64-bit machine. But our site refers to a third-party DLL, which is built on 32 bits. step-by-step solution Once I tried the whole solution, but I got stuck because I used the ODBC driver installed by OLEDB.

0
source

All Articles