The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data) on a 2 node clustered env.

• Pyman

  SSChampion

  Points: 13830

  More actions

  February 13, 2012 at 12:42 pm

  #250627

  Hello Everyone,

  Hope all is well. This morning I run into a situation where I had to import more than 65535 number of records from an excel to a sql table. While importing I selected the excel version as Excel 2007 as the file is in .xlsx format. I got the below error:

  The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine. (System.Data)

  I found a resolution to fix it. That is to install the Microsoft Access Database Engine 2010 Redistributable from

  http://www.microsoft.com/download/en/details.aspx?id=13255

  But the issue is this is on a clustered environment. How am i going to install this as a service.

  If anyone has a solution for this please let me know.

  Thanks.

  “If your actions inspire others to dream more, learn more, do more and become more, you are a leader.” -- John Quincy Adams