Progress
DataServer
for ORACLE Guide
Connecting a Schema Holder
In addition to the automatic connection that can take place when you create a schema holder, Progress provides these techniques for connecting a schema holder:
- Use the Progress Data Dictionary or Data Administration tool. From the main menu, select Database
Connect and supply the schema holder’s physical name and appropriate connection parameters. Once you have supplied the connection parameters, you can use Auto-Connect to connect to the schema holder. You cannot use Auto-Connect to connect to the ORACLE database. You connect to the ORACLE database when you select it as your working database.
- Use the CONNECT statement (see the CONNECT Statement reference entry in the Progress Language Reference). For example, this command connects a local read-only schema holder named oholder.
- Use connection parameters when you start Progress. You can include these parameters in a parameter file that you specify when you start Progress. A parameter file is portable and easy to maintain. For information on how to create a parameter file, see the Progress Startup Command and Parameter Reference.
You can use different connection techniques in combination with each other. For example, you can connect the schema holder at startup, then connect to the DataServer using the Progress CONNECT statement. Any combination of connection techniques works, as long as you follow these steps:
When you connect to the schema holder and the ORACLE database in a single startup command or connection statement, be sure to specify parameters that affect the schema holder before the Database Name (-db) parameter. Specify only parameters that affect the ORACLE database connection after the -db parameter.
The following sections explain how to connect both a schema holder and an ORACLE database when you start up Progress.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |