Re: Phantom error 956 ...
On Fri, 17 Sep 2004 09:54:44 -0400, Jordi Tous wrote:
Each server has to trust the other, either in the /etc/hosts.equiv or in the
.rhosts file of the user running the query. Just like the message says -956
is host is not trusted.
Art S. Kagel
> Hi everybody,
>
> I have a problem when traing to access across two different IDS in two
> different servers ...
>
> 1.- IDS server Linux-dokum
> ==========================
> IDS 9.30.UC3
> Linux dokum 2.4.22-26mdkenterprise
>
> 2.- IDS server Solaris-sf4800
> =============================
> IDS 7.31.FD5
> SunOS sf4800 5.8 Generic_108528-16 sun4u sparc SUNW,Sun-Fire
>
>
> In the IDS930 I have a database albarantest with a table with the schema as
> below :
>
> create table albaran
> (
> albid serial not null ,
> albaran char(30),
> partida integer,
> imagen blob,
> usrins varchar(18) default user not null , fecins date default
> today not null , usrupd varchar(18) default user not null , fecupd
> date default today not null
> );
> create index i_albaran1 on albaran (albaran); create index i_albaran2 on> albaran (usrins,fecins); create index i_albaran3 on albaran (partida);
> create unique index p_albaran on albaran (albid);>
> In the IDS731 there are a view against the table of the IDS930 as below :
>
> create view v_albaran as
> select albaran, partida from albaranhamann@ol_dokum:albaran;>
> As you see, the blob column of the table is ommited in the view, cause
> IDS731 don'''t support this kind of data type !
>
> The view on IDS731 has been created to do selects as :
>
> SELECT COUNT(*) FROM v_albaran WHERE partida = ???>
> The problem, reproduced in dbaccess, is that many times, but not allways, i
> try to execute the SELECT COUNT(*) ... statment from dbaccess in IDS731, and
> error like :
>
>>>956: Client host or user (wwwzar@a11b5505) is not trusted by the server>
> is showed!!!
>
> If you try to run the statment again the sistem goes and the statment is
> succesfully executed, so the problem related for 956 error is solvented ???
>
> Sometimes it goes and sometimes it doesn`t ... Anyone has any idea ??
>
> Thanks in advance!