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

This is rather simple error to Fix if you are a developer and building small scale application.

Error comes becase you dont have Office 2007 installed on machine. Most of developers install it and goet going :)

Few other they go for http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en - Better way,

PROBLEM -

1. Lets say you are hosting your web site on shared host server. Hosting company may not install this Driver!!!!!

2. Another bigger problem, if your application is load balanced, how do you or hosting company know where to install this driver? On all nodes?

There is a intersesting solution to this problem, Cant share here. Hope microsoft will address this with MDAC and OS install :)