I've got two issues to which I couldn't find any answers in the list
archive:
------- 1. ado.net / INSERT with parameters
driver: SAP DP 7.3 for Windows
When trying to insert rows in a table via ado.net using
OdbcDataAdapter(dataSet, tableName), I constantly receive this exception:
Microsoft.Data.Odbc.OdbcException: ERROR [23000] [SAP AG][SQLOD32
DLL]Integrity constraint violation.
There are no constraints for the used table; in fact, I have tested this
with a table consisting only of varchar(x) columns. The
DataAdapter.InsertCommand looks fine and the parameter values seem alright;
a little screen dump with a test program says
DBDataAdapter.InsertCommand.Parameters[x].DBType.Name=="AnsiString" for each
parameter.
Attached is a small fragment of the sql-trace, starting with the last
SQLBindParameter() and ending with the last SQLGetDiagRec() call.
When I use the same INSERT without parameters but inline values, it works
fine.
------- 2. connecting with driver "SQLSTUDIOODBC" (7.04.03.00)
Trying to debug the above error, I have tested connecting with version
7.04.03 of the odbc driver.
That won't work:
Microsoft.Data.Odbc.OdbcException: ERROR [08001] [SAP AG][SQLOD32 DLL][SAP
DB]Unable to connect to data source;-709 CONNECT: (unknown host name).
I've used the same connection string as with 7.03, that is:
"DRIVER={SQLSTUDIOODBC}; ServerNode=192.168.123.18; ServerDB=LCG_FoBi;
uid=xxxx; pwd=xxxx"
TIA for any help,
Markus
begin 666 sql_trace.txt
M1F]B:2U!:VLN8V]N9FEG(#-B8RUF,C@)14Y415(@4U%,0FEN9%!A<F%M971E
M<B -"@D)2%-4350@(" @(" @(" @(" @(" P,S%&,S<W. T*"0E55T]21" @
M(" @(" @(" @(" @(" @(" @(" @,C8@#0H)"5-73U)$(" @(" @(" @(" @
M(" @(" @(" @(" @,2 \4U%,7U!!4D%-7TE.4%54/@T*"0E35T]21" @(" @
M(" @(" @(" @(" @(" @(" @+3@@/%-13%]#7U=#2$%2/@T*"0E35T]21" @
M(" @(" @(" @(" @(" @(" @(" @,3(@/%-13%]605)#2$%2/@T*"0E344Q5
M3$5.(" @(" @(" @(" @(" @(" @(#$Y#0H)"5-73U)$(" @(" @(" @(" @
M(" @(" @(" @(" @," -"@D)4%12(" @(" @(" @(" @(" @(#!X,# Q0S9!
M-C@-"@D)4U%,3$5.(" @(" @(" @(" @(" @(" @(#4R, T*"0E344Q,14X@
M*B @(" @(" @(" @(#!X,# Q0S9!-3 -"@T*1F]B:2U!:VLN8V]N9FEG(#-B
M8RUF,C@)15A)5" @4U%,0FEN9%!A<F%M971E<B @=VET:"!R971U<FX@8V]D
M92 P("A344Q?4U5#0T534RD-"@D)2%-4350@(" @(" @(" @(" @(" P,S%&
M,S<W. T*"0E55T]21" @(" @(" @(" @(" @(" @(" @(" @,C8@#0H)"5-7
M3U)$(" @(" @(" @(" @(" @(" @(" @(" @,2 \4U%,7U!!4D%-7TE.4%54
M/@T*"0E35T]21" @(" @(" @(" @(" @(" @(" @(" @+3@@/%-13%]#7U=#
M2$%2/@T*"0E35T]21" @(" @(" @(" @(" @(" @(" @(" @,3(@/%-13%]6
M05)#2$%2/@T*"0E344Q53$5.(" @(" @(" @(" @(" @(" @(#$Y#0H)"5-7
M3U)$(" @(" @(" @(" @(" @(" @(" @(" @," -"@D)4%12(" @(" @(" @
M(" @(" @(#!X,# Q0S9!-C@-"@D)4U%,3$5.(" @(" @(" @(" @(" @(" @
M(#4R, T*"0E344Q,14X@*B @(" @(" @(" @(#!X,# Q0S9!-3 @*#,X*0T*
M#0I&;V)I+4%K:RYC;VYF:6<@,V)C+68R. E%3E1%4B!344Q%>&5C1&ER96-T
M5R -"@D)2%-4350@(" @(" @(" @(" @(" P,S%&,S<W. T*"0E70TA!4B J
M(" @(" @(" @(" @(#!X,#!#13)$,C @6R @(" @("TS72 B24Y315)4($E.
M5$\@=&E355]097)S;VXH($Y!344@+"!04D5.04U%4R L(%1)5$Q%7U!2149)
M6" L(%-%6" L($Y!345?0E5324Y%4U,@+"!&54Y#5$E/3E]"55-)3D534R L
M(%-44D5%5%]"55-)3D534R L($-)5%E?4U1214547T)54TE.15-3("P@4$]3
M5$-/1$5?4U1214547T)54TE.15-3("P@0T]53E1265]"55-)3D534R L(%-4
M4D5%5%]04DE6051%("P@0TE465]35%)%151?4%))5D%412 L(%!/4U1#3T1%
M7U-44D5%5%]04DE6051%("P@0T]53E1265]04DE6051%("P@4$A/3D5?0E53
M24Y%4U,Q("P@4$A/3D5?0E5324Y%4U,R("P@1D%87T)54TE.15-3("P@14U!
M24Q?0E5324Y%4U,Q("P@14U!24Q?0E5324Y%4U,R("P@5U=77T)54TE.15-3
M("P@4$A/3D5?4%))5D%413$@+"!02$].15]04DE6051%,B L($9!6%]04DE6
M051%("P@0U535$]-0T%414=/4ED@+"!&2U]355]/4D<@+"!&0DY?4U5?3U)'
M("D@5D%,5453("@@/R L(#\@+" _("P@/R L(#\@+" _("P@/R L(#\@+" _
M("P@/R L(#\@+" _("P@/R L(#\@+" _("P@/R L(#\@+" _("P@/R L(#\@
M+" _("P@/R L(#\@+" _("P@/R L(#\@*5P@,"(-"@D)4T173U)$(" @(" @
M(" @(" @(" @(" @(" M,PT*#0I&;V)I+4%K:RYC;VYF:6<@,V)C+68R. E%
M6$E4("!344Q%>&5C1&ER96-T5R @=VET:"!R971U<FX@8V]D92 M,2 H4U%,
M7T524D]2*0T*"0E(4U1-5" @(" @(" @(" @(" @(# S,48S-S<X#0H)"5=#
M2$%2("H@(" @(" @(" @(" @,'@P,$-%,D0R,"!;(" @(" @+3-=("))3E-%
M4E0@24Y43R!T:5-57U!E<G-O;B@@3D%-12 L(%!214Y!3453("P@5$E43$5?
M4%)%1DE8("P@4T58("P@3D%-15]"55-)3D534R L($953D-424].7T)54TE.
M15-3("P@4U1214547T)54TE.15-3("P@0TE465]35%)%151?0E5324Y%4U,@
M+"!03U-40T]$15]35%)%151?0E5324Y%4U,@+"!#3U5.5%)97T)54TE.15-3
M("P@4U1214547U!2259!5$4@+"!#25197U-44D5%5%]04DE6051%("P@4$]3
M5$-/1$5?4U1214547U!2259!5$4@+"!#3U5.5%)97U!2259!5$4@+"!02$].
M15]"55-)3D534S$@+"!02$].15]"55-)3D534S(@+"!&05A?0E5324Y%4U,@
M+"!%34%)3%]"55-)3D534S$@+"!%34%)3%]"55-)3D534S(@+"!75U=?0E53
M24Y%4U,@+"!02$].15]04DE6051%,2 L(%!(3TY%7U!2259!5$4R("P@1D%8
M7U!2259!5$4@+"!#55-43TU#051%1T]262 L($9+7U-57T]21R L($9"3E]3
M55]/4D<@*2!604Q515,@*" _("P@/R L(#\@+" _("P@/R L(#\@+" _("P@
M/R L(#\@+" _("P@/R L(#\@+" _("P@/R L(#\@+" _("P@/R L(#\@+" _
M("P@/R L(#\@+" _("P@/R L(#\@+" _("P@/R I7" P(@T*"0E31%=/4D0@
M(" @(" @(" @(" @(" @(" @("TS#0H-"@D)1$E!1R!;,C,P,#!=(%M305 @
M04==6U-13$]$,S(@1$Q,74EN=&5G<FET>2!C;VYS=')A:6YT('9I;VQA=&EO
M;BX@*# I( T*#0I&;V)I+4%K:RYC;VYF:6<@,V)C+68R. E%3E1%4B!344Q'
M971$:6%G4F5C5R -"@D)4U%,4TU!3$Q)3E0@(" @(" @(" @(" @(" @(" S
M( T*"0E344Q(04Y$3$4@(" @(" @(" @(# S,48S-S<X#0H)"5-13%--04Q,
M24Y4(" @(" @(" @(" @(" @(" @,2 -"@D)4U%,5T-(05(@*B @(" @(" @
M(" P># P,3A#1D$P("A.64DI( T*( D)4U%,24Y414=%4B J(" @(" @(" P
M># P,3)&-# P#0H)"5-13%=#2$%2("H@(" @(" @(" @,'@P,#%#.# Q." H
M3EE)*2 -"B )"5-13%--04Q,24Y4(" @(" @(" @(" @(" @(#4Q,B -"@D)
M4U%,4TU!3$Q)3E0@*B @(" @(" P># P,3)&,T8X#0H-"D9O8FDM06MK+F-O
M;F9I9R S8F,M9C(X"458250@(%-13$=E=$1I86=296-7("!W:71H(')E='5R
M;B!C;V1E(# @*%-13%]354-#15-3*0T*"0E344Q334%,3$E.5" @(" @(" @
M(" @(" @(" @(#,@#0H)"5-13$A!3D1,12 @(" @(" @(" @,#,Q1C,W-S@-
M"@D)4U%,4TU!3$Q)3E0@(" @(" @(" @(" @(" @(" Q( T*"0E344Q70TA!
M4B J(" @(" @(" @(#!X,# Q.$-&03 @*$Y922D@#0H@"0E344Q)3E1%1T52
M("H@(" @(" @(#!X,# Q,D8T,# @*# I#0H)"5-13%=#2$%2("H@(" @(" @
M(" @,'@P,#%#.# Q." H3EE)*2 -"B )"5-13%--04Q,24Y4(" @(" @(" @
M(" @(" @(#4Q,B -"@D)4U%,4TU!3$Q)3E0@*B @(" @(" P># P,3)&,T8X
M("@U,BD-"@T*1F]B:2U!:VLN8V]N9FEG(#-B8RUF,C@)14Y415(@4U%,1V5T
M1&EA9U)E8U<@#0H)"5-13%--04Q,24Y4(" @(" @(" @(" @(" @(" @,R -
M"@D)4U%,2$%.1$Q%(" @(" @(" @(" P,S%&,S<W. T*"0E344Q334%,3$E.
M5" @(" @(" @(" @(" @(" @(#(@#0H)"5-13%=#2$%2("H@(" @(" @(" @
M,'@P,#$X0T9!," H3EE)*2 -"B )"5-13$E.5$5'15(@*B @(" @(" @,'@P
M,#$R1C0P, T*"0E344Q70TA!4B J(" @(" @(" @(#!X,# Q0S@P,3@@*$Y9
M22D@#0H@"0E344Q334%,3$E.5" @(" @(" @(" @(" @(" U,3(@#0H)"5-1
M3%--04Q,24Y4("H@(" @(" @,'@P,#$R1C-&. T*#0I&;V)I+4%K:RYC;VYF
M:6<@,V)C+68R. E%6$E4("!344Q'971$:6%G4F5C5R @=VET:"!R971U<FX@
M8V]D92 Q,# @*%-13%].3U]$051!7T9/54Y$*0T*"0E344Q334%,3$E.5" @
M(" @(" @(" @(" @(" @(#,@#0H)"5-13$A!3D1,12 @(" @(" @(" @,#,Q
M1C,W-S@-"@D)4U%,4TU!3$Q)3E0@(" @(" @(" @(" @(" @(" R( T*"0E3
M44Q70TA!4B J(" @(" @(" @(#!X,# Q.$-&03 @*$Y922D@#0H@"0E344Q)
M3E1%1T52("H@(" @(" @(#!X,# Q,D8T,# -"@D)4U%,5T-(05(@*B @(" @
M(" @(" P># P,4,X,#$X("A.64DI( T*( D)4U%,4TU!3$Q)3E0@(" @(" @
M(" @(" @(" @-3$R( T*"0E344Q334%,3$E.5" J(" @(" @(#!X,# Q,D8S
M1C@-"@T*1F]B:2U!:VLN8V]N9FEG(#-B8RUF,C@)14Y415(@4U%,1V5T0V]N
M;F5C=$%T=')7( T*"0E344Q(1$)#(" @(" @(" @(" @(# S,48Q,S0X#0H)
M"5-13$E.5$5'15(@(" @(" @(" @(" @(" @,3(P.2 \=6YK;F]W;CX-"@D)
M4U%,4$])3E1%4B @(" @(" @(#!X,# Q0SA!0S@-"@D)4U%,24Y414=%4B @
M(" @(" @(" @(" @(" Q,#(T( T*"0E344Q)3E1%1T52("H@(" @(" @(#!X
M,# Q,D8T,$,-"@T*1F]B:2U!:VLN8V]N9FEG(#-B8RUF,C@)15A)5" @4U%,
M1V5T0V]N;F5C=$%T=')7("!W:71H(')E='5R;B!C;V1E(# @*%-13%]354-#
M15-3*0T*"0E344Q(1$)#(" @(" @(" @(" @(# S,48Q,S0X#0H)"5-13$E.
M5$5'15(@(" @(" @(" @(" @(" @,3(P.2 \=6YK;F]W;CX-"@D)4U%,4$])
M3E1%4B @(" @(" @(#!X,# Q0SA!0S@-"@D)4U%,24Y414=%4B @(" @(" @
M(" @(" @(" Q,#(T( T*"0E344Q)3E1%1T52("H@(" @(" @(#!X,# Q,D8T
&,$,@*# I
`
end
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
