Connect to the Host DBMS through the Gateway
The general syntax to connect from an Ingres tool to the DBMS is as follows:
tool_name dbalias/server_class [-u effective_user ] [-P dbms_password]
tool_name
Specifies the name of the Ingres tool, for example, sql or isql.
dbalias
Identifies the database alias name. See the chapter "Gateway Alias Configuration" for more information about configuring the database alias.
server_class
Specifies the server class as mssql, odbc, or oracle.
-u effective_user
Defines the user ID used to connect to the database. This parameter is processed by the gateway and sent to the host DBMS. The user ID must have been defined to the host DBMS and permissions provided that would allow it to access the requested databases. Authentication can also be performed using gateway aliases or roles. See the "Gateway Alias Configuration" chapter for more information.
-P dbms_ password
Defines the password used to connect to the database. This parameter is processed by the gateway and sent to the host DBMS. The password is associated with the user ID used to connect to the host DBMS database. If the -u flag was used, this password will be associated with that user ID. If the client did not pass the -u flag to the gateway, the default client user ID will be associated with this password. Authentication can also be performed using gateway aliases or roles. See the "Gateway Alias Configuration" chapter for more information.
Tip when connecting using Terminal Monitor: If using another database product that also contains an executable sql, ensure that the Ingres bin directory is specified first in the execution path or that the sql symbol is pointing to the correct executable:
sql oracledb/oracle -ufred -psecret
Last modified date: 08/22/2022