Error Messages (T)

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z #

The INFORMIXSERVER value is not listed in the sqlhosts file or the Registry. (-25596)"

OpenLink's drivers associate an INFORMIXSERVER with our agent instances. This value is passed by the INFORMIXSERVER parameter that appears in the [Environment INFORMIX] section of your server's oplrqb.ini. You will find oplrqb.ini in the /bin sub-directory of your OpenLink server components installation. You may open oplrqb.ini with any text editor. Here is an example:

[Environment INFORMIX73]
INFORMIXSERVER     = inf7server
INFORMIXDIR        = /dbs/informix/7.3
DELIMIDENT         = Y  
OPL_INF_MULTISESS  = Y  
OPL_SPACEPADCHAR   = Y  
CURSOR_SENSITIVITY = LOW     

This value must match the value that is set in your Informix user's .profile and your $INFORMIXDIR/etc/sqlhosts file. Here are sample files:

## . PROFILE ##

INFORMIXDIR=/dbs/informix/7.3
INFORMIXSERVER=inf7server
ONCONFIG=onconfig
SHMBASE=0x0
PATH=$PATH:$INFORMIXDIR/bin
LD_LIBRARY_PATH=$INFORMIXDIR/lib:$LD_LIBRARY_PATH
export INFORMIXDIR PATH LD_LIBRARY_PATH INFORMIXSERVER ONCONFIG SHMBASE

## $INFORMIXDIR/etc/sqlhosts ##   
 
inf7server    onsoctcp    austin.hp.com   inf7srv

The $INFORMIXSERVER values from OpenLink's oplrqb.ini file and the Informix $INFORMIXDIR/etc/sqlhosts file must match. If they don't match, the error is returned. To rectify the problem, simply change the $INFORMIXSERVER value in oplrqb.ini--to a suitable value from $INFORMIXDIR/etc/sqlhosts--and run oplshut +reinit.