Microsoft KB Archive/929320

= Cannot view a SharePoint Services 3.0 Web site after you migrate a Windows SharePoint Services 2.0 content database =

Article ID: 929320

Article Last Modified on 5/14/2007

-

APPLIES TO


 * Microsoft Windows SharePoint Services 3.0

-



SYMPTOMS
Consider the following scenario:
 * You upgrade a Windows SharePoint Services 2.0 server that includes the Office 2003 Web Parts and Components add-in to Windows SharePoint Services 3.0.
 * To make this upgrade, you use the database migration method to migrate the Windows SharePoint Services 2.0 content database to a new Windows SharePoint Services 3.0 environment.

In this scenario, you receive the following error message when you try to visit a Windows SharePoint Services 3.0 Web site:

Could not load file or assembly 'Microsoft.Office.DataParts, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified.

Additionally, you receive the following error message when you try to install the Office 2003 Web Parts and Components add-in on a Windows SharePoint Services 3.0 server:

You must install Windows SharePoint Services 2.0 before you install Office 2003 Web Parts and Components.



CAUSE
This issue occurs because the Office 2003 Web Parts and components are deprecated for Microsoft Windows SharePoint Services 3.0. However, you can still use the Office 2003 Web Parts and Components add-in when you upgrade a Windows SharePoint Services 2.0 server that has the Office 2003 Web Parts and Components add-in installed to Windows SharePoint Services 3.0.



WORKAROUND
Install the Office 2003 Web Parts and Components add-in on the Windows SharePoint Services 3.0 server.

Notes
 * Adding the Office 2003 Web Parts and Components add-in to a Windows SharePoint Services 3.0 server should be used as a temporary workaround only.
 * The Office 2003 Web Parts and Components add-in requires that the client computer that will modify the Web parts have either Office 2003 client applications or the Office 2003 Office Web Components add-in installed. Before you upgrade client computers to the 2007 Office system, phase out the Office 2003 Web Parts and Components add-in, and use alternative solutions. The client components for the Web parts that are included in Office 2003 are not included in the 2007 Office system.

To install the Office 2003 Web Parts and Components add-in, follow these steps:  Download the Office 2003 Web Parts and Components add-in. To do this, visit the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?familyid=38be67a5-2056-46a1-84b1-337ffb549c5c&displaylang=en

 Use a file-compression tool such as WinZip to extract the contents of the package that you downloaded. To do this, follow these steps:  Use the file-compression tool to open the Ststpkpl.exe package, and then extract the Ststpkpl.cab file from the Ststpkpl.exe package. Use the file-compression tool to open the Ststpkpl.cab file, and then extract the following files from the Ststpkpl.cab file to the root of the drive. For example, extract the files to drive C.  Gplib.cab_  Quickqt.Cab_  Microsoft_Office_DataParts.Cab_ </li></ul>

Note  is a four-digit number that represents the locale ID. For example, the locale ID may be 1033.</li> Rename the files that you extracted in step 2b to the following: <ul> Rename Gplib.cab_ to Microsoft.Sharepoint.Solutions.GreatPlains.cab</li> Rename Quickqt.CAB_ to Microsoft.Sharepoint.WebParts.QuickQuote.cab</li> Rename Microsoft_Office_DataParts.Cab_ to Microsoft.Office.DataParts.cab</li></ul> </li></ol> </li> Use the Stsadm.exe command-line tool to install the Office 2003 Web Parts and Components add-in. To do this, follow these steps: <ol style="list-style-type: lower-alpha;"> Click Start, click Run, type cmd in the Open box, and then click OK.</li> Type the following lines at the command prompt. Press ENTER after each line.

cd /d %commonprogramfiles%\Microsoft Shared\Web Server Extensions\12\Bin

stsadm.exe -o addwppack -filename :\microsoft.sharepoint.solutions.greatplains.cab -globalinstall -force -lcid LocaleID

stsadm.exe -o addwppack -filename :\microsoft.sharepoint.webparts.quickquote.cab -globalinstall -force -lcid LocaleID

stsadm.exe -o addwppack -filename :\microsoft.office.dataparts.cab -globalinstall -force -lcid LocaleID

</li> Type exit, and then press ENTER to exit the command prompt.</li></ol> </li> Restart Microsoft Internet Information Services (IIS) 6.0. To do this, click Start, click Run, type iisreset in the Open box, and then click OK.</li></ol>

<div class="moreinformation_section">

MORE INFORMATION
The Enterprise client access license (CAL) version of Microsoft Office SharePoint Server 2007 includes a technology called Excel Services that includes the following:
 * A server-side Excel calculation engine
 * The ability to enable browser-based worksheet viewing and an interactive Web service access to the spreadsheet calculation engine in Excel

Excel Services offers the following advantages over the Office 2003 Web Parts and Components add-in:
 * A server-side Excel calculation engine
 * More parity with Excel when worksheets are delivered over the Web
 * The ability to enable spreadsheets to be more scalable and stable when they are loaded onto a server
 * Improved security
 * The ability to perform more detailed analysis to improve overall business intelligence

<div class="status_section">

STATUS
This behavior is by design.

<div class="references_section">