OFFXPDEV: Setting Up the Workflow for SQL Server Client Components (293791)

MORE INFORMATION

To run and test Workflow Applications for SQL Server, including data access pages, on a computer that does not have the workflow developer tools installed, the client computer must meet the following system requirements:

• Microsoft Windows 98, Microsoft Windows Millennium Edition (Me), Microsoft Windows NT 4.0 with Service Pack 6a or later, or Microsoft Windows 2000 with Service Pack 1
  
  NOTE: Windows NT 4.0 SP6a and Windows 2000 SP1 are installed by the Windows Component Update during Microsoft Office XP Developer installation.
• Office XP Web Components (for Access 2002 data access pages)
• Microsoft Internet Explorer 5 or later
• Office 2000 Web Components (for Access 2000 data access pages)
  
  NOTE: Office XP Web Components and Office 2000 Web Components are installed by default when you install any Office XP Application.

To use data access pages with the Microsoft Office Developer Workflow Toolbar control as the Web-based user interface of your workflow application for Microsoft SQL Server, you must provide a way for users to set up the toolbar control on their computers.

The Microsoft Office Developer Workflow Toolbar control is packaged in a signed .cab file named modwc.cab. This .cab file is copied during setup of the Microsoft Office Developer Server Components to http://<servername>/modweb. A default Web page is created that installs the toolbar control on a user's computer automatically.

Manually Installing the Microsoft Office Developer Workflow Toolbar Control on Client Computers

After you have met the system prerequisites mentioned earlier in this article, follow these steps:

1. Open Microsoft Internet Explorer.
2. Browse to http://<servername>/modweb, where <servername> is the name of a server that has the SQL Workflow Services installed.
3. Click the Click here to automatically install the Workflow Toolbar on your computer hyperlink.

Note that the toolbar is white rather than gray, as indicated by the instructions on the page.

Programmatically Installing the Microsoft Office Developer Workflow Toolbar Control on Client Computers

To install the Microsoft Office Developer Toolbar automatically, manually set the CODEBASE property in the HTML source code.

1. Open the data access page in Design view.
2. Right-click the page, and then click Microsoft Script Editor.
3. Search for the following string:

   clsid:B50AC29D-6368-4B04-AFCE-1F7DA9B044E0

   It should look similar to the following:

   <OBJECT id=ActiveXCtl0 classid=clsid:B50AC29D-6368-4B04-AFCE-1F7DA9B044E0>

4. Add the CODEBASE property to the OBJECT tag, including the location of the Microsoft Office Developer Toolbar cab file (msowc.cab),which is typically stored in the modWeb virtual folder of the server that has Workflow Server for SQL Server installed. It should look similar to the following:

   <OBJECT id=ActiveXCtl0 CODEBASE="http://<servername>/modweb/modwc.cab" classid=clsid:B50AC29D-6368-4B04-AFCE-1F7DA9B044E0>

Alternatively, you can move the modwc.cab file to any other location, and then change the CODEBASE tag address accordingly.