Duwamish Books, Phase 3.5: VBA Setup and Source Code

Nate Woods
Summit Software Company

December 1999

Summary: Provides instructions for setting up Phase 3.5: VBA of the Duwamish Books sample application. Discusses system requirements, installing Phase 3.5 of Duwamish Books, the Microsoft Visual Basic for Applications (VBA) SDK, and the Phase 3.5: VBA patch. (3 printed pages)

Introduction

In Phase 3.5: VBA of the Duwamish Books sample application Microsoft® Visual Basic® for Applications (VBA), a rich customization tool, is added to the sample to provide customization in the middle tier Business Logic Layer (BLL).

Duwamish Books is an unsupported MSDN sample application. You can send us mail and we'll respond to what we can. However, please remember that this is only a sample—Microsoft technical support is not prepared to answer questions about Duwamish Books.

System requirements

The following are the requirements for running the Duwamish Books, Phase 3.5 sample application and are the only environments on which we tested the application:

• The clients. Microsoft Windows® 98 or Windows NT® version 4.0 (Server or Workstation) with Service Pack 3. The clients also require Microsoft Data Access Components (MDAC) 2.0, which is installed by the Duwamish Setup program if necessary.
  
  
• Middle-tier (server) components. Microsoft Windows NT 4.0 (SP3) and MTS 2.0, which comes with the Windows NT 4.0 Option Pack. (Download the Option Pack free from http://www.microsoft.com/ntserver/nts/downloads/recommended/NT4OptPk/default.asp.) The components also require MDAC 2.0, which is supplied with the application and installed by the Duwamish 4.0 Setup program.
  
  
• Database. Microsoft SQL Server™ 6.5.
  
  
• VBA 6.0 SDK. Phase 3.5 requires you to install the Microsoft VBA 6.0 SDK 6.1 or later on both the client and BLL machines.

  Note   You can install the full application (clients, components, and database) on one computer running Windows NT 4.0 SP3 (Server or Workstation) or Windows 2000, MTS 2.0, and SQL Server 6.5.

• Source code. Requires Microsoft Visual Basic® 6.0 Enterprise Edition with Service Pack 3.

Before you attempt to set up and deploy the sample, be sure to read the setup and deployment guide for Phase 3.5 of Duwamish Books.

Installing Duwamish Books, Phase 3.5: VBA

To install Duwamish Books, Phase 3.5: VBA

1. Download and install Phase 3.5 of Duwamish Books.
   
   
2. Test the Phase 3.5 installation to ensure it functions correctly before proceeding.
   
   
3. Download and install the VBA 6.0 SDK version 6.1 or later and ensure it functions correctly before proceeding.
   
   
4. Download and install the Phase 3.5: VBA patches over the Phase 3.5 installation.

The Duwamish Books sample download and installation

See the Phase 3.5 sample download page to download and install the sample setup files for Phase 3.5 of Duwamish Books.

To Install the VBA 6.0 SDK

The VBA 6.0 SDK version 6.1 or later must be installed on both the presentation tier and middle tier machines.

1. Download (MSDN Universal and Professional Subscribers only) or order the latest version of the VBA 6.0 SDK from http://msdn.microsoft.com/vba/isv/eval/evalcd.asp.
   
   
2. Install the Release version of the SDK on the presentation and middle tier machines.
   
   
3. Check that the SDK is installed correctly by running the sdinote.exe sample located in Samples\VB\SDI\Release.

Note   If you upgrade from version 6.1 of the VBA 6.0 SDK to a later version you must reinstall Phase 3.5: VBA of the Duwamish Books sample.

Installing the VBA patches to Phase 3.5 of Duwamish Books

Phase 3.5: VBA patches are available for the following components of Duwamish Books:

• The client applications
  
  
• The Business Logic Layer
  
  
• The database scripts
  
  
• The source code

Download the self-extracting file containing these four Setup programs.

For each of the components of Phase 3.5 of Duwamish Books, you must install the Phase 3.5: VBA patch for that component. When you run each patch, the patch will prompt you for the location of the Duwamish Books install and perform the installation. If you installed the Client Applications or the Business Logic Layer across different machines, you should install the corresponding patch on the machine the component resides on. As with the Phase 3.5 database script installer, the Phase 3.5 VBA patch only copies the database scripts over; it does not actually run them. To run the database scripts, run the build35v.bat file with the name of the Duwamish Books database as a parameter.

After these steps are completed, Phase 3.5: VBA of Duwamish Books will be fully installed.

Note   To compile the Duwamish Books, Phase 3.5: VBA source code, first register SrchItem.ocx, as described in the source code readme, and then compile or install the data access layer (DAL) on the target machine before attempting to compile the Phase 3.5: VBA source.

Windows 2000 Issues

Phase 3.5: VBA of the Duwamish Books sample has been tested on Windows 2000 Professional. When installing on Windows 2000 install SQL Server version 7.0, rather than version 6.5.