Connect_example1 Application
This directory contains an example of a client/server application that shows various ways of passing user IDs and passwords to Ingres and Enterprise Access servers. It uses the local Loadnrun Standalone Net Client.
Purpose
The Connect_example1 application illustrates how to interactively connect to a database using the following connection flags:
-local_system_user
-local_system_password
-remote_system_user
-remote_system_password
Audience
Specifically, this example is geared toward users who have used or who are attempting to use the IIPROMPT* environment variables.
IIPROMPT1, IIMPROMPTONCE, and IIPROMPTALL are undocumented environment variables that cause the Ingres Net server to prompt users to enter their password.
The two most prevalent issues reported about the use of the IIPROMPT* family of environment variables are:
• There is no programmatic control over the password prompt.
• There is no programmatic control over how to trap and display any errors that arise from the use of IIPROMPT*.
Description
The connect_example1 application illustrates a technique that you can use to prompt for a user ID and password, which will be used to connect to a database.
The following flags were introduced in a previous Ingres 5 release:
-remote_system_user userid
-remote_system_password password
-local_system_user userid
-local_system_password password
In Ingres 11.2, the "‑remote_system_user" flag and the "-remote_system_password" flag overrode the user ID and password retrieved from a local vnode or global vnode.
In Ingres 11.2 these flags were effective only for remote connection requests. In Ingres 11.2, these flags overrode the user ID and password for local and remote connections.
The "-local_system_user" and "-local_system_password" connection flags were used to override the local connection user ID and password. If the user ID and password were valid, they allowed any private vnode information to be retrieved that was stored under the user ID specified. The user ID and password information was used to make a connection unless the "‑remote_system_user" and "-remote_system_password" connection flags were set.
Last modified date: 12/20/2023