In this section: How to: Reference: |
Configuring the adapter consists of specifying connection and authentication information for each of the connections you want to establish.
You can configure the adapter from either the Web Console or the Data Management Console.
or
From the Data Management Console, expand the Adapters folder.
The Adapters folder opens.
The Add Adapter to Configuration pane opens.
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.
Name of the Ingres II database you wish to connect to. There is no default database; a value must be entered.
Valid Ingres II user name.
Password that identifies the entered user name.
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).
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:
Is the name of the database.
Is the user ID of the user.
Is the password in the Ingres database. This is required only if the password is turned on in the database.
Is the Ingres role ID.
Is the Ingres group ID.
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.
ENGINE SQLING SET DATABASE dbname
where:
Indicates the adapter. You can omit this value if you previously issued the SET SQLENGINE command.
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
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 |