|
 |
asp_databases thread: Stored Procedure Problem
Message #1 by "David Voo" <gigsvoo@y...> on Tue, 31 Jul 2001 09:36:25 +0800
|
|
Hi there guys,
Here i got a problem using asp page passes parameter to a stored procedure.
it was runned well in IIS 5 of W2k but when it migrate to a NT 4 IIS 4
server with IE 4.01 SP2, there are some errors that cannot recognize the
stored procedure parameter passing. When I tried to create a parameter with
respective data type, it cannot be recognized, anyone can help? Its quite
urgent.
Attached is the source code.
--
Thanks
David Voo
http://communities.msn.com.my/VisualBasicwithNeo
begin 666 ot_Submit.asp
M/"5 ($QA;F=U86=E/59"4V-R:7!T("4^#0H\)0T*"5-U8B!);G-E<G1296,H
M*0T*"0ED:6T@;&]#;VYN+"!L;T-M9"P@;&YG4F5C<RP@;&YG061D960-"@D)
M<V5T(&QO0V]N;B ]('-E<G9E<BY#<F5A=&5/8FIE8W0H(D%$3T1"+D-O;FYE
M8W1I;VXB*0T*"0EL;T-O;FXN3W!E;B B4')O=FED97(]4U%,3TQ%1$(N,3M0
M97)S:7-T(%-E8W5R:71Y/51R=64[57-E<B!)9#UC4&%Y<F]L;%],;V=I;CM0
M87-S=V]R9#TQ,C,[1&%T82!3;W5R8V4]155#1$5605!0,3M);FET:6%L($-A
M=&%L;V<]9&)C4&%Y<F]L;"(-"@D)<V5T(&QO0VUD(#T@<V5R=F5R+D-R96%T
M94]B:F5C="@B041/1$(N0V]M;6%N9"(I#0H)"7=I=&@@;&]#;60-"@D)"2Y!
M8W1I=F5#;VYN96-T:6]N/2!L;T-O;FX-"@D)"2Y#;VUM86YD5&5X=#T@(G-P
M16YT<GDB#0H)"0DN0V]M;6%N9%1Y<&4](&%D0VUD4W1O<F5D4')O8PT*"0D)
M)TYO=R!C<F5A=&4@<&%R86UE=&5R(&]B:F5C=',-"@D)"2Y087)A;65T97)S
M+D%P<&5N9"@N0W)E871E4&%R86UE=&5R*")215154DY?5D%,544B+"!A9$EN
M=&5G97(L861087)A;5)E='5R;E9A;'5E*2D-"@D)"2Y087)A;65T97)S+D%P
M<&5N9"@N0W)E871E4&%R86UE=&5R*") 16UP:60B+&%D5F%R0VAA<BQA9%!A
M<F%M26YP=70L."DI#0H)"0DN4&%R86UE=&5R<RY!<'!E;F0H+D-R96%T95!A
M<F%M971E<B@B...'1R;F-O9&4B+&%D5F%R0VAA<BQA9%!A<F%M26YP=70L-2DI
M#0H)"0DN4&%R86UE=&5R<RY!<'!E;F0H+D-R96%T95!A<F%M971E<B@B...&1A
M>71Y<&4B+&%D5F%R0VAA<BQA9%!A<F%M26YP=70L,2DI#0H)"0DN4&%R86UE
M=&5R<RY!<'!E;F0H+D-R96%T95!A<F%M971E<B@B...&1A=&4B+&%D1&%T92QA
M9%!A<F%M26YP=70I*0T*"0D)+E!A<F%M971E<G,N07!P96YD*"Y#<F5A=&50
M87)A;65T97(H(D!T:6UE0F5G(BQA9$1O=6)L92QA9%!A<F%M26YP=70I*0T*
M"0D)+E!A<F%M971E<G,N07!P96YD*"Y#<F5A=&5087)A;65T97(H(D!T:6UE
M16YD(BQA9$1O=6)L92QA9%!A<F%M26YP=70I*0T*"0D)+E!A<F%M971E<G,N
M07!P96YD*"Y#<F5A=&5087)A;65T97(H(D!C=&EM94)E9R(L861687)#:&%R
M+&%D4&%R86U);G!U="PQ*2D-"@D)"2Y087)A;65T97)S+D%P<&5N9"@N0W)E
M871E4&%R86UE=&5R*") 8W1I;65%;F0B+&%D5F%R0VAA<BQA9%!A<F%M26YP
M=70L,2DI#0H)"0DN4&%R86UE=&5R<RY!<'!E;F0H+D-R96%T95!A<F%M971E
M<B@B...')E87-O;B(L861);G1E9V5R+&%D4&%R86U);G!U="DI#0H)"0DN4&%R
M86UE=&5R<RY!<'!E;F0H+D-R96%T95!A<F%M971E<B@B...&)R86YC:&-O9&4B
M+&%D5F%R0VAA<BQA9%!A<F%M26YP=70L-"DI#0H)"0DN4&%R86UE=&5R<RY!
M<'!E;F0H+D-R96%T95!A<F%M971E<B@B...&1E<'1C;V1E(BQA9$EN=&5G97(L
M861087)A;4EN<'5T*2D-"@D)"2Y087)A;65T97)S+D%P<&5N9"@N0W)E871E
M4&%R86UE=&5R*") <F5G:6]N(BQA9$EN=&5G97(L861087)A;4EN<'5T*2D-
M"@D)"2<N4&%R86UE=&5R<RY!<'!E;F0H+D-R96%T95!A<F%M971E<B@B...')E
M;6%R:R(L861687)#:&%R+&%D4&%R86U);G!U="PU,"DI#0H)"0DG4V5T('1H
M92!P87)A;65T97(@=F%L=64-"@D)"2Y087)A;65T97)S*") 96UP:60B*2 ]
M(&-S='(H:65M<&ED*0T*"0D)+E!A<F%M971E<G,H(D!T<FYC;V1E(BD@/2!C
M<W1R*'1R;F-O9&4I#0H)"0DN4&%R86UE=&5R<R@B...&1A>71Y<&4B*2 ](&-S
M='(H9&%Y='EP92D-"@D)"2Y087)A;65T97)S*") 9&%T92(I(#T@9...'1I;64-
M"@D)"2Y087)A;65T97)S*") =&EM94)E9R(I(#T@8...;"AT:6UE0F5G*0T*
M"0D)+E!A<F%M971E<G,H(D!T:6UE16YD(BD@/2!C9&)L*'1I;65%;F0I#0H)
M"0DN4&%R86UE=&5R<R@B...&-T:6UE0F5G(BD@/2!C<W1R*&-T:6UE0F5G*0T*
M"0D)+E!A<F%M971E<G,H(D!C=&EM945N9"(I(#T@8...<BAC=&EM945N9"D-
M"@D)"2Y087)A;65T97)S*") <F5A<V]N(BD@/2!C9&)L*')E87-O;BD-"@D)
M"2Y087)A;65T97)S*") 8G)A;F-H8V]D92(I(#T@8...<BAB<F%N8VAC;V1E
M*0T*"0D)+E!A<F%M971E<G,H(D!D97!T8V]D92(I(#T@8...;"AD97!T8V]D
M92D-"@D)"2Y087)A;65T97)S*") <F5G:6]N(BD@/2!C9&)L*')E9VEO;BD-
M"@D)"2<N4&%R86UE=&5R<R@B...')E;6%R:R(I(#T@8...<BAR96UA<FLI#0H)
M"0DG4G5N('1H92!S=&]R960@<')O8V5D=7)E#0H)"0DN17AE8W5T92!L;F=2
M96-S+"QA9$5X96-U=&5.;U)E8V]R9',-"@D)"2=%>'1R86-T('1H92!R971U
M<FX@=F%L=64-"@D)"6QN9T%D9&5D(#T@+E!A<F%M971E<G,H(E)%5%523E]6
M04Q512(I#0H)"65N9"!W:71H#0H)"6EF(&QN9T%D9&5D(#T@,2!T:&5N#0H)
M"0ES970@;&]#;60@/2!N;W1H:6YG#0H)"0EL;T-O;FXN0VQO<V4H*0T*"0D)
M<V5T(&QO0V]N;B ](&YO=&AI;F<-"@D)"5)E<W!O;G-E+E)E9&ER96-T*"(N
M+B]E<G)O<BYA<W _96YU;3TM,S Y.29E9&5S8SU%>&ES=&EN9R!R96-O<F1S
M(&%L<F5A9'D@9...<W1S)F5H96QP/4-O;G1A8W0@4...=&5M($%D;6YI<W1R
M871O<B(I#0H)"65N9"!I9@T...*"0DG8W-T<BAI96UP:60I+"!C<W1R*'1R;F-O
M9&4I+"!C<W1R*&1A>71Y<&4I+"!C9&%T92AD=&EM92DL(&-D8FPH=&EM94)E
M9RDL(&-D8FPH=&EM945N9"DL(&-S='(H8W1I;65"96<I+"!C<W1R*&-T:6UE
M16YD*2P@8...="AR96%S;VXI+"!C<W1R*&)R86YC:&-O9&4I+"!C:6YT*&1E
M<'1C;V1E*2P@8...="AR96=I;VXI+"!C<W1R*')E;6%R:RD-"@D)<V5T(&QO
M0VUD(#T@;F]T:&EN9PT*"0EL;T-O;FXN0VQO<V4H*0T*"0ES970@;&]#;VYN
M(#T@;F]T:&EN9PT*"45N9"!3=6(-"@DG5&%K92!T:&4@8...!P<F]P<FEA=&4@
M:6YP=70@9...)O;2!O="YA<W @86YD('!R;V-E<W,@:6YS97)T#0H))RTM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+0T*"61I;2!E;7!I9"P@<VED+"!B<@T*"61I;2!I96UP:60L('1R
M;F-O9&4L(&1A>71Y<&4L(&1T:6UE+"!T:6UE0F5G#0H)9&EM('1I;65%;F0L
M(&-T:6UE8F5G+"!C=&EM965N9"P@<F5A<V]N+"!B<F%N8VAC;V1E+"!D97!T
M8V]D90T*"61I;2!R96=I;VXL(')E;6%R:PT*"7-E="!E;7!I9" ](%)E<75E
M<W0N1F]R;2@B...='AT:$5M<&ED(BD-"@ES970@<VED(#T@4...=65S="Y&;W)M
M*")T>'1H4VED(BD-"@ES970@8...(@/2!297%U97-T+D9O<FTH(G1X=&A"<B(I
M#0H)<V5T(&EE;7!I9" ](&5M<&ED#0H)<V5T('1R;F-O9&4@/2!297%U97-T
M+D9O<FTH(G1X=&A4<FY#9"(I#0H)<V5T(&)R86YC:&-O9&4@(#T@4...=65S
M="Y&;W)M*")T>'1"<F%N8V@B...*0T*"7-E="!D97!T8V]D92 ](%)E<75E<W0N
M1F]R;2@B...='AT1&5P="(I#0H)<V5T(')E9VEO;B ](%)E<75E<W0N1F]R;2@B...
M='AT4F5G(BD-"@DG4W5B($=E=$YE>'1)9"@I#0H))PED:6T@0...]N;BP@4...,-
M"@DG"7-E="!#;VYN(#T@<V5R=F5R+D-R96%T94]B:F5C="@B041/1$(N0V]N
M;F5C=&EO;B(I#0H))PE#;VYN+D]P96X@(E!R;W9I9&5R/5-13$],141"+C$[
M4&5R<VES="!396-U<FET>3U4<G5E.U5S97(@260]8U!A>7)O;&Q?3&]G:6X[
M4&%S<W=O<F0],3(S.T1A=&$@4V]U<F-E/4550T1%5D%04#$[26YI=&EA;"!#
M871A;&]G/61B8U!A>7)O;&PB#0H))PES970@4...,@/2!S97)V97(N0W)E871E
M3V)J96-T*")!1$]$0BY296-O<F1S970B*0T*"2<)<V5T(%)S(#T@0...]N;BY%
M>&5C=71E*")314Q%0U0@3...]296UA<FL@1...)/32!T8FQ?3U14<F%N($]21$52
M($)9($]?4F5M87)K(BD-"@DG"6EF(%)S+D5/1B!T:&5N#0H))PD)<F5M87)K
M(#T@,0T*"2<)"5)E<W!O;G-E+E=R:71E*')E;6%R:RD-"@DG"0E297-P;VYS
M92Y%;F0H*0T*"2<)96QS90T*"2<)"5)S+DUO=F5&:7)S="@I#0H))PD)9&\@
M=VAI;&4@;F]T(%)S+D5/1@T...*"2<)"0ER96UA<FL@/2!2<RY&:65L9',H,"DN
M5F%L=64-"@DG"0D)4G,N36]V94YE>'0H*0T*"2<)"6QO;W -"@D)"2=297-P
M;VYS92Y7<FET92AR96UA<FLI#0H)"0DG<F5M87)K(#T@8...="AR96UA<FLI
M("L@,0T*"0D))U)E<W!O;G-E+E=R:71E*')E;6%R:RD-"@D)"2=297-P;VYS
M92Y%;F0H*0T*"2<)96YD(&EF#0H))PE2<RY#;&]S92@I...#0H))PES970@4...,@
M/2!N;W1H:6YG#0H))PE#;VYN+D-L;W-E*"D-"@DG"5-E="!#;VYN(#T@;F]T
M:&EN9PT*"2=%;F0@4...#0H))U)E<W!O;G-E+E=R:71E*%)E<75E<W0N1F]R
M;2@I...*0T*"2=297-P;VYS92Y%;F0H*0T*"2<M+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T-"@DG0W)E871I;F<@8V]N
M;F5C=&EO;B!A;F0@8...]M;6%N9"!O8FIE8W0-"@D))TEN<V5R=&EN9R!I;G1O
M('1A8FQE#0H)"6EF(%)E<75E<W0N1F]R;2@B...,2(I(#P^("(B('1H96X-
M"@D)"7-E="!D87ET>7!E(#T@4...=65S="Y&;W)M*")S96Q$87E4>7!E(BD-
M"@D)"7-E="!D=&EM92 ](%)E<75E<W0N1F]R;2@B...%L96YD87(Q(BD-"@D)
M"61T:6UE(#T@8...=&4H9'1I;64I#0H)"0ED:6T@:41A>2P@:4UT:"P@:5ER
M#0H)"0EI1&%Y(#T@1...&%Y*&1T:6UE*0T*"0D):4UT:" ]($UO;G1H*&1T:6UE
M*0T*"0D):5ER(#T@6...<BAD=&EM92D-"@D)"2=D=&EM92 ](&E-=&@@)B B
M+R(@)B!I1&%Y("8@(B\B("8@:5ER#0H)"0ED=&EM92 ](&E$87D@)B B+R(@
M)B!I371H("8@(B\B("8@:5ER#0H)"0ES970@=&EM94)E9R ](%)E<75E<W0N
M1F]R;2@B...<V5L0F5G(BD@#0H)"0ET:6UE0F5G(#T@8...<BAT:6UE0F5G*0T*
M"0D))T)E9VEN#0H)"0EI9B!L96XH4F5Q=65S="Y&;W)M*")S96Q"96=M(BDI
M(#P^(#(@=&AE;@T*"0D)"71I;65"96<@/2!T:6UE0F5G("8@8...<B@B...,"(@
M)B!297%U97-T+D9O<FTH(G-E;$)E9VTB*2D-"@D)"65L<V4-"@D)"0ET:6UE
M0F5G(#T@=&EM94)E9R F(&-S='(H4F5Q=65S="Y&;W)M*")S96Q"96=M(BDI
M#0H)"0EE;F0@:68-"@D)"7-E="!T:6UE16YD(#T@4...=65S="Y&;W)M*")S
M96Q%;F0B*2 -"@D)"2=%;F0-"@D)"71I;65%;F0@/2!C<W1R*'1I;65%;F0I
M#0H)"0EI9B!L96XH4F5Q=65S="Y&;W)M*")S96Q%;F1M(BDI(#P^(#(@=&AE
M;@T*"0D)"71I;65%;F0@/2!T:6UE16YD("8@8...<B@B...,"(@)B!297%U97-T
M+D9O<FTH(G-E;$5N9&TB*2D-"@D)"65L<V4-"@D)"0ET:6UE16YD(#T@=&EM
M945N9" F(&-S='(H4F5Q=65S="Y&;W)M*")S96Q%;F1M(BDI#0H)"0EE;F0@
M:68-"@D)"7-E="!C=&EM94)E9R ](%)E<75E<W0N1F]R;2@B...<F%D:6\Q(BD-
M"@D)"7-E="!C=&EM945N9" ](%)E<75E<W0N1F]R;2@B...<F%D:6\R(BD-"@D)
M"7-E="!R96%S;VX@/2!297%U97-T+D9O<FTH(G-E;%)E87-O;B(I#0H)"0DG
M1V5T3F5X=$ED*"D-"@D)"4EN<V5R=%)E8R@I...#0H)"0DG4F5S<&]N<V4N5W)I
M=&4H(D1A>71Y<&4Z("(@)B!D87ET>7!E("8@(B!#;&%I;2!$871E.B B("8@
M9'1I;64@)B B($)E9VEN(%1I;64Z("(@)B!T:6UE0F5G("8@(B!%;F0@5...&EM
M93H@(B F('1I;65%;F0@)B B($)E9VEN($,Z("(@)B!C=&EM94)E9R F("(@
M16YD($,@.B B("8@8...;65%;F0@)B B(%)E87-O;CH@(B F(')E87-O;B F
M("(@0G)A;F-H.B B("8@8...)A;F-H8V]D92 F("(@1&5P="!#;V1E.B B("8@
M9&5P=&-O9&4@)B B(%)E9VEO;CH@(B F(')E9VEO;B @)B B/&)R/B(I#0H)
M"65N9"!I9@T...*"0EI9B!297%U97-T+D9O<FTH(F-H:S(B*2 \/B B(B!T:&5N
M#0H)"0ES970@9...&%Y='EP92 ](%)E<75E<W0N1F]R;2@B...<V5L1&%Y5'EP93(B
M*0T*"0D)<V5T(&1T:6UE(#T@4...=65S="Y&;W)M*")C86QE;F1A<C(B*0T*
M"0D)9'1I;64@/2!C9&%T92AD=&EM92D-"@D)"6E$87D@/2!$87DH9'1I;64I
M#0H)"0EI371H(#T@3...]N=&@H9'1I;64I#0H)"0EI67(@/2!996%R*&1T:6UE
M*0T*"0D)9'1I;64@/2!I1&%Y("8@(B\B("8@:4UT:" F("(O(B F(&E9<@T*
M"0D)<V5T('1I;65"96<@/2!297%U97-T+D9O<FTH(G-E;$)E9S(B*0T*"0D)
M=&EM94)E9R ](&-S='(H=&EM94)E9RD-"@D)"2="96=I;@T*"0D):68@;&5N
M*%)E<75E<W0N1F]R;2@B...<V5L0F5G;3(B*2D@/#X@,B!T:&5N#0H)"0D)=&EM
M94)E9R ]('1I;65"96<@)B!C<W1R*"(P(B F(%)E<75E<W0N1F]R;2@B...<V5L
M0F5G;3(B*2D-"@D)"65L<V4-"@D)"0ET:6UE0F5G(#T@=&EM94)E9R F(&-S
M='(H4F5Q=65S="Y&;W)M*")S96Q"96=M,B(I*0T*"0D)96YD(&EF#0H)"0ES
M970@=&EM945N9" ](%)E<75E<W0N1F]R;2@B...<V5L16YD,B(I#0H)"0ET:6UE
M16YD(#T@8...<BAT:6UE16YD*0T*"0D):68@;&5N*%)E<75E<W0N1F]R;2@B...
M<V5L16YD;3(B*2D@/#X@,B!T:&5N#0H)"0D)=&EM945N9" ]('1I;65%;F0@
M)B!C<W1R*"(P(B F(%)E<75E<W0N1F]R;2@B...<V5L16YD;3(B*2D-"@D)"65L
M<V4-"@D)"0ET:6UE16YD(#T@=&EM945N9" F(&-S='(H4F5Q=65S="Y&;W)M
M*")S96Q%;F1M,B(I*0T*"0D)96YD(&EF#0H)"0ES970@8...;65"96<@/2!2
M97%U97-T+D9O<FTH(G)A9&EO,3(B*0T*"0D)<V5T(&-T:6UE16YD(#T@4...
M=65S="Y&;W)M*")R861I;S(R(BD-"@D)"7-E="!R96%S;VX@/2!297%U97-T
M+D9O<FTH(G-E;%)E87-O;C$B*0D-"@D)"2='971.97AT260H*0T*"0D)26YS
M97)T4F5C*"D-"@D)"2=297-P;VYS92Y7<FET92@B...&%Y='EP93H@(B F(&1A
M>71Y<&4@)B B($-L86EM($1A=&4Z("(@)B!D=&EM92 F("(@0F5G:6X@5...&EM
M93H@(B F('1I;65"96<@)B B($5N9"!4:6UE.B B("8@=&EM945N9" F("(@
M0F5G:6X@0...@(B F(&-T:6UE0F5G("8@(B!%;F0@0... Z("(@)B!C=&EM945N
M9" F("(@4F5A<V]N.B B("8@<F5A<V]N("8@(B!"<F%N8V@Z...("(@)B!B<F%N
M8VAC;V1E("8@(B!$97!T($-O9&4Z("(@)B!D97!T8V]D92 F("(@4F5G:6]N
M.B B("8@<F5G:6]N("8@(CQB<CXB*0T*"0EE;F0@:68-"@D):68@4...=65S
M="Y&;W)M*")C:&LS(BD@/#X@(B(@=&AE;@T*"0D)<V5T(&1A>71Y<&4@/2!2
M97%U97-T+D9O<FTH(G-E;$1A>51Y<&4S(BD-"@D)"7-E="!D=&EM92 ](%)E
M<75E<W0N1F]R;2@B...%L96YD87(S(BD-"@D)"61T:6UE(#T@8...=&4H9'1I
M;64I#0H)"0EI1&%Y(#T@1...&%Y*&1T:6UE*0T*"0D):4UT:" ]($UO;G1H*&1T
M:6UE*0T*"0D):5ER(#T@6...<BAD=&EM92D-"@D)"61T:6UE(#T@:41A>2 F
M("(O(B F(&E-=&@@)B B+R(@)B!I67(-"@D)"7-E="!T:6UE0F5G(#T@4...
M=65S="Y&;W)M*")S96Q"96<S(BD-"@D)"71I;65"96<@/2!C<W1R*'1I;65"
M96<I#0H)"0EI9B!L96XH4F5Q=65S="Y&;W)M*")S96Q"96=M,R(I*2 \/B R
M('1H96X-"@D)"0ET:6UE0F5G(#T@=&EM94)E9R F(&-S='(H(C B("8@4...
M=65S="Y&;W)M*")S96Q"96=M,R(I*0T*"0D)96QS90T*"0D)"71I;65"96<@
M/2!T:6UE0F5G("8@8...<BA297%U97-T+D9O<FTH(G-E;$)E9VTS(BDI#0H)
M"0EE;F0@:68-"@D)"7-E="!T:6UE16YD(#T@4...=65S="Y&;W)M*")S96Q%
M;F0S(BD-"@D)"71I;65%;F0@/2!C<W1R*'1I;65%;F0I#0H)"0EI9B!L96XH
M4F5Q=65S="Y&;W)M*")S96Q%;F1M,R(I*2 \/B R('1H96X-"@D)"0ET:6UE
M16YD(#T@=&EM945N9" F(&-S='(H(C B("8@4...=65S="Y&;W)M*")S96Q%
M;F1M,R(I*0T*"0D)96QS90T*"0D)"71I;65%;F0@/2!T:6UE16YD("8@8...
M<BA297%U97-T+D9O<FTH(G-E;$5N9&TS(BDI#0H)"0EE;F0@:68-"@D)"7-E
M="!C=&EM94)E9R ](%)E<75E<W0N1F]R;2@B...<F%D:6\Q,R(I#0H)"0ES970@
M8W1I;65%;F0@/2!297%U97-T+D9O<FTH(G)A9&EO,C,B*0T*"0D)<V5T(')E
M87-O;B ](%)E<75E<W0N1F]R;2@B...<V5L4F5A<V]N,B(I"0T*"0D))T=E=$YE
M>'1)9"@I#0H)"0E);G-E<G1296,H*0T*"0D))U)E<W!O;G-E+E=R:71E*")$
M87ET>7!E.B B("8@9...&%Y='EP92 F("(@0VQA:6T@1...&%T93H@(B F(&1T:6UE
M("8@(B!"96=I;B!4:6UE.B B("8@=&EM94)E9R F("(@16YD(%1I;64Z("(@
M)B!T:6UE16YD("8@(B!"96=I;B!#.B B("8@8...;65"96<@)B B($5N9"!#
M(#H@(B F(&-T:6UE16YD("8@(B!296%S;VXZ("(@)B!R96%S;VX@)B B($)R
M86YC:#H@(B F(&)R86YC:&-O9&4@)B B($1E<'0@0...]D93H@(B F(&1E<'1C
M;V1E("8@(B!296=I;VXZ("(@)B!R96=I;VX@)B B/&)R/B(I#0H)"65N9"!I
M9@D...)#0H)"6EF(%)E<75E<W0N1F]R;2@B..."(I(#P^("(B('1H96X-"@D)
M"7-E="!D87ET>7!E(#T@4...=65S="Y&;W)M*")S96Q$87E4>7!E-"(I#0H)
M"0ES970@9...'1I;64@/2!297%U97-T+D9O<FTH(F-A;&5N9&%R-"(I#0H)"0ED
M=&EM92 ](&-D871E*&1T:6UE*0T*"0D):41A>2 ]($1A>2AD=&EM92D-"@D)
M"6E-=&@@/2!-;VYT:"AD=&EM92D-"@D)"6E9<B ](%EE87(H9'1I;64I#0H)
M"0ED=&EM92 ](&E$87D@)B B+R(@)B!I371H("8@(B\B("8@:5ER#0H)"0ES
M970@=&EM94)E9R ](%)E<75E<W0N1F]R;2@B...<V5L0F5G-"(I#0H)"0ET:6UE
M0F5G(#T@8...<BAT:6UE0F5G*0T*"0D):68@;&5N*%)E<75E<W0N1F]R;2@B...
M<V5L0F5G;30B*2D@/#X@,B!T:&5N#0H)"0D)=&EM94)E9R ]('1I;65"96<@
M)B!C<W1R*"(P(B F(%)E<75E<W0N1F]R;2@B...<V5L0F5G;30B*2D-"@D)"65L
M<V4-"@D)"0ET:6UE0F5G(#T@=&EM94)E9R F(&-S='(H4F5Q=65S="Y&;W)M
M*")S96Q"96=M-"(I*0T*"0D)96YD(&EF#0H)"0ES970@=&EM945N9" ](%)E
M<75E<W0N1F]R;2@B...<V5L16YD-"(I#0H)"0ET:6UE16YD(#T@8...<BAT:6UE
M16YD*0T*"0D):68@;&5N*%)E<75E<W0N1F]R;2@B...<V5L16YD;30B*2D@/#X@
M,B!T:&5N#0H)"0D)=&EM945N9" ]('1I;65%;F0@)B!C<W1R*"(P(B F(%)E
M<75E<W0N1F]R;2@B...<V5L16YD;30B*2D-"@D)"65L<V4-"@D)"0ET:6UE16YD
M(#T@=&EM945N9" F(&-S='(H4F5Q=65S="Y&;W)M*")S96Q%;F1M-"(I*0T*
M"0D)96YD(&EF#0H)"0ES970@8...;65"96<@/2!297%U97-T+D9O<FTH(G)A
M9&EO,30B*0T*"0D)<V5T(&-T:6UE16YD(#T@4...=65S="Y&;W)M*")R861I
M;S(T(BD-"@D)"7-E="!R96%S;VX@/2!297%U97-T+D9O<FTH(G-E;%)E87-O
M;C,B*0D-"@D)"2='971.97AT260H*0T*"0D)26YS97)T4F5C*"D-"@D)"2=2
M97-P;VYS92Y7<FET92@B...&%Y='EP93H@(B F(&1A>71Y<&4@)B B($-L86EM
M($1A=&4Z("(@)B!D=&EM92 F("(@0F5G:6X@5...&EM93H@(B F('1I;65"96<@
M)B B($5N9"!4:6UE.B B("8@=&EM945N9" F("(@0F5G:6X@0...@(B F(&-T
M:6UE0F5G("8@(B!%;F0@0... Z("(@)B!C=&EM945N9" F("(@4F5A<V]N.B B
M("8@<F5A<V]N("8@(B!"<F%N8V@Z...("(@)B!B<F%N8VAC;V1E("8@(B!$97!T
M($-O9&4Z("(@)B!D97!T8V]D92 F("(@4F5G:6]N.B B("8@<F5G:6]N("8@
M(CQB<CXB*0T*"0EE;F0@:68)"0D)#0H)"6EF(%)E<75E<W0N1F]R;2@B...
M-2(I(#P^("(B('1H96X-"@D)"7-E="!D87ET>7!E(#T@4...=65S="Y&;W)M
M*")S96Q$87E4>7!E-2(I#0H)"0ES970@9...'1I;64@/2!297%U97-T+D9O<FTH
M(F-A;&5N9&%R-2(I#0H)"0ED=&EM92 ](&-D871E*&1T:6UE*0T*"0D):41A
M>2 ]($1A>2AD=&EM92D-"@D)"6E-=&@@/2!-;VYT:"AD=&EM92D-"@D)"6E9
M<B ](%EE87(H9'1I;64I#0H)"0ED=&EM92 ](&E$87D@)B B+R(@)B!I371H
M("8@(B\B("8@:5ER#0H)"0ES970@=&EM94)E9R ](%)E<75E<W0N1F]R;2@B...
M<V5L0F5G-2(I#0H)"0ET:6UE0F5G(#T@8...<BAT:6UE0F5G*0T*"0D):68@
M;&5N*%)E<75E<W0N1F]R;2@B...<V5L0F5G;34B*2D@/#X@,B!T:&5N#0H)"0D)
M=&EM94)E9R ]('1I;65"96<@)B!C<W1R*"(P(B F(%)E<75E<W0N1F]R;2@B...
M<V5L0F5G;34B*2D-"@D)"65L<V4-"@D)"0ET:6UE0F5G(#T@=&EM94)E9R F
M(&-S='(H4F5Q=65S="Y&;W)M*")S96Q"96=M-2(I*0T*"0D)96YD(&EF#0H)
M"0ES970@=&EM945N9" ](%)E<75E<W0N1F]R;2@B...<V5L16YD-2(I#0H)"0ET
M:6UE16YD(#T@8...<BAT:6UE16YD*0T*"0D):68@;&5N*%)E<75E<W0N1F]R
M;2@B...<V5L16YD;34B*2D@/#X@,B!T:&5N#0H)"0D)=&EM945N9" ]('1I;65%
M;F0@)B!C<W1R*"(P(B F(%)E<75E<W0N1F]R;2@B...<V5L16YD;34B*2D-"@D)
M"65L<V4-"@D)"0ET:6UE16YD(#T@=&EM945N9" F(&-S='(H4F5Q=65S="Y&
M;W)M*")S96Q%;F1M-2(I*0T*"0D)96YD(&EF#0H)"0ES970@8...;65"96<@
M/2!297%U97-T+D9O<FTH(G)A9&EO,34B*0T*"0D)<V5T(&-T:6UE16YD(#T@
M4F5Q=65S="Y&;W)M*")R861I;S(U(BD-"@D)"7-E="!R96%S;VX@/2!297%U
M97-T+D9O<FTH(G-E;%)E87-O;C0B*0D-"@D)"2='971.97AT260H*0T*"0D)
M26YS97)T4F5C*"D-"@D)"2=297-P;VYS92Y7<FET92@B...&%Y='EP93H@(B F
M(&1A>71Y<&4@)B B($-L86EM($1A=&4Z("(@)B!D=&EM92 F("(@0F5G:6X@
M5&EM93H@(B F('1I;65"96<@)B B($5N9"!4:6UE.B B("8@=&EM945N9" F
M("(@0F5G:6X@0...@(B F(&-T:6UE0F5G("8@(B!%;F0@0... Z("(@)B!C=&EM
M945N9" F("(@4F5A<V]N.B B("8@<F5A<V]N("8@(B!"<F%N8V@Z...("(@)B!B
M<F%N8VAC;V1E("8@(B!$97!T($-O9&4Z("(@)B!D97!T8V]D92 F("(@4F5G
M:6]N.B B("8@<F5G:6]N("8@(CQB<CXB*0T*"0EE;F0@:68-"@D))T-H96-K
M(&9O<B!R971U<FX@=F%L=64-"@D):68@;&YG061D960@/2 P('1H96X-"@D)
M"7-E="!L;T-M9" ]($YO=&AI;F<-"@D)"5)E<W!O;G-E+E)E9&ER96-T*"(N
M+B]S=6-C97-S+F%S<#]S:60](B F('-I9" F("(F96UP:60](B F(&5M<&ED
A("8@(B9B<CTB("8@8...(I#0H)"65N9"!I9@T...*)3X-"@T*
`
end
Message #2 by "Tomm Matthis" <matthis@b...> on Tue, 31 Jul 2001 06:23:30 -0400
|
|
Check to make sure that the NT4.0 machine has the same version of MDAC (the
ADO files) installed as does the Win2K box.
-- Tomm
> -----Original Message-----
> From: David Voo [mailto:gigsvoo@y...]
> Sent: Monday, July 30, 2001 9:36 PM
> To: ASP Databases
> Subject: [asp_databases] Stored Procedure Problem
>
>
> Hi there guys,
>
> Here i got a problem using asp page passes parameter to a stored
> procedure.
> it was runned well in IIS 5 of W2k but when it migrate to a NT 4 IIS 4
> server with IE 4.01 SP2, there are some errors that cannot recognize the
> stored procedure parameter passing. When I tried to create a
> parameter with
> respective data type, it cannot be recognized, anyone can help? Its quite
> urgent.
> Attached is the source code.
>
> --
> Thanks
>
> David Voo
> http://communities.msn.com.my/VisualBasicwithNeo
>
>
>
>
|
|
|
View Cart
