The 'Microsoft.Jet.OLEDB.4.0' provider is not registered on the local machine.
The reason for this error is, I used Jet database engine in my ETL component to read Excel file, but the Jet library was not designed for 64-bit system. The community has been suggesting to compile the code to target to x86 platform in order to cope with this issue, which is something I was reluctant to do for the obvious reasons. It's also the primary motivation that I am blogging about this issue.
Further Google search indicates that Microsoft has released a 64-bit compatible Jet database engine last year. The following is the procedure that you may use to fix this issue if you have:
- Download Microsoft Access Database Engine 2010 Redistributable (of course you'll need to choose the right bit for your server), and install it on your server
- Change your connection string in your code or configuration file from
After I have done the above, my ETL component worked fine on the 64-bit system.
Hope this helps if you ever run into this issue.