Issue with SharePoint 2010 - Datasheet View

Issue with SharePoint 2010 - Datasheet View

When attempting to  view a list in Datasheet view, you receive  an error in SharePoint 2010 as displayed  below:

Cause

The ActiveX control for the Datasheet view is not compatible with Office 64-bit versions.

Resolution

If you are running Office 2010, 64-bit (with IE7 or IE8):
1. Make sure that your browser settings have the site in Trusted Sites in the Internet zone, and that ActiveX controls are enabled.
2. Install the 2007 Office System Driver: Data Connectivity Components.  Also see MS Knowledgebase article:  http://support.microsoft.com/kb/2266203

If you are running Office 2007:
1. Make sure that your browser settings have the site in Trusted Sites in the Internet zone, and that ActiveX controls are enabled.
2. Make sure that the Microsoft Office Access Web Datasheet Component and the Windows SharePoint Service Support options for Microsoft Office are installed. (Steps here). Also See MS Knowledgebase article: http://support.microsoft.com/kb/909506/en-us

Troublshooting SharePoint 2010 Installation Issue

During Configuration Wizard, in step 2 you normally got one of these errors

An exception of type System.IO.FileNotFoundException was thrown. Additional exception information: Could not load file or assembly ‘Microsoft.IdentityModel, Version 3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35′ or one of its dependencies. The system cannot find the file specified.

-OR-

An exception oftype Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly ‘System.Web.DataVisualition, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find thefile specified.

-OR-

Failed to create the configuration database.

An exception of the type Microsoft.SharePoint.SPException was thrown. Additional exception information: User cannot be found

If you got following error

An exception of type System.IO.FileNotFoundException was thrown. Additional exception information: Could not load file or assembly ‘Microsoft.IdentityModel, Version 3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35′ or one of its dependencies. The system cannot find the file specified.
 
Click on Finish.
 
Normally this problem occured because of Windows Identity Foundation pack was not installed. This can be fixed here: http://www.microsoft.com/downloads/details.aspx?FamilyID=eb9c345f-e830-40b8-a5fe-ae7a864c4d76&displaylang=en#filelist . Install this Identiry Foundation Pack and re-run the wizard again.
 
If you got following error
 
 

 
An exception oftype Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly ‘System.Web.DataVisualition, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find thefile specified.


Click Finish.

This problem occured becuase Chart Controls cannot be found or not installed, download it from here: http://go.microsoft.com/fwlink/?LinkID=122517

After installitig this chart control, re-run the wizard, you installation will run smoothly.

How to Install SharePoint 2010 on Windows 7

SharePoint 2010 (Foundation/Server) allows you to install it on windows 7 as single server environment for development purpose. Now whenever you try to install it, it gives you error "Setup is unable to proceed due to the following error(s): This product requires Windows Server 2008 (x64). Correct the issue(s) listed above and re-run setup.". To get rid this error and install SharePoint 2010 on Windows 7, follw the below mentioned steps:

1.Copy the installer(setup.exe) to your harddrive of installation (e.g. C:\SP2010)
2.Rename the installer to sp2010setup.exe
3.Extract the installation files by opening a Command Prompt (Run > CMD)
4.Type: C:\sp2010\sp2010setup /extract:c:\sp2010
5.This will extract the installer
6.Navigate in your Windows Explorer to: c:\sp2010\files\setup\config.xml
7.Edit this file in notepad and add the next line <Setting Id="AllowWindowsClientInstall" Value="True"/> just before the </Cofiguration> tag (Case sensitive)
8.Then Save the configuration file
9.Now check the required Windows Features are turned on, so go to Control Panel and select Turn Windows Features on or off, see below mentioned pictures and compare your machine windows feature and select those option which is not checked 

If you face any problem to fix Features, then run the following command in command prompt

start /w pkgmgr /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures;IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors;IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility;IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-HealthAndDiagnostics;IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-HttpTracing;IIS-CustomLogging;IIS-Security;IIS-BasicAuthentication;IIS-WindowsAuthentication;IIS-DigestAuthentication;IIS-RequestFiltering;IIS-Performance;IIS-HttpCompressionStatic;IIS-HttpCompressionDynamic;IIS-WebServerManagementTools;IIS-ManagementConsole;IIS-IIS6ManagementCompatibility;IIS-Metabase;IIS-WMICompatibility;WAS-WindowsActivationService;WAS-ProcessModel;WAS-NetFxEnvironment;WAS-ConfigurationAPI;WCF-HTTP-Activation;WCF-NonHTTP-Activation

1.Install SharePoint 2010 by running c:\sp2010\setup.exe as administrator
2.Choose the Standalone Installation (as I recommend) which will Installs SQL Server Express initially
3.After the installation is complete you, will be prompted to start the SharePoint Products and Technologies Configuration Wizard. Make sure Microsoft SQL Server 2008 KB 970315 x64 is installed Before starting the wizard.
3.You may need to install HotFix KB976462 available here  before running the configuration wizard.

What is the Hardware/Software Requirement for SharePoint 2010?

Microsoft SharePoint Server 2010 provides for a number of installation scenarios. Currently, these installations include single server with built-in database installations and single-server or multiple-server farm installations. For more information review following

http://technet.microsoft.com/en-us/library/cc262485(office.14).aspx

Sharepoint 2010 Release Date is Announced

Watch Stephen Elop, President of the Microsoft Business Division, announce the launch of Office 2010 and SharePoint 2010 on May 12, 2010 at 11 a.m. EST.

http://sharepoint.microsoft.com/businessproductivity/proof/pages/2010-launch-events.aspx#fbid=xgWGLbzp9iv