Skip to main content


Fix for Datasheet View Issue / Error in SharePoint 2010

Issue: I have Office 2010 installed but when I try to open a list in Sharepoint Server 2010 in dataview I get the "datasheet component compatible with Sharepoint Foundation is not installed" error.

Resolution:  Try installing the 2007 Office System Driver: Data Connectivity Components after you have installed Office 2010 64-bit on the client machine. This should provide you with the edit in Datasheet functionality. Let us know how it works out.
Download : 2007 Office System Driver: Data Connectivity Components
Explanation: If you are experiencing an error in SharePoint 2010 as follows: "The list cannot be displayed in Datasheet View for one or more of the following reasons: - A datasheet component compatible with Microsoft SharePoint Foundation is not installed. - Your Web browser does not support ActiveX controls. - A component is not properly configured for 320bit or 64-bit support." I've compiled the following steps you can take from forums and articles around the web…

SharePoint 2010 installation - SQL Server version error.


SharePoint 2010 Config Wizard - SQL Server at XXX has an unsupported version 10.0.2531.0.Over the last few months I’ve been playing with the various versions of SharePoint 2010 BETA on Windows Server 2008 R2. Various hotfixes were required to get it installed and working but yesterday and today I’ve been installing the SharePoint 2010 RC and ran into a small issue with SQL 2008. I thought it made sense to blog about this particular issue so that I can refer to it in the future and if it helps out anybody else then great.

It seems that SharePoint 2010 RC doesn’t like certain versions of SQL 2008 Enterprise. This is the error I was running into immediately after installing SharePoint 2010 RC while attempting to run the SharePoint Products Configuration Wizard tool:
SQL server at SERVER_NAME has an unsupported version 10.0.2531.0. Please refer to “″ for more information on the minimum required SQL Server versions and how to download them.
In order to fix this I simply followed the link in the error message and then followed a child link to the following URL:
From here I was able to request the Cumulative update package 2 for SQL Server 2008 Service Pack 1 which contains almost twenty hotfixes. I had to supply my email address and within a few minutes was sent a link where I could download it. Once downloaded, unzipped (using the password that was emailed to me with the download URL) and installed, the server required a reboot after which I was able to continue running the SharePoint Products Configuration Wizard as expected.


Popular Posts