Aitor,
In the registry (for Windows95 or WindowsNT), add or change the key
"CommandTimeout". I don't remember now if it previously existed, but I
think it did.
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\<datasource>
The value will be a string which specifies the number of milliseconds
for a timeout. I've increased mine from the default "180000" to
"500000", and the problem has gone away.
I've heard that for the 16-bit driver, the \windows\system\odbc.ini
file needs to be edited.
Hope this helps,
David N. Lukenbill
> -----Original Message-----
> From: HP3000-L
> Sent: Thursday, May 07, 1998 6:58 AM
> To: HP3000-L
> Cc: si
> Subject: ODBC Link/SE ver. E.55 & 'Timeout on data error'
> Hello,
>
> We are accessing to an Allbase/SQL DB which is placed in a
> HP3000 through a
> Windows 95 client, having ODBC Link/SE ver. E.55 and with CR60.
>
> When asking for a report from Allbase/SQL with ODBC, the
> following error is
> raised: "Timeout on data read". However, the same SQL
> executed in the host
> itself, interactively, goes fine.
>
> As the ODBC manual says, this error is due to the exceeding
> of the Command
> Timeout, and the solution would be to increase it. The ODBC
> Link/SE ver.
> E.55 is limited, so the ODBC configuration doesn't offer any
> possibility of
> changing this timeout.
>
> Could it be possible to change/add this parameter in the
> System Register??
>
> Sincerelly,
> ***********************************************
> Aitor Epelde Soraluze
> Dpto. Informatica Marcial Ucin, s.a.
> [log in to unmask]
> ***********************************************
>
.......................................................................
Item Subject: WINMAIL.DAT
Could not convert Microsoft Mail Message Data item to text.
Will attempt to 'shar' item as file '01eqltr' at end of msg.
# This is a shell archive. Remove anything before this line,
# then unpack it by saving it in a file and typing "sh file".
#
# Wrapped by OpenMail System <openmail@ciwsux> on Thu May 7 15:09:41 1998
#
# This archive contains:
# 01eqltr
#
# Error checking via wc(1) will be performed.
LANG=""; export LANG
PATH=/bin:/usr/bin:$PATH; export PATH
rm -f /tmp/uud$$
(echo "begin 666 /tmp/uud$$\n#;VL*n#6%@x\n \nend" | uudecode) >/dev/null 2>&1
if [ X"`cat /tmp/uud$$ 2>&1`" = Xok ]
then
unpacker=uudecode
else
echo Compiling unpacker for non-ascii files
pwd=`pwd`; cd /tmp
cat >unpack$$.c <<'EOF'
#include <stdio.h>
#define C (*p++ - ' ' & 077)
main()
{
int n;
char buf[128], *p, a,b;
scanf("begin %o ", &n);
gets(buf);
if (freopen(buf, "w", stdout) == NULL) {
perror(buf);
exit(1);
}
while (gets(p=buf) && (n=C)) {
while (n>0) {
a = C;
if (n-- > 0) putchar(a << 2 | (b=C) >> 4);
if (n-- > 0) putchar(b << 4 | (a=C) >> 2);
if (n-- > 0) putchar(a << 6 | C);
}
}
exit(0);
}
EOF
cc -o unpack$$ unpack$$.c
rm unpack$$.c
cd $pwd
unpacker=/tmp/unpack$$
fi
rm -f /tmp/uud$$
echo x - 01eqltr '[non-ascii]'
$unpacker <<'@eof'
begin 660 01eqltr
M>)\^(E\T 0:0" $ ! $ 0>0!@ ( Y 0 #H $(@ < X
M& $E032Y-:6-R;W-O9G0@36%I;"Y.;W1E #$( 0V ! " @ " $$X
M@ $ -0 %)%.B!/1$)#($QI;FLO4T4@=F5R+B!%+C4U("8@)U1I;65O=70@X
M;VX@9&%T82!E<G)O<B< L@\!!8 # X #.!P4 !P / L &@ $ !D! 0" X
M !" ! !" !( ( !,=6ME;F)I;&PL($1A=FED !/4$5.34%)3#I$879IX
M9"!,=6ME;F)I;&P@+TA-4T-, 31 !(( # X #.!P4 !P /X
M 0 +P $ "<! 0F 0 A 03%%.#A!,C@Y1D4U1#$Q,4$U1#<P,#8P,#@YX
M-40Q-S( #0<! Y & )0# E "P " $ + ", , )@ X
M"P I + "L , +@ P V ! #D 4*6([NMYO0$>X
M $( 0 !$ !,=6ME;F)I;&PL($1A=FED $ 2 ! >T3OZWF] 1X X
M< ! ,0 $]$0D,@3&EN:R]312!V97(N($4N-34@)B G5&EM96]U="!OX
M;B!D871A(&5R<F]R)P " 7$ 0 !8 !O7GK[?THBNBBY9\1T:77X
M & (E=%R > !H, 0 !$ !,=6ME;F)I;&PL($1A=FED (!'0P!X
M ( $]014Y-04E,.D1A=FED($QU:V5N8FEL;" O2$U30TP '@ ># $ X
M ) 3U!%3DU!24P '@ ?# $ 7 1&%V:60@3'5K96YB:6QLX
M("](35-#3 '@!"$ $ ! , @!#_____0 ','! Q@#K>;T!X
M0 (,'! Q@#K>;T! P#>/Z]O + " "" & # 1@ #X
MA0 , 8 (( 8 , !& !"% P "@ @@X
M!@ P $8 4H4 / 3 > . "" & # X
M1@ !4A0 0 0 X+C4 P $@ @@!@ P $8 X
M 84 + 6 "" & # 1@ .A0 , !H (X
M( 8 , !& !&% P '@ @@!@ P X
M $8 &(4 > B "" & # 1@ VA0 0 X
M $ '@ )@ @@!@ P $8 -X4 $ ! X
M !X "H (( 8 , !& #B% ! 0 +X
M !^ "R & # 1@ B L (( +( 8 , X
M !& 6( "P $@0@@!@ P $8 !H4 X
C > #T 0 4 !213H@ , #33]-P ?WX X
X
end
@eof
set `wc -lwc <01eqltr`
if test $1$2$3 != 1481250
then
echo ERROR: wc results of 01eqltr are $* should be 1 48 1250
fi
chmod 660 01eqltr
rm -f /tmp/unpack$$
exit 0
|