Chapter 4 Configuring Web Servers and Web sites

Configuring an ISAPI server

This section provides a detailed explanation of how to set up an ISAPI server to run with PowerDynamo. The required steps include:

1. Editing the System Path in the System Properties window
2. Installing the Application Server
3. Creating an ODBC System Data Source Name (DSN)
4. Creating a connection profile
5. Configuring the Application Server

IIS 4.0
If you have the Internet Information Server NT 4.0 option pack, see "Configuring an ISAPI 4.0 server".

The system path is automatically edited and the Application Server installed as part of the PowerDynamo installation procedure. These steps are not necessary if you configured the Web server during installation. You must still create an ODBC System Data Source Name, create a connection profile, and configure the Application Server.

For more information on configuring Web servers during installation see "Configuring Web servers during installation".

Editing the System Path in the System Properties window

You must edit your computer's system path to include the directory containing the DLLs.

Windows 95
If you are running Windows 95, edit the path to include the directory containing the new DLLs.

The DLL directory is added to the system path, not the user path. ISAPI servers run as Windows NT services on the NT operating system.

Installing the Application Server

You must install the Application Server software into a directory defined as executable by the Web server. Microsoft presets the InetPub\scripts directory as being executable. For this reason, Sybase recommends that you copy the appropriate DLLs to this directory.

• If you haven't done so already, install PowerDynamo onto the Web server machine using the standard software installation. This provides you with tools such as Sybase Central and the Dynamo Configuration folder.
• Copy the required DLLs into the InetPub\scripts directory on the Web Server machine.

The PowerDynamo Application Server for ISAPI Web servers includes the following files:

• dyisa03.dll
• dyhtml03.dll
• dydom03.dll
• dyscr03.dll
• dydbg03.dll (optional)
• dyxdb03.dll
• dyxdfl03.dll
• dys03ent.dll
• dycom03.dll (optional)
• dycls03.dll
• dyzip03.dll
• dyperf03.dll (optional)

• mthr110.dll
• plbr110.dll
• clbr110.dll

The following required Power++ runtime libraries are automatically installed into your Windows SYSTEM directory or your Windows NT system32 directory.

Using the ISAPI filter

dyisa03.dll provides translation capabilities so that users can enter a standard URL call (http://localhost/Site/Contents.stm) instead of the longer ISAPI call (http://localhost/Scripts/dyisa03.dll/Site/Contents.stm).

To load dyisa03.dll properly, you must create an IIS virtual directory, and set the ISAPI filter for PowerDynamo.

To create an IIS virtual directory

1. Start the Microsoft Internet Service Manger.
2. Right-click in the left pane of the Management Console, underneath the Default Web Site and select New | Virtual Directory.
3. Enter "Sybase" as the alias. Click Next.
4. Enter or browse to the path of your Dynamo win32 directory.
5. Select Allow Execute Access as the permission type and clear all the other boxes.

The virtual directory is now set.

To set the ISAPI filter DLL:

1. From the Management Console, right-click on your machine (directly beneath the Internet Information Server folder) and select Properties. Click Edit.
2. Select the ISAPI Filter tab, then click Add.
3. Enter "PowerDynamo" as the Filter Name, then enter the path to dyisa03.dll.
4. Restart the Microsoft IIS Server for these changes to take effect.

Creating an ODBC System Data Source Name (DSN)

An ODBC System DSN is the same as an ODBC DSN except that the System DSN is available to all users on a machine, including services.

   Note If you are connecting to a file-based Web site, or using an Open Client connection, this step is not necessary. If you are using Windows 95, create a data source; you do not need a system DSN.

To create an ODBC System Data Source Name:

1. Start the ODBC Administrator from the Utilities folder in Sybase Central.
2. Select the System DSN tab. Click Add.
3. From the Create New Data Source window, select the appropriate ODBC driver; for example, Adaptive Server Anywhere 6.0. Click Finish.
4. Enter the:
   
   
   • Data Source Name
   • User ID
   • Password
   • Database name
   • Database file
   
   
   Click OK.

Creating an ODBC data source to connect to an Adaptive Server Enterprise database
When you are creating an ODBC data source for an Adaptive Server database, the Select method must be set to 0 - Cursor for Dynamo to work. To set the Select method, choose the Performance tab from the ODBC Administrator | ODBC Sybase Driver Setup option.

To ensure that the ODBC data source is available:

1. If you are using Adaptive Server as the data server, ensure the appropriate client library software and ODBC driver have been installed.
2. If you are using Adaptive Server Anywhere as the data server, copy the Web site database file and transaction log file into an appropriate directory on the Web server machine, and ensure that the database engine together with the Adaptive Server Anywhere ODBC driver and its attendant libraries are accessible on the machine.
3. If you are using the Adaptive Server Anywhere network server as the data server, install the Adaptive Server Anywhere client together with the Adaptive Server Anywhere ODBC driver and its attendant libraries on the Web server machine.

Creating a connection profile

You should create a connection profile for your Web site to store connection information in the registry in encrypted form. This information is used by Sybase Central, the Personal Web Server, and the Dynamo Application Servers.

Note
If you are connecting to a file-based Web site, or using an Open Client connection, see "Creating a connection profile for your Web site".

To create an ODBC connection profile for your Web site:

1. From Sybase Central, select Tools | Connection Profiles.
2. Click New.
3. Enter a name for the connection profile, and select PowerDynamo from the list of available types. Click OK.
4. Select an ODBC data source from the drop-down list. If appropriate, enter a user ID and password, and any additional parameters and descriptions. Click OK to create the connection profile.

Configuring the Application Server

Once the site Web server receives an URL from a Web client, it passes it to the Dynamo Application Server, which locates and processes the document. You must add a mapping to the Application Server so it can locate the path to the document.

To add a new mapping using the Dynamo Configuration folder:

1. In the left pane of Sybase Central, open the Utilities folder.
2. In the right pane of Sybase Central, open the Configuration folder.
3. Double-click the Mappings folder.
4. Double-click Add Mapping.
5. Enter a URL prefix, the Dynamo site type, the resource to access on your machine, and the maximum size of the document cache.
6. Restart the server for these changes to take effect.

For a more detailed description of how to configure the Dynamo sites using Sybase Central and the Configuration folder, see "Configuring Web sites".

Copyright © 2001 Sybase, Inc. All rights reserved.