Desktop Engine Installation Samples

The Consoledesktopengine sample demonstrates how to call either the Microsoft® SQL Server™ 2000 Desktop Engine (MSDE 2000) Setup or Microsoft Windows® Installer Setup to install an instance of the Desktop Engine.

The logic in Consoledesktopengine.cpp for using CreateProcess() to call the Desktop Engine Setup.exe illustrates the fundamental Desktop Engine-specific code that should be considered for an application wrapper installation program. This is the method new applications should use to install MSDE 2000.

The logic to call the Windows Installer Setup to install MSDE 2000 using a custom installation package file is provided only for existing applications that use this mechanism. This method should not be used for new applications. For more information on the issues involved with using customized installation package files, see Managing Desktop Engine Installation Package Files.

Default Location of C++ Files

C:/Program Files/Microsoft SQL Server/80/Tools/Devtools/Samples/Desktop

To run the sample

1. Copy the following files from the sample folder to a folder in your Microsoft Visual C++® include path: Sqlserror.h and Validateinstance.h.
   
   
2. Copy the following files from the sample folder to a folder in your Visual C++ library path: Sqldedev.lib and Desktopenginedeploy.lib.
   
   
3. Using Visual C++ version 6.0, open and run Consoledesktopengine.dsw to create an executable.
   
   
4. Copy the contents of the /MSDE/Setup folder on the SQL Server 2000 compact disc to the folder holding ConsoleDesktopengine.exe.

   Optionally, generate a custom Desktop Engine installation package file in the folder containing ConsoleDesktopengine.exe. For more information about generating a custom installation package file, see Managing Desktop Engine Installation Package Files.

5. Run ConsoleDesktopengine.exe.

Default Location of Sample .msi Files

The following Desktop Engine installation package files were originally provided as templates for users developing their own installation packages:

• Sample.msi

  Supports only new installations. This template does not support upgrading an instance of Microsoft Desktop Engine (MSDE) version 1.0.

• SampleUpg.msi

  Supports both new installations and upgrades.

Do not use either of these files to install new instances of MSDE 2000. Only use them to build patch files for applying the latest MSDE 2000 service pack to instances originally installed using these files. For more information about building patch files, see the readme file for the latest SQL Server 2000 service pack.

These files are not installed with MSDE. They are included with the other editions of SQL Server, such as SQL Server 2000 Developer Edition. If you installed the SQL Server sample applications when running SQL Server 2000 Setup, the files are located in the folder C:/Program Files/Microsoft SQL Server/80/Tools/Devtools/Samples/Desktop.

See Also

Installing Desktop Engine

Distributing the SQL Server 2000 Desktop Engine