A script-enabled browser is required for this page to function properly.

EXPRESS_SERVER command line keyword

EXPRESS_SERVER specifies the Express Server to which you want to connect.

The executables that can use this keyword are:

rwbuilder yes
rwrun yes
rwclient yes
rwcgi yes
rwserver no
rwservlet yes
rwconverter no

Syntax

EXPRESS_SERVER="server=server/domain=domain/user=userid/password=passwd"

Syntax with RAM

EXPRESS_SERVER="server=server/domain=domain/
user=userid/password=passwd/ramuser=ramuserid/ rampassword=rampasswd/ramexpressid=ramexpid/
ramserverscript=ramsscript/rammasterdb=ramdb/ ramconnecttype=ramconn"

 

Values

Description

server

The Express server string (for example, ncacn_ip_tcp:olap2-pc/sl=x/st=x/ct=x/sv=x/)

The server value contains four parameters that correspond to settings that are made in the Oracle Express Connection Editor and stored in connection (.xcf) files. All four parameters are required and can be specified in any order. The following table describes the parameters and their settings.

 

Values

Description

Setting

sl

Server Login

-2: Host (Domain Login)

-1: Host (Server Login)

0: No authentication required

1: Host (Domain Login) and Connect security

2: Host (Domain Login) and Call security

3: Host (Domain Login) and Packet security

4: Host (Domain Login) and Integrity security

5: Host (Domain Login) and Privacy security

Notes: Windows uses all the settings. Unix systems use only the settings 0, -1, and -2.

See the Express Connection Editor Help system for information on these settings.

st

Server Type

1: Express Server

ct

Connection Type

0: Express connection

sv

Server Version

1: Express 6.2 or greater

domain

The Express Server domain.

user

The userid to log in to the Express Server.

password

The password for the userid.

ramuser

The userid to log in to the RDBMS.

rampassword

The password for the RDBMS.

ramexpressid

The Oracle Sales Analyzer database userid. This is required for Oracle Sales Analyzer databases only.

ramserverscript

The complete file name (including the full path) of the remote database configuration file (RDC) on the server. This file specifies information such as the location of code and data databases. Using UNC (Universal Naming Convention) syntax allows multiple users to use the same connection to access the data without having to map the same drive letter to that location. UNC syntax is \\ServerName\ShareName\ followed by any subfolders or files.

rammasterdb

is the name of the Relational Access Manager database to attach initially. You must specify only the database file name. This database must reside in a directory that is included in the path list in ServerDBPath for Express Server. You can check the ServerDBPath in the File I/O tab of the Express Configuration Manager dialog box.

ramconnecttype

is the type of Express connection. Always specify 0 for a direct connection.

Usage notes

EXPRESS_SERVER="server=ncacn_ip_tcp:olap2-pc/sl=0/
st=1/ct=0/sv=1/ domain=tools//reports"

EXPRESS_SERVER with userid, password, and domain (rwbuilder) example

  rwbuilder userid=scott/tiger@nt805
  express_server="server=ncacn_ip_tcp:olap2-pc/sl=1/st=1/ct=0/
  sv=1/user=orbuild/domain=tools/password=buildme/"
  report=exp.rdf destype=file desname=exp1.html
  desformat=html batch=yes

EXPRESS_SERVER without userid, password, and domain (rwbuilder) example

  rwbuilder userid=scott/tiger@nt805
  express_server="server=ncacn_ip_tcp:olap2-pc/sl=0/st=1/ct=0/
  sv=1/" report=exp.rdf destype=file desname=exp1.html
  desformat=html batch=yes

EXPRESS_SERVER with RAM (rwrun) example

  rwrun userid=scott/tiger@nt805
  express_server="server=ncacn_ip_tcp:olap2-pc/sl=0/st=1/
  ct=0/sv=1/ramuser=appqa/rampassword=appqa1/ramexpressid=appqa/
  ramserverscript=\\olap3-pc\orant\olap\ram6202\ram\sqstnt.rdc/
  rammasterdb=sqstnt.db/ramconnecttype=0"
  report=exp.rdf destype=file desname=exp1.html
  desformat=html batch=yes

See also

Command line keywords

Using the command line

Running a report from the command line