Configure the Ingres native client
Perform the following steps on Unix:
1. Login to your Unix client.
2. su to ingres.
3. execute the ingres user's .profile.
4. cd into the bin sub-directory of the Ingres installation.
5. Run the netutil command.
6. Use the Create command to create a new vnode.
7. Name your vnode.
8. Select global or private.
9. Provide login credentials for the ingres database to which you intend to connect.
10. Use ESC or the relevant character to exit the dialog.
11. Use Save to save your vnode.
12. Type the IP address or network address of the Ingres server into the Network Address field of the vnode.
13. Type tcp ip into the Protocol field of the vnode.
14. Type II, I6, I7, or other appropriate listen address in the Listen Address field of the vnode.
15. Use ESC or the relevant character to exit the dialog.
16. Use ESC or the relevant character to access the vnode commands.
17. Type Test to test your vnode.
18. Use ESC or the relevant character to access the vnode commands.
19. Type End to exit netutil.
Perform the following steps on Windows:
1. Login to the machine that contains the Ingres client installation.
2. Expand the Start menu.
3. Expand the Programs menu.
4. Expand the Ingres menus until you locate the Ingres Visual DBA.
5. Launch the Ingres Visual DBA.
6. Right click the Nodes folder.
7. Click Add.
8. Provide the following information:
- Virtual Node: Arbitrary name for your new Ingres node
- User Name: Valid Ingres database user name
- Password: Corresponding Ingres database password
- Confirm Password: Same as above
- Remote Node: Hostname or IP address of maching hosting the Ingres database
- Protocol: wintcp
- Listen Address: Valid Ingres Listening Port (e.g., II, I6, I7)
9. Click OK.
10. Right click the new Node.
11. Select Connect/DOM.
12. Wait for the main frame of Visual DBA to populate with Database schema information.
13. Right click the Node.
14. Select SQL test.
15. Enter a SQL query in the text box.
16.
Click the Go (Running Man) icon.
Referenced by...