The 'Microsoft.ACE.OLEDB.12.0' provider is not registered

Question

i have created a website on local when i run this on local it works but when i am trying to run this on erver it show following error.. The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine ...

Ravi Shekhar · Answer

Please install Access database engine from below link... http://www.microsoft.com/en-us/download/confirmation.aspx?id=23734 and write below connection string... string SourceConstr = @Provider=Microsoft.ACE.OLEDB.12.0;Data Source= + strfilename + ;Extended Properties= 'Excel 8.0;HDR=Yes;IMEX=1';

RIM Singh · Answer

already marked..

Ravi Shekhar · Answer

If my answer helped you please mark it as answer.

RIM Singh · Answer

thnx ravi installed the above exe on my server and do not need to change the connection strin i am working with same connection string.

RIM Singh · Answer

i had followed the link but in my application the any CPU is already selected.

Sanjeeb Lenka · Answer

check this link http://www.codeproject.com/Tips/417397/OLEDB-Provider-is-not-registered-on-the-local-mac h