Phantom error 956 ...
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!