The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine (Windows Server 2008 R2 (64) vs MS Office 2007) RRS feed

  • Question

  • We just have switched our local server from 32-bit to 64-bit machine and now we have Windows Server 2008 R2 Service Pack 1 with MS Office 2007. On server we are running an application in ASP.Net 3.5 using visual studio 2008. All users have 32-bit windows 7 and MS Office 2007.

    when user tries to import data from Excel to Database (SQL Server 2005), error comes as

    "microsoft.ace.oledb.12.0 provider is not registered on local machine".

    I have tried a solution by installing Access Database Engine 2007 Office System Driver on the Server, but the error was same. Now what should I do to resolve this problem??? Should we install Office 2010 64-bit on the Server or is there any other solution???

    Thursday, September 26, 2013 9:48 AM


All replies