Prerequisites

• Citrix Presentation Server 3.0 / 4.0
• Resource Manager Summary Oracle Database
• Oracle 9i
• IIS 5.0 or later

How to use Resource Manager Web Console 4.1 for Oracle

1. Log on with Oracle SQL and the utility program. Use the same Oracle account for you Resource Manager Summary Database.
   Example
   User Name: system
   Password: mypassword
2. Run the SQL script to create the packages in your SQL Resource Manager Summary Database @Path\packages.sql
   Example
   @c:\packages.sql
3. Create a System DSN on your IIS Web server that points to your Resource Manager Summary Database using the Microsoft ODBC for Oracle driver. DO NOT USE THE ORACLE DRIVER.
   1. Use the Data Source (ODBC) tool to create a system DSN. Name the DSN RM RMWEBDSNORACLE.
   2. Use the SQL account created in Step 1 for authentication.
   3. Point to your Resource
4. Edit the config.asp file so that the strConnection is pointing to DSN created in Step 2. All other ASP pages will reference the config.asp file.
   1. The strConnection should be:
      strConnection="DSN=RMWEBDSNORACLE;"&"UID=SYSTEM;PWD=mypassword;" utcoffset= 5
   2. The user name and password is the SQL account created and used in the DSN.
   3. The UTC offset time is the number of hours from your time zone and UTC time. This needs to be a positive number.

Example Eastern Time is 5

5. Copy all of the ASP pages and the .gif files to your IIS Web server. Use a virtual directory or %systemroot%\inetpub\wwwroot.
6. Open a browser and go to < http://servername/default.asp > or to your virtual directory.

To get Resource Manager Web Console 4.1 for Oracle: