I am having a problem connecting to Oracle 7.3.4 when setting up an NT
machine with IE 5.5, Oracle Client Software (Release 7.3.3.0.0) and
ActivePerl v15.6.0. The programms afected have been working fine on 95 for
some time.
I am runing Perl scripts that connect to Oracle though the Oracle7 ODBC and
SQL.Net interface provided by the client install. The scripts are used to
produce web pages through the NT Workstation Pear Web Server. This always
seems to work for this first time or few times, then invalid logon ID or
password errors are generated when the script attempts to connect to oracle.
The only way to 'fix' this is to restart the World Wide Web Publishing
Service in the NT Sercives control panel. I am using the DBI:Oracle connect
process to run an SQL querie on the remote server, this is then used to
produce a HTML page.
II would be grateful if anyoue has some insught regarding this problem. The
Perl code compiles ok and seems to be running on diferent system
configurations. I'm now thinking this is caused by some anomoly in my code
(attached as text).
<<query2.plx>>
begin 600 query2.plx
M<')I;G0@(D-O;G1E;G0M='EP93H@=&5X="]H=&UL7&Y<;B([#0H-"G5S92!#
M1TD[#0IM>2`D<2`](&YE=R!#1TD[#0IM>2`D=F%L=64@/2`D<2T^<&%R86TH
M(")M971A9&%T82(@*3L-"FUY("1D='EP92`]("1Q+3YP87)A;2@@(G1Y<&4B
M("D[#0IM>2`D<W1A<G0@/2`D<2T^<&%R86TH(")S=&%R="(@*3L-"FEF("@D
M<W1A<G0@97$@3B`I('L@<W5B<W1R*"1V86QU92P@,"P@,"D@/2`B)2([('T-
M"@T*=7-E($1"23L-"FUY("1D8F@@/2!$0DDM/F-O;FYE8W0H(F1B:3I/<F%C
M;&4Z:&]S=#US:WEE.W-I9#US:WEE.W!O<G0],S`P,3`B+"`G=6LP-R<L("=O
M<F%C;&4G*3L-"FUY("1S<6P@/2`B<V5L96-T(%)%3$%4259%4$%42"P@1$]#
M54U%3E1.04U%+"!2159)4TE/3BP@:"YL:69E8WEC;&5S=&%T92P@:"Y(5U-(
M14543D\L(&@N2%=$3T-35$%455,@9G)O;2!4249&(%0L($%45$%#2"!!+"!(
M5T1/0TY(($@@=VAE<F4@2"Y/0DE$(#T@02Y,1494($%.1"!!+E))1TA4(#T@
M5"Y/0DE$($%.1"!(+D1/0U5-14Y43D%-12!,:6ME("<D=F%L=65<)2<@3U)$
M15(@0ED@2"Y$3T-5345.5$Y!344L($@N2%=32$5%5$Y/+"!(+E)%5DE324].
M(CL-"FUY("1S=&@@/2`D9&)H+3YP<F5P87)E*"1S<6PI.PT*)'-T:"T^97AE
[EMAIL PROTECTED]*#0IP<FEN="`\/$A434Q?4T-225!4,3L-"B`@/$A434P^#0H@
M(#Q(14%$/@T*("`)/%1)5$Q%/D]N+4QI;F4@365T87!H87-E(%1I9F8@1FEL
M92!396%R8V@N/"]4251,13X-"B`@/"](14%$/@T*("`\0D]$62!"04-+1U)/
M54Y$/2(O:6UA9V5S+VAU;FUE=#(N9VEF(B!"1U!23U!%4E1)15,](F9I>&5D
M(CX-"@D\2#$^/'4^5&EF9B!A;F0@375L=&DM1FEL92!$<F%W:6YG(%-E87)C
M:#PO=3X\+T@Q/@T*"3Q&3TY4(%-)6D4],CX-"@D\0T5.5$52/@T*"3Q404),
M12!"04-+1U)/54Y$/2(O:6UA9V5S+V=R87EG<FED+F=I9B(@0D]21$52/2(S
M(B!"3U)$15)#3TQ/4DQ)1TA4/2(C1D9&1D8P(B!"3U)$15)#3TQ/4D1!4DL]
M(B,W,#<P-S`B($-%3$Q34$%#24Y'/2(R(B!#14Q,4$%$1$E.1STB-2(@5TE$
M5$@])3$P,#X-"@D\5%(@0D=#3TQ/4CTB(T%$1#A%-B(^/%1$/CQ"/CQ#14Y4
M15(^1FEL92!.86UE/"]#14Y415(^/"]"/CPO1%0^/%1$/CQ"/CQ#14Y415(^
M4F5V:7-I;VX\+T-%3E1%4CX\+T(^/"]41#X\5$0^/$(^/$-%3E1%4CY3=&%T
M=7,\+T-%3E1%4CX\+T(^/"]41#X\+U12/@T*2%1-3%]30U))4%0Q#0H-"FUY
M($!S=&]R960@/2(B.PT*;7D@0'-T;W)E9#(@/2(B.PT*;7D@0')A=W-Q;#L-
M"FUY("1L87-T;F%M92`]("(B.PT*;7D@)&QA<W1N86UE,B`]("(B.PT*;7D@
M)&-U<FYA;64[#0IM>2`D9FER<W0@/2`Q.PT*=VAI;&4@*$!R87=S<6P@/2`D
M<W1H+3YF971C:')O=U]A<G)A>2@I*2![(`T*("`@("!I9B`H*"1D='EP92!E
M<2`B<')O9"(@86YD(&QE;F=T:"!`<F%W<W%L6S)=("$](#$I(&]R("@D9'1Y
M<&4@97$@(G!R964B(&%N9"!L96YG=&@@0')A=W-Q;%LR72`\(#(I(&]R("@D
M9'1Y<&4@97$@(F]B<VPB(&%N9"!`<F%W<W%L6S5=(&5Q("=/0E-/3$5412<I
M*2:68@*"1C=7)N86UE(&YE("1L87-T;F%M92D@>PT*"0EI9B`H0'-T;W)E
M9%LS72!E<2`G2%=,8W-)<W-D)R`I('L-"@D)("`@:68@*"1S=&]R961;-%T@
M97$@,2!A;F0@*"1D='EP92!E<2`B<')O9"(@;W(@)&1T>7!E(&5Q(")P<F5E
M(BD@86YD($!S=&]R961;-5T@;F4@)T]"4T],151%)R`I('L@<')I;G0@(CQ4
M4CX\5$0^/$$@2%)%1CU<(FAT='`Z+R]W96(N=6LP-RYE;F<N975R;W!E+FAO
M;F5Y=V5L;"YC;VTO8V%D;&EB+TQI8G)A<GDO<F%W7W1I9F8O(B`N(&IO:6XH
M(B(L($!S=&]R961;,%TI("X@(EPB/B(@+B!J;VEN*"(B+"!`<W1O<F5D6S%=
M*2`N("(\+T$^/"]41#X\5$0^/$-%3E1%4CX\0CXB("X@:F]I;B@B(BP@0'-T
M;W)E9%LR72D@+B`B/"]"/CPO0T5.5$52/CPO5$0^/%1$/B!)<W-U960@/"]4
M1#X\+U1$/CPO5%(^(CL@?0T*"0D@("!I9B`H)'-T;W)E9%LT72!E<2`Q(&%N
M9"`D9'1Y<&4@97$@(F]B<VPB(&%N9"!`<W1O<F5D6S5=(&5Q("=/0E-/3$54
M12<@*2![('!R:6YT("(\5%(^/%1$/CQ!($A2148]7")H='1P.B\O=V5B+G5K
M,#<N96YG+F5U<F]P92YH;VYE>7=E;&PN8V]M+V-A9&QI8B],:6)R87)Y+W)A
M=U]T:69F+R(@+B!J;VEN*"(B+"!`<W1O<F5D6S!=*2`N(")<(CXB("X@:F]I
M;B@B(BP@0'-T;W)E9%LQ72D@+B`B/"]!/CPO5$0^/%1$/CQ#14Y415(^/$(^
M(B`N(&IO:6XH(B(L($!S=&]R961;,ETI("X@(CPO0CX\+T-%3E1%4CX\+U1$
M/CQ41#X@3T)33TQ%5$4@/"]41#X\+U1$/CPO5%(^(CL@?0T*"0D@("!I9B`H
M)'-T;W)E9%LT72!N92`Q(&%N9"`D9'1Y<&4@97$@(G!R;V0B*2![('!R:6YT
M("(\5%(^/%1$/B(@+B!J;VEN*"(B+"!`<W1O<F5D6S%=*2`N("(\+U1$/CQ4
M1#X\0T5.5$52/CQ"/CQ&3U)-($%#5$E/3CU<(BXN+W-C<FEP=',O<&%G97,N
M<&QX7"(^/$E.4%54(%194$4]7")354)-251<(B!.04U%/21S=&]R960R6S%=
M(%9!3%5%/5PB375L=&DM4&%G95PB/CPO1D]233X\+T(^/"]#14Y415(^/"]4
M1#X\5$0^($ES<W5E9"X@/"]41#X\+U12/B([('T-"@D)("`@:68@*"1S=&]R
M961;-%T@;F4@,2!A;F0@)&1T>7!E(&5Q(")P<F5E(BD@>R!P<FEN="`B/%12
M/CQ41#XB("X@:F]I;B@B(BP@0'-T;W)E9%LQ72D@+B`B/"]41#X\5$0^/$-%
M3E1%4CX\0CX\1D]232!!0U1)3TX]7"(N+B]S8W)I<'1S+W!A9V5S+G!L>%PB
M/CQ)3E!55"!465!%/5PB4U5"34E47"(@3D%-13TD<W1O<F5D,ELQ72!604Q5
M13U<(DUU;'1I+7!A9V5<(CX\+T9/4DT^/"]"/CPO0T5.5$52/CPO5$0^/%1$
M/B!)<W-U960@/"]41#X\+U12/B([('T-"@D)?0T*"0EI9B`H;F]T("1F:7)S
M="!A;F0@0'-T;W)E9%LS72!N92`G2%=,8W-)<W-D)RD@>PT*"0D@("!I9B`H
M)&QA<W1N86UE,B!E<2`D;&%S=&YA;64@86YD($!S=&]R960R6S-=(&5Q("=(
M5TQC<TES<V0G*2![#0H)"2`@("`@('!R:6YT("(\5%(^/%1$/CQ!($A2148]
M7")H='1P.B\O=V5B+G5K,#<N96YG+F5U<F]P92YH;VYE>7=E;&PN8V]M+V-A
M9&QI8B],:6)R87)Y+W)A=U]T:69F+R(@+B!J;VEN*"(B+"!`<W1O<F5D,ELP
M72D@+B`B7"(^(B`N(&IO:6XH(B(L($!S=&]R960R6S%=*2`N("(\+T$^/"]4
M1#X\5$0^/$-%3E1%4CX\0CXB("X@:F]I;B@B(BP@0'-T;W)E9#);,ETI("X@
M(CPO0CX\+T-%3E1%4CX\+U1$/CQ41#X@3&%S="!)<W-U960@/"]41#X\+U12
M/B([#0H)"2`@('T-"@D)("`@<')I;G0@(CQ44CX\5$0^(B`N(&IO:6XH(B(L
M($!S=&]R961;,5TI("X@(CPO5$0^/%1$/CQ#14Y415(^/$(^(B`N(&IO:6XH
M(B(L($!S=&]R961;,ETI("X@(CPO0CX\+T-%3E1%4CX\+U1$/CQ41#X@4&5N
M9&EN9R`\+U1$/CPO5%(^(CL-"@D)("`@:68@*"1L87-T;F%M93(@97$@)&QA
M<W1N86UE(&%N9"!`<W1O<F5D,ELS72!N92`G2%=,8W-)<W-D)RD@>PT*("`@
M("`@("`@("`@("`@("`@("`@('!R:6YT("(\5%(^/%1$/CQ&3U)-($%#5$E/
M3CU<(BXN+W-C<FEP=',O:&ES=&]R>2YP;'A<(CX\24Y0550@5%E013U<(E-5
M0DU)5%PB($Y!344]7")(25-43U)97"(@5D%,544])'-T;W)E9#);,5T^/"]&
M3U)-/CPO5$0^/%1$/CQ#14Y415(^/$(^($XO02`\+T(^/"]#14Y415(^/"]4
M1#X\5$0^/$(^3F\@27-S=64A/"]"/CPO5$0^/"]44CXB.PT*"0D@("!]#0H)
M"7T-"@E]#0H))&QA<W1N86UE,B`]("1L87-T;F%M93L-"@DD;&%S=&YA;64@
M/2`D8W5R;F%M93L-"@E`<W1O<F5D,B`]($!S=&]R960[#0H)0'-T;W)E9"`]
M($!R87=S<6P[#0H))&9I<G-T(#T@,#L-"B`@("`@?0T*?0T*:68@*$!S=&]R
M961;,UT@97$@)TA73&-S27-S9"<@*2![#0H@("`@:68@*"1S=&]R961;-%T@
M97$@,2!A;F0@*"1D='EP92!E<2`B<')O9"(@;W(@)&1T>7!E(&5Q(")P<F5E
M(BD@86YD($!S=&]R961;-5T@;F4@)T]"4T],151%)R`I('L@<')I;G0@(CQ4
M4CX\5$0^/$$@2%)%1CU<(FAT='`Z+R]W96(N=6LP-RYE;F<N975R;W!E+FAO
M;F5Y=V5L;"YC;VTO8V%D;&EB+TQI8G)A<GDO<F%W7W1I9F8O(B`N(&IO:6XH
M(B(L($!S=&]R961;,%TI("X@(EPB/B(@+B!J;VEN*"(B+"!`<W1O<F5D6S%=
M*2`N("(\+T$^/"]41#X\5$0^/$-%3E1%4CX\0CXB("X@:F]I;B@B(BP@0'-T
M;W)E9%LR72D@+B`B/"]"/CPO0T5.5$52/CPO5$0^/%1$/B!)<W-U960@/"]4
M1#X\+U1$/CPO5%(^(CL@?0T*("`@(&EF("@D<W1O<F5D6S1=(&5Q(#$@86YD
M("1D='EP92!E<2`B;V)S;"(@86YD($!S=&]R961;-5T@97$@)T]"4T],151%
M)R`I('L@<')I;G0@(CQ44CX\5$0^/$$@2%)%1CU<(FAT='`Z+R]W96(N=6LP
M-RYE;F<N975R;W!E+FAO;F5Y=V5L;"YC;VTO8V%D;&EB+TQI8G)A<GDO<F%W
M7W1I9F8O(B`N(&IO:6XH(B(L($!S=&]R961;,%TI("X@(EPB/B(@+B!J;VEN
M*"(B+"!`<W1O<F5D6S%=*2`N("(\+T$^/"]41#X\5$0^/$-%3E1%4CX\0CXB
M("X@:F]I;B@B(BP@0'-T;W)E9%LR72D@+B`B/"]"/CPO0T5.5$52/CPO5$0^
M/%1$/B!/0E-/3$5412`\+U1$/CPO5$0^/"]44CXB.R!]#0H@("`@:68@*"1S
M=&]R961;-%T@;F4@,2!A;F0@)&1T>7!E(&5Q(")P<F]D(BD@>R!P<FEN="`B
M/%12/CQ41#XB("X@:F]I;B@B(BP@0'-T;W)E9%LQ72D@+B`B/"]41#X\5$0^
M/$-%3E1%4CX\0CX\1D]232!!0U1)3TX]7"(N+B]S8W)I<'1S+W!A9V5S+G!L
M>%PB/CQ)3E!55"!465!%/5PB4U5"34E47"(@3D%-13TD<W1O<F5D,ELQ72!6
M04Q513U<(DUU;'1I+5!A9V5<(CX\+T9/4DT^/"]"/CPO0T5.5$52/CPO5$0^
M/%1$/B!)<W-U960@/"]41#X\+U12/B([('T-"B`@("!I9B`H)'-T;W)E9%LT
M72!N92`Q(&%N9"`D9'1Y<&4@97$@(G!R964B*2![('!R:6YT("(\5%(^/%1$
M/B(@+B!J;VEN*"(B+"!`<W1O<F5D6S%=*2`N("(\+U1$/CQ41#X\0T5.5$52
M/CQ"/CQ&3U)-($%#5$E/3CU<(BXN+W-C<FEP=',O<&%G97,N<&QX7"(^/$E.
M4%54(%194$4]7")354)-251<(B!.04U%/21S=&]R960R6S%=(%9!3%5%/5PB
M375L=&DM<&%G95PB/CPO1D]233X\+T(^/"]#14Y415(^/"]41#X\5$0^($ES
M<W5E9"`\+U1$/CPO5%(^(CL@?0T*?0T*:68@*&YO="`D9FER<W0@86YD($!S
M=&]R961;,UT@;F4@)TA73&-S27-S9"<I('L-"B`@(&EF("@D;&%S=&YA;64R
M(&5Q("1L87-T;F%M92!A;F0@0'-T;W)E9#);,UT@97$@)TA73&-S27-S9"<I
M('L-"B`@("`@('!R:6YT("(\5%(^/%1$/CQ!($A2148]7")H='1P.B\O=V5B
M+G5K,#<N96YG+F5U<F]P92YH;VYE>7=E;&PN8V]M+V-A9&QI8B],:6)R87)Y
M+W)A=U]T:69F+R(@+B!J;VEN*"(B+"!`<W1O<F5D,ELP72D@+B`B7"(^(B`N
M(&IO:6XH(B(L($!S=&]R960R6S%=*2`N("(\+T$^/"]41#X\5$0^/$-%3E1%
M4CX\0CXB("X@:F]I;B@B(BP@0'-T;W)E9#);,ETI("X@(CPO0CX\+T-%3E1%
M4CX\+U1$/CQ41#X@3&%S="!)<W-U960@/"]41#X\+U12/B([#0H@("!]#0H@
M("!P<FEN="`B/%12/CQ41#XB("X@:F]I;B@B(BP@0'-T;W)E9%LQ72D@+B`B
M/"]41#X\5$0^/$-%3E1%4CX\0CXB("X@:F]I;B@B(BP@0'-T;W)E9%LR72D@
M+B`B/"]"/CPO0T5.5$52/CPO5$0^/%1$/B!096YD:6YG(#PO5$0^/"]44CXB
M.PT*("`@:68@*"1L87-T;F%M93(@97$@)&QA<W1N86UE(&%N9"!`<W1O<F5D
M,ELS72!N92`G2%=,8W-)<W-D)RD@>PT*("`@("`@<')I;G0@(CQ44CX\5$0^
M/$9/4DT@04-424]./5PB+BXO<V-R:7!T<R]H:7-T;W)Y+G!L>%PB/CQ)3E!5
M5"!465!%/5PB4U5"34E47"(@3D%-13U<(DA)4U1/4EE<(B!604Q513TD<W1O
M<F5D,ELQ73X\+T9/4DT^/"]41#X\5$0^/$-%3E1%4CX\0CX@3B]!(#PO0CX\
M+T-%3E1%4CX\+U1$/CQ41#X\2#,^3F\@27-S=64A/"](,SX\+U1$/CPO5%(^
M(CL-"B`@('T-"GT@("`@("`-"G!R:6YT(#P\2%1-3%]30U))4%0R.PT*/"]#
M14Y415(^/"]404),13X\+T9/3E0^/$A2/@T*/'`@86QI9VX](F-E;G1E<B(^
M/$)55%1/3B!O;D-L:6-K/2)T;W`N:&ES=&]R>2YB86-K*"DB/D)!0TL\+T)5
M5%1/3CX\+W`^#0H\+T)/1%D^/"](5$U,/@T*2%1-3%]30U))4%0R#0HD<W1H
@+3YF:6YI<V@H*3L-"B1D8F@M/F1I<V-O;FYE8W0[#0H=
`
end
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
