Configuring an Ingres vnode (Windows)

Configure the Ingres native client

1. Login to the Windows machine that hosts your Ingres native client.
   
2. Expand your Start and Programs menus.
   
3. Expand the folder or folders associated with your Ingres client installation.
   
4. Launch Ingres Visual DBA.
   
   
   
   
   
   
5. Expand the Node menu that appears in the top menu bar.
   
6. Select Add.
   
   
   
   
   
   
7. Fill in the following values:
   
   • Virtual Node - Provides an arbitrary name for your local, Ingres node
     
   • Login Information
     
     • User Name: Provides your Ingres database username
       
     • Password: Provides your Ingres database password
       
     • Confirm Pasword: Provides your Ingres database password
       
   • Connection Information
     
     • Remote Node: Provides the actual name of the Ingres vnode
       
     • Protocol: wintcp (default)
       
     • Listen Address: Provides the Ingres listen address
       
8. Click OK to create the new, local node.
   
9. Right click the newly created node.
   
10. Select Connect/DOM.
    
11. Successful connections result in folders representing Ingres database entities appearing in the Visual DBA interface.

Test the connection

1. Locate and click the SQL Test button.
   
   
   
   
   
   
2. Use the database drop down box to specify the database, which you want to query.
   
3. Enter the SQL query in the space provided.
   
4. Click the Go button.
   
5. Successful queries will return the anticipated data.