How To Fix ‘Microsoft.Jet.OLEDB.4.0’ error

\r\n

Problem:

\r\n

\r\n

Server Error in ‘/’ Application.

\r\n

——————————————————————–

\r\n

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

\r\n

Description: An unhandled exception occurred during the execution of the current web request.

\r\n

Please review the stack trace for more information about the error and where it originated in the code.

\r\n

Exception Details: System.InvalidOperationException: The ‘Microsoft.Jet.OLEDB.4.0’

\r\n

provider is not registered on the local machine.

\r\nSolution:\r\n\r\nYou will get this error on Windows Server 2008 R2 or Windows 7 64 bit. To fix it, switch your Application Pool from Native 64 bit to 32 Bit more under Advanced Settings.\r\n\r\nSuggestion:\r\n\r\nIt is also suggested that you upgrade your application to new ACE OLEDB provider, you can download from here.

2 thoughts on “How To Fix ‘Microsoft.Jet.OLEDB.4.0’ error”

  1. Internet Explorer 9.0 Internet Explorer 9.0 Windows 7 x64 Edition Windows 7 x64 Edition
    Mozilla/5.0 (compatible; MSIE 9.0; Windows NT 6.1; Win64; x64; Trident/5.0; yie9)

    I can’t find ‘advance settings’ in visual basic 2010. Can someone give me a listing of steps so I can fix the

  2. Google Chrome 16.0.912.63 Google Chrome 16.0.912.63 Windows 7 Windows 7
    Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.7 (KHTML, like Gecko) Chrome/16.0.912.63 Safari/535.7

    You can change application pool to 32 bit mode from IIS Manager. \r\nClick on Start >> Control Panel >> Administrative Tools >> IIS Manager >> \r\nOR \r\nClick on Start >> type “Inetmgr” in search box and press enter >> Internet information services (IIS) manager window will open >> \r\nexpand your computer name in IIS manager >> Go to application pool >> select application pool (you configured for your website instance i.e. Default Application pool) >> Right click >> you can see advanced settings here >> click on Advanced settings here >> search for “Enable 32-Bit Applications” and change property value to “True”.\r\n\r\nAlso make sure you installed appropriate version of OLE DB drivers on your local system.\r\n\r\nThis should fix your issue.

Comments are closed.