Top

5.1.4.Ingres and OpenIngres

Datasource

Figure5.19.Datasource tab

Datasource tab

Ingres Net

Figure5.20.Ingres - Net tab

Ingres - Net tab

Enter details here about the Ingres server.

  • Connection. Takes the form <vnode>::<dbname> where vnode is the name of the virtual node configured either in the Ingres V(isual)DBA or Ingres Netutil utility, and dbname is the name of the database at the vnode destination that you want to connect to.

  • Roles & Effective Users

    Ingres allows you to connect as a particular role or effective user. From iidbdb you could execute:

     create role myrole with password=myrolepwd;\g
                  

    to create a role; it is then this role and password you would enter in the above dialog.

OpenLink Parameters

Figure5.21.OpenLink Parameters tab

OpenLink Parameters tab

ODBC Parameters

Figure5.22.ODBC Parameters tab

ODBC Parameters tab

Finish & test

Figure5.23.Finish and tab

Finish and tab