Connection tab

Use the Connection tab to provide DBMS connection information for all DB aliases in any directory required to perform delegated tasks.

You can expedite the configuration of the settings for the server by clicking Merge Current User. This merges the settings for the logged-on user in the user registry with settings for the server in the local machine registry. Alternatively, automate this process with the utility,

PR0CNFG.EXE /NOLOGO /AUTORUN=TRUE /TASK=MERGE_CURRENT_USER

Optim Server Settings dialog, Connection tab

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.