Starting the Small Client Processes
When you start an ESQL small client, ensure that any precompiled r-code files are in the PROPATH of the OID that runs them.
Specifying the Small Client Command
As a minimum, use the startup parameters on the following command line to start a remote ESQL small client with precompiled r-code using TCP/IP:
client-name
Your ESQL application filename.
service-name and host-name
The name of the OIB (or manually started OID) started for the small client and of the remote host. You define both names in the TCP/IP services and hosts files of the OIB/OID machine.
If your application has precompiled r-code files that are not in the PROPATH of the OID, use the
-pp
parameter to identify the pathname of the files. You can also specify other common ESQL, OID connection, and database connection parameters that your application requires.Specifying Databases at Startup
The ESQL small client also specifies the database(s) to which its OID connects and the connection parameters. To specify databases from the command line, you can start a small client as follows:
In this example, a small client,
inventory
, accesses thedb1.db
database through an OID that the OIB,sqlsv1
, starts. The OID runs on the database server machine,db1machin
e, accessing the database directly:
In this example, the OID runs on
sqlmachine
accessing the database remotely through the database broker/server,db1sv
, ondb1machine
. The small client is started on a third machine, which is why it specifies a host name for both the OIB/OID and the database broker/server. Although not a recommended configuration, this example shows how to start a small client in a three-tier, remote configuration with the small client, OID, and database broker/server running on separate machines in a network.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |