2 difference databases with other listen-addresses

From: Rob Aartsen (Rob.Aartsen_at_atosorigin.com)
Date: 01/04/05 

Date: Tue, 4 Jan 2005 12:49:15 +0100
To: <dbi-users@perl.org>

Dear DBI-Users,

We have 2 Ingres databases with difference listen addresses. One has the default one 'ii'. The other has listen address 'wv'.

The output is difference :

The sql query for the non-default listen address goes wrong :

nl1pdwh1:KT:ingres>./QueryDB.pl -d ingktonlp1 -u ingres -p @jungl3 -q "select * from skeletons"
DBD::Ingres::connect non-OpenIngres: ignoring DBMS_PASSWORD at /appl/perl/lib/site_perl/5.8.0/sun4-solaris/DBD/Ingres.pm line 93.
DBI connect('ingktonlp1','ingres',...) failed: E_LQ0001 Failed to connect to DBMS session.
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
    Internal service status E_GC1005 -- Requested GCF security mechanism has
    been disabled.. at /appl/GEMSTools/scripts/DWH/cmis/lib/Database.pm line 95
  ERROR: Unable to execute database query (select * from skeletons) !
         Reported error: E_LQ0001 Failed to connect to DBMS session.
E_LC0001 GCA protocol service (GCA_REQUEST) failure.
    Internal service status E_GC1005 -- Requested GCF security mechanism has
    been disabled...

Can you give us a hint ?

Kind regards,
Rob Aartsen