Use the Connection tab to provide DBMS connection information
for all DB Aliases in any Optim™ Directory
required to perform delegated tasks.
Note: You can expedite the configuration of the Connection
settings for the Server by clicking Merge Current User.
This merges the Connection settings for the logged-on user in the Current User
registry with settings for the Server machine in the Local Machine
registry.
Settings on the Connection tab
and the Security tab are related. On the Security tab,
you choose Server or Client to
specify the source of the User ID and Password information for Optim Directory and DB Alias access.
- If you select Server on the Security tab,
the appropriate User ID and password entered on the Connection tab
are used; the User ID and password from the workstation originating
the task are not used.
- If you select Client on the Security tab,
the User ID and password from the workstation originating the task
are used.
Note: The Connection String information you enter on the Connection tab
is used regardless of whether you select Server or Client on
the Security tab. Leave the connection string
blank, or select the Always Fail Connection check
box to prevent the Server from accessing an Optim Directory and/or DB Alias when performing
delegated tasks.
Optim Directory
Select an Optim Directory
from the list to display the connection information for the corresponding
DB Aliases.
Grid Details
The
connection information for the selected Optim Directory
includes the following.
Note: The maximum length for a User ID
or password varies by DBMS.
- DB Alias
- DB Aliases in the selected Optim Directory.
- User ID
- Identifier (1 to 30 characters) that allows the
Server to use a particular DB Alias. User IDs are usually assigned
and maintained by the database administrator.
Note: If you are using Informix®, you must enter the
User ID in upper case for an ANSI database and in lower case for a
non-ANSI database.
- Password
- Enter a password (1 to 30 characters) that allows
the Server to access a database using the specified DB Alias.
- Verify
- Reenter the password for verification.
- Connection String
- Connection string the Server uses to access a database
using the specified DB Alias.
- Always Fail Connection
- Select this check box to deny access to the corresponding
DB Alias. You can use this check box to temporarily deny access to
a DB Alias without having to remove the connection string.
- Description
- Text that describes or explains the purpose of the
logon record.
Merge Current User
Click Merge
Current User to merge the Connection settings from the Current User
registry to the Local Machine registry for the Server component machine.
This action does not overlay information previously entered into the Optim Server Settings dialog. This
action only merges new settings from the Current User. If the settings
are the same, this command is unavailable.