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

by

I found a solution for this problem. The issue I described in my question occured basically due to the incompatibility of the Microsoft.Jet.OLEDB.4.0 driver in 64 bit OS.

So if we are using Microsoft.Jet.OLEDB.4.0 driver in a 64 bit server, we have to force our application to build in in 32 bit mode (This is the answer I found when I did an extensive search for this known issue) and that causes other part of my code to break.

Fortunately, now Microsoft has released a 64 bit compatible 2010 Office System Driver which can be used as replacement for the traditional Microsoft.Jet.OLEDB.4.0 driver. It works both in 32 bit as well as 64 bit servers. I have used it for Excel file manipulation and it worked fine for me in both the environments. But this driver is in BETA.

You can download this driver from Microsoft Access Database Engine 2010 Redistributable

More Related Contents:

  1. Reading excel file using OLEDB Data Provider
  2. OLEDB Parameterized Query
  3. OleDbParameters and Parameter Names
  4. File getting copied to SysWOW64 instead of System32
  5. Using a 32bit or 64bit dll in C# DllImport
  6. Options for using System.Data.SQLite in a 32bit and 64bit C# world
  7. Is there a “proper” way to read CSV files [duplicate]
  8. Why does Math.Exp give different results between 32-bit and 64-bit, with same input, same hardware
  9. Scientific notation when importing from Excel in .Net
  10. When reading a CSV file using a DataReader and the OLEDB Jet data provider, how can I control column data types?
  11. Understanding garbage collection in .NET
  12. Set object property using reflection
  13. How do I abort/cancel TPL Tasks?
  14. Cross-thread operation not valid [duplicate]
  15. How to read and modify NTFS Alternate Data Streams using .NET [closed]
  16. Are there any Fuzzy Search or String Similarity Functions libraries written for C#? [closed]
  17. How to wait for a BackgroundWorker to cancel?
  18. A property or indexer may not be passed as an out or ref parameter
  19. How can I embed an application manifest into an application using VS2008?
  20. Compare two Lists for differences
  21. difference between IComparable and IComparer [duplicate]
  22. Creating threads – Task.Factory.StartNew vs new Thread()
  23. How to Disable Alt + F4 closing form?
  24. How to check if a user belongs to an AD group?
  25. Update app.config system.net setting at runtime
  26. What are the advantages of delegates? [duplicate]
  27. Visual Studio 2015 RTM – Debugging not working
  28. What is System.Void?
  29. How to read last “n” lines of log file [duplicate]
  30. Generating sql code programmatically

Leave a Comment