Configuring the Adapter for Ingres

In this section:

How to:

Reference:

x

Configuring the adapter consists of specifying connection and authentication information for each of the connections you want to establish.


Top of page

x
Procedure: How to Declare Connection Attributes

You can configure the adapter from either the Web Console or the Data Management Console.

  1. From the Web Console menu bar, click Adapters.

    or

    From the Data Management Console, expand the Adapters folder.

    The Adapters folder opens.

  2. Expand the Available folder, if it is not already expanded.
  3. Expand the appropriate group folder and the specific adapter folder. The group folder is described in the connection attributes reference.
  4. Right-click the adapter name and/or version and select Configure.

    The Add Adapter to Configuration pane opens.

  5. Enter values for the parameters required by the adapter, as described in the connection attributes reference.
  6. Click Configure. The configured adapter is added to the Adapters list in the navigation pane.


x
Reference: Connection Attributes for Ingres

The Ingres adapter is under the SQL group folder.

The following list describes the connection attributes for which you can supply values. To complete the attribute declaration, click the Configure button.

Database Name

Name of the Ingres II database you wish to connect to. There is no default database; a value must be entered.

User

Valid Ingres II user name.

Password

Password that identifies the entered user name.

Select profile

Select a profile from the drop-down menu to indicate the level of profile in which to store the CONNECTION_ATTRIBUTES command. The global profile, edasprof.prf, is the default.

If you wish to create a new profile, either a user profile (user.prf) or a group profile if available on your platform (using the appropriate naming convention), choose New Profile from the drop-down menu and enter a name in the Profile Name field (the extension is added automatically).

Store the connection attributes in the server profile (edasprof).


Top of page

x
Syntax: How to Declare Connection Attributes Manually

To connect to Ingres using SET commands, issue the following

ENGINE SQLING SET DATABASE dbname 
ENGINE SQLING SET USER userid/password 
ENGINE SQLING SET OPTIONs -R"xxxxxx", -G"yyyyyy"

where:

dbname

Is the name of the database.

userid

Is the user ID of the user.

password

Is the password in the Ingres database. This is required only if the password is turned on in the database.

xxxxxx

Is the Ingres role ID.

yyyyyy

Is the Ingres group ID.


Top of page

x
Overriding the Default Connection

How to:

Once connections have been defined, the connection named in the last SET DATABASE command serves as the default connection. You can override this default by re-issuing the SET DATABASE command to connect to a different database. The Adapter for Ingres does not support multiple data connections.



x
Syntax: How to Change the Default Connection
ENGINE SQLING SET DATABASE dbname

where:

SQLING

Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.

dbname

Is the name of the database to which you are connecting.

Note: You must terminate the session with one database before you switch to another one. Use the following command to terminate the session:

ENGINE SQLING END SESSION



Example: Selecting the Default Connection

The following SET DATABASE command selects the Ingres database server named SAMPLENAME as the default Ingres database server:

ENGINE SQLING SET DATABASE SAMPLENAME

iWay Software