FILE: Ptssetup.exe Sample Automatically Downloads and Installs OLAP Client (312876)



The information in this article applies to:

  • Microsoft SQL Server 2000 Analysis Services

This article was previously published under Q312876

SUMMARY

The Ptssetup.exe sample shows you how you can automatically check for the existence of the current Microsoft Data Access Components (MDAC) version, and for the current version of the Microsoft OLAP Client Component, named PivotTable Services (PTS). This sample works on Microsoft Windows 9.x, Microsoft Windows NT 4.0, Microsoft Windows 2000 and Microsoft Windows XP Professional.

MORE INFORMATION

Use of Ptssetup.exe reduces the maintenance problem of making sure that all clients have the correct version of the OLAP client installed.

The Ptssetup.htm file first checks to see if MDAC 2.6 is installed. If MDAC 2.6 is not present on the computer, then Ptssetup.exe downloads the Ptsfull.exe application and executes Ptsfull.exe on the client computer. If MDAC 2.6 is present on the computer, but not the initial version of PTS, then Ptssetup.exe downloads and installs the PTslite.exe application.

The following file is available for download from the Microsoft Download Center:

Release Date: FEB-15-2002


For additional information about how to download Microsoft Support files, click the following article number to view the article in the Microsoft Knowledge Base:

119591 How To Obtain Microsoft Support Files from Online Services

Microsoft scanned this file for viruses. Microsoft used the most current virus-detection software that was available on the date that the file was posted. The file is stored on security-enhanced servers that help to prevent any unauthorized changes to the file.

The Ptssetup.exe file contains the following files:

FileSize
Cube.jpg59 KB
Ptssetup.htm5 KB

How to Setup Ptssetup.exe

  1. Unzip Ptssetup.exe and place the Ptssetup.htm and Cube.jpg files into a Web folder under INetPub\WWWroot.
  2. In the same folder you used in step 1, paste a copy of Ptsfull.exe and Ptslite.exe from the latest Service Pack or release. You can find Ptsfull.exe and Ptslite.exe in the Msolap\Install\PTS folder on the Microsoft SQL Server 2000 or Service Pack for Microsoft Analysis Services CD>
  3. For Microsoft Internet Explorer, copy Ptssetup.htm.

Modifications

You can modify the script in the Ptssetup.htm page to check for different versions of MDAC or the OLAP client by modifying the following lines:

NOTE: The following line checks for MDAC 2.60. However, if you modify "#Version=", you can have the program check for a different version of MDAC.
document.all.installPTS.outerHTML = "<OBJECT id=installPTSFull classid=\"CLSID:00000514-0000-0010-8000-00AA006D2EA4\" style=\"display=none\" codebase=\"ptsfull.exe#Version=2,60,0,0\"></OBJECT>"
				
The following line checks for version 8.0.167, which is the initial release of the OLAP client. If you change "#Version=" to 8,0,3,84, the program checks for the SP1 version of PTS:
document.all.installPTS.outerHTML = "<OBJECT id=installPTSlite classid=\"CLSID:a07ccd0c-8148-11d0-87bb-00c04fc33942\" style=\"display=none\"    codebase=\"ptslite.exe#Version=8,0,1,67\"></OBJECT>";
				

Modification Type:MinorLast Reviewed:8/9/2004
Keywords:kbdownload kbfile kbinfo KB312876