Re: Informix and Cognos

This is a multi-part message in MIME format. --------------8129DDC39B064877EF4E6304 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit You should speak with Cognos Customer support to inspect the connection information that PowerPlay is trying to use in order to establish the connection to Informix. It could range from a 'default' being applied at the client via a Setnet config which is not present in the UNIX environment, a bad user id/password to something more exotic such as you are using co-hosts with XPS 8.2 and the version of the Informix libraries of the build you are using is not compatible. jhamilto@hep.hubbell.com wrote: > Hello everyone, > > Environment: HP-UX 10=2E20 Informix On-line 7=2E3 =20 > Cognos/Impromptu 4=2E01 > > The problem seems simple but no one seems to be able to help=2E I'm =20 > bouncing this problem off of everyone I know to see if I get some idea's=2E > > Here's the problem: > > I have a Cognos script, when executed, is suppose to sign onto the =20 > Informix database and run a query and build a thing called a powercube=2E =20= > =20 > In the script I have added statements to set INFORMIXDIR, =20 > INFORMIXSERVER, ONCONFIG and even DBSERVERNAME=2E All variables are =20 > exported=2E Every Time this shell runs, Cognos dies with an "unable to =20 > sign onto database" failure=2E > > I'm I missing some environment variables to allow a shell script to =20 > connect to Informix? > > Thanks, > > Jerry Hamilton > Informix DBA > Hubbell-Killark > 314-406-1521 =20 --------------8129DDC39B064877EF4E6304 Content-Type: text/x-vcard; charset=us-ascii; name="Nigel.Campbell.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Nigel Campbell Content-Disposition: attachment; filename="Nigel.Campbell.vcf" begin:vcard n:Campbell;Nigel x-mozilla-html:FALSE org:Cognos version:2.1 email;internet:Nigel.Campbell@cognos.com title:Impromptu Product Manager x-mozilla-cpt:;0 fn:Nigel Campbell end:vcard --------------8129DDC39B064877EF4E6304--