pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedpgsql ODBC driver and Visual Foxpro
3+ messages / 2 participants
[nested] [flat]
* pgsql ODBC driver and Visual Foxpro
@ 2000-02-27 14:16 Willy De la Court <Willy.DelaCourt@pandora.be>
0 siblings, 1 reply; 3+ messages in thread
From: Willy De la Court @ 2000-02-27 14:16 UTC (permalink / raw)
To: pgsql-interfaces
Hi,
I'v got the following problem with Visual Foxpro (VFP) and using the pgsql ODBC driver.
With Visual Foxpro it is possible to create parametrized views it looks something like this.
create sql view xxx remote connection bms as select * from peo where peo_name = 'A' and peo_code = ?ncode
where '?ncode' is the parameter. Normaly the ?ncode is replaced before the select statement is send to the backend.
visual foxpro will try first to send the query unmodified to the backend.
and always it gets an error from the backend. Here is a piece of the log.
statement_type=0, statement='select * from peo where peo_name = 'A' and peo_code = ?'
stmt_with_params='select * from peo where peo_name = 'A' and peo_code = '
Then VFP even after it got an error it will try to get the number of rows returned.
STATEMENT ERROR: func=SQLNumResultCols, desc='', errnum=3, errmsg='No query has been executed with that handle'
This error message is also normal.
Then VFP tries to execute an SQLExecDirect with "select * from peo WHERE 0=1"
and this fails also which is not normal.
STATEMENT ERROR: func=SQLExecute, desc='', errnum=2, errmsg='The handle does not point to a statement that is ready to be executed'
AND LOOK AT THESE 2 LINES IN THE LOGFILE.
statement_type=0, statement='select * from peo WHERE 1=0'
stmt_with_params='select * from peo where peo_name = 'A' and peo_code = '
What happend here???????
Can somebody please help me with this I need the odbc driver to work with visual foxpro.
PS normal SQL statements without the functionality of parameters work great.
Included are both the sql.log and the psqlodbc.log
begin 600 SQL.LOG
M#0I61E V(" @(" @(" @(" @9F9F8C-B93<Z9F9F.&0V86()14Y415(@4U%,
M06QL;V-#;VYN96-T( T*"0E(14Y6(" @(" @(" @(" @(" @(#!X,#)D-F9F
M,6,-"@D)2$1"0R J(" @(" @(" @(" @(" P># P83-F-#4T#0H-"E9&4#8@
M(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%6$E4("!344Q!;&QO8T-O
M;FYE8W0@('=I=&@@<F5T=7)N(&-O9&4@," H4U%,7U-50T-%4U,I#0H)"4A%
M3E8@(" @(" @(" @(" @(" @,'@P,F0V9F8Q8PT*"0E(1$)#("H@(" @(" @
M(" @(" @(#!X,#!A,V8T-30@*" P># R8S<P83,T*0T*#0I61E V(" @(" @
M(" @(" @9F9F8C-B93<Z9F9F.&0V86()14Y415(@4U%,4V5T0V]N;F5C=$]P
M=&EO;B -"@D)2$1"0R @(" @(" @(" @(" @(" P># R8S<P83,T#0H)"557
M3U)$(" @(" @(" @(" @(" @(" @(" @(#$P,R \4U%,7TQ/1TE.7U1)345/
M550^#0H)"55$5T]21" @(" @(" @(" @(" @(" @(" @,34-"@T*5D90-B @
M(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"458250@(%-13%-E=$-O;FYE
M8W1/<'1I;VX@('=I=&@@<F5T=7)N(&-O9&4@," H4U%,7U-50T-%4U,I#0H)
M"4A$0D,@(" @(" @(" @(" @(" @,'@P,F,W,&$S- T*"0E55T]21" @(" @
M(" @(" @(" @(" @(" @(" Q,#,@/%-13%],3T=)3E]424U%3U54/@T*"0E5
M1%=/4D0@(" @(" @(" @(" @(" @(" @(#$U#0H-"E9&4#8@(" @(" @(" @
M("!F9F9B,V)E-SIF9F8X9#9A8@E%3E1%4B!344Q3971#;VYN96-T3W!T:6]N
M( T*"0E(1$)#(" @(" @(" @(" @(" @(#!X,#)C-S!A,S0-"@D)55=/4D0@
M(" @(" @(" @(" @(" @(" @(" @,3$R(#Q344Q?4$%#2T547U-)6D4^#0H)
M"55$5T]21" @(" @(" @(" @(" @(" @(#0P.38-"@T*5D90-B @(" @(" @
M(" @(&9F9F(S8F4W.F9F9CAD-F%B"458250@(%-13%-E=$-O;FYE8W1/<'1I
M;VX@('=I=&@@<F5T=7)N(&-O9&4@," H4U%,7U-50T-%4U,I#0H)"4A$0D,@
M(" @(" @(" @(" @(" @,'@P,F,W,&$S- T*"0E55T]21" @(" @(" @(" @
M(" @(" @(" @(" Q,3(@/%-13%]004-+151?4TE:13X-"@D)54173U)$(" @
M(" @(" @(" @(" @(" @-# Y-@T*#0I61E V(" @(" @(" @(" @9F9F8C-B
M93<Z9F9F.&0V86()14Y415(@4U%,4V5T0V]N;F5C=$]P=&EO;B -"@D)2$1"
M0R @(" @(" @(" @(" @(" P># R8S<P83,T#0H)"5573U)$(" @(" @(" @
M(" @(" @(" @(" @(#$P,B \4U%,7T%55$]#3TU-250^#0H)"55$5T]21" @
M(" @(" @(" @(" @(" @(" @(#$-"@T*5D90-B @(" @(" @(" @(&9F9F(S
M8F4W.F9F9CAD-F%B"458250@(%-13%-E=$-O;FYE8W1/<'1I;VX@('=I=&@@
M<F5T=7)N(&-O9&4@," H4U%,7U-50T-%4U,I#0H)"4A$0D,@(" @(" @(" @
M(" @(" @,'@P,F,W,&$S- T*"0E55T]21" @(" @(" @(" @(" @(" @(" @
M(" Q,#(@/%-13%]!551/0T]-34E4/@T*"0E51%=/4D0@(" @(" @(" @(" @
M(" @(" @(" Q#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A
M8@E%3E1%4B!344Q$<FEV97)#;VYN96-T5R -"@D)2$1"0R @(" @(" @(" @
M(" @(" P># R8S<P83,T#0H)"4A73D0@(" @(" @(" @(" @(" @,'@P,# P
M,#EA. T*"0E70TA!4B J(" @(" @(" @(" @(#!X,68T8F4P-C@@6R @(" @
M("TS72 B*BHJ*BHJ7" P(@T*"0E35T]21" @(" @(" @(" @(" @(" @(" @
M(" @+3,@#0H)"5=#2$%2("H@(" @(" @(" @(" @,'@Q9C1B93 V." -"@D)
M4U=/4D0@(" @(" @(" @(" @(" @(" @(" @(" X( T*"0E35T]21" J(" @
M(" @(" @(" @(#!X,# P,# P,# -"@D)55=/4D0@(" @(" @(" @(" @(" @
M(" @(" @(" Q(#Q344Q?1%))5D527T-/35!,151%/@T*#0I61E V(" @(" @
M(" @(" @9F9F8C-B93<Z9F9F.&0V86()15A)5" @4U%,1')I=F5R0V]N;F5C
M=%<@('=I=&@@<F5T=7)N(&-O9&4@," H4U%,7U-50T-%4U,I#0H)"4A$0D,@
M(" @(" @(" @(" @(" @,'@P,F,W,&$S- T*"0E(5TY$(" @(" @(" @(" @
M(" @(#!X,# P,# Y83@-"@D)5T-(05(@*B @(" @(" @(" @(" P>#%F-&)E
M,#8X(%L@(" @(" M,UT@(BHJ*BHJ*EP@,"(-"@D)4U=/4D0@(" @(" @(" @
M(" @(" @(" @(" @("TS( T*"0E70TA!4B J(" @(" @(" @(" @(#!X,68T
M8F4P-C@@#0H)"5-73U)$(" @(" @(" @(" @(" @(" @(" @(" @." -"@D)
M4U=/4D0@*B @(" @(" @(" @(" P># P,# P,# P#0H)"5573U)$(" @(" @
M(" @(" @(" @(" @(" @(" @,2 \4U%,7T12259%4E]#3TU03$5413X-"@T*
M5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$%L
M;&]C4W1M=" -"@D)2$1"0R @(" @(" @(" @(" @(" P># R8S<P83,T#0H)
M"4A35$U4("H@(" @(" @(" @(" @,'@P,&$S9C0U, T*#0I61E V(" @(" @
M(" @(" @9F9F8C-B93<Z9F9F.&0V86()15A)5" @4U%,06QL;V-3=&UT("!W
M:71H(')E='5R;B!C;V1E(# @*%-13%]354-#15-3*0T*"0E(1$)#(" @(" @
M(" @(" @(" @(#!X,#)C-S!A,S0-"@D)2%-4350@*B @(" @(" @(" @(" P
M># P83-F-#4P("@@,'@P,F,W,38P-"D-"@T*5D90-B @(" @(" @(" @(&9F
M9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13%-E=%-T;71/<'1I;VX@#0H)"4A3
M5$U4(" @(" @(" @(" @(" @,'@P,F,W,38P- T*"0E55T]21" @(" @(" @
M(" @(" @(" @(" @(" @(# @/%-13%]1545265]424U%3U54/@T*"0E51%=/
M4D0@(" @(" @(" @(" @(" @(" @(" P#0H-"E9&4#8@(" @(" @(" @("!F
M9F9B,V)E-SIF9F8X9#9A8@E%6$E4("!344Q39713=&UT3W!T:6]N("!W:71H
M(')E='5R;B!C;V1E(# @*%-13%]354-#15-3*0T*"0E(4U1-5" @(" @(" @
M(" @(" @(#!X,#)C-S$V,#0-"@D)55=/4D0@(" @(" @(" @(" @(" @(" @
M(" @(" P(#Q344Q?455%4EE?5$E-14]55#X-"@D)54173U)$(" @(" @(" @
M(" @(" @(" @(" @, T*#0I61E V(" @(" @(" @(" @9F9F8C-B93<Z9F9F
M.&0V86()14Y415(@4U%,4V5T4W1M=$]P=&EO;B -"@D)2%-4350@(" @(" @
M(" @(" @(" P># R8S<Q-C T#0H)"5573U)$(" @(" @(" @(" @(" @(" @
M(" @(" @-" \4U%,7T%364Y#7T5.04),13X-"@D)54173U)$(" @(" @(" @
M(" @(" @(" @(" @, T*#0I61E V(" @(" @(" @(" @9F9F8C-B93<Z9F9F
M.&0V86()15A)5" @4U%,4V5T4W1M=$]P=&EO;B @=VET:"!R971U<FX@8V]D
M92 P("A344Q?4U5#0T534RD-"@D)2%-4350@(" @(" @(" @(" @(" P># R
M8S<Q-C T#0H)"5573U)$(" @(" @(" @(" @(" @(" @(" @(" @-" \4U%,
M7T%364Y#7T5.04),13X-"@D)54173U)$(" @(" @(" @(" @(" @(" @(" @
M, T*#0I61E V(" @(" @(" @(" @9F9F8C-B93<Z9F9F.&0V86()14Y415(@
M4U%,1V5T26YF;U<@#0H)"4A$0D,@(" @(" @(" @(" @(" @,'@P,F,W,&$S
M- T*"0E55T]21" @(" @(" @(" @(" @(" @(" @(" @(#8@/%-13%]$4DE6
M15)?3D%-13X-"@D)4%12(" @(" @(" @(" @(" @(" P># R8S<Q,6%C( T*
M"0E35T]21" @(" @(" @(" @(" @(" @(" @(" Q,C@@#0H)"5-73U)$("H@
M(" @(" @(" @(" @,'@P,&$S9C%D-@T*#0I61E V(" @(" @(" @(" @9F9F
M8C-B93<Z9F9F.&0V86()15A)5" @4U%,1V5T26YF;U<@('=I=&@@<F5T=7)N
M(&-O9&4@," H4U%,7U-50T-%4U,I#0H)"4A$0D,@(" @(" @(" @(" @(" @
M,'@P,F,W,&$S- T*"0E55T]21" @(" @(" @(" @(" @(" @(" @(" @(#8@
M/%-13%]$4DE615)?3D%-13X-"@D)4%12(" @(" @(" @(" @(" @(" P># R
M8S<Q,6%C(%L@(" @(" R-%T@(E!344Q/1$)#+D1,3"(-"@D)4U=/4D0@(" @
M(" @(" @(" @(" @(" @(" @,3(X( T*"0E35T]21" J(" @(" @(" @(" @
M(#!X,#!A,V8Q9#8@*#(T*0T*#0I61E V(" @(" @(" @(" @9F9F8C-B93<Z
M9F9F.&0V86()14Y415(@4U%,1V5T26YF;U<@#0H)"4A$0D,@(" @(" @(" @
M(" @(" @,'@P,F,W,&$S- T*"0E55T]21" @(" @(" @(" @(" @(" @(" @
M(" @,3<@/%-13%]$0DU37TY!344^#0H)"5!44B @(" @(" @(" @(" @(" @
M,'@P,F,W,&8P-" -"@D)4U=/4D0@(" @(" @(" @(" @(" @(" @(" @,3(X
M( T*"0E35T]21" J(" @(" @(" @(" @(#!X,#!A,V8Q9#8-"@T*5D90-B @
M(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"458250@(%-13$=E=$EN9F]7
M("!W:71H(')E='5R;B!C;V1E(# @*%-13%]354-#15-3*0T*"0E(1$)#(" @
M(" @(" @(" @(" @(#!X,#)C-S!A,S0-"@D)55=/4D0@(" @(" @(" @(" @
M(" @(" @(" @(#$W(#Q344Q?1$)-4U].04U%/@T*"0E05%(@(" @(" @(" @
M(" @(" @(#!X,#)C-S!F,#0@6R @(" @(#(P72 B4&]S=&=R95-13"(-"@D)
M4U=/4D0@(" @(" @(" @(" @(" @(" @(" @,3(X( T*"0E35T]21" J(" @
M(" @(" @(" @(#!X,#!A,V8Q9#8@*#(P*0T*#0I61E V(" @(" @(" @(" @
M9F9F8C-B93<Z9F9F.&0V86()14Y415(@4U%,1V5T26YF;U<@#0H)"4A$0D,@
M(" @(" @(" @(" @(" @,'@P,F,W,&$S- T*"0E55T]21" @(" @(" @(" @
M(" @(" @(" @(" @-S<@/%-13%]$4DE615)?3T1"0U]615(^#0H)"5!44B @
M(" @(" @(" @(" @(" @,'@P,F,W,#@X-" -"@D)4U=/4D0@(" @(" @(" @
M(" @(" @(" @(" @,3(X( T*"0E35T]21" J(" @(" @(" @(" @(#!X,#!A
M,V8Q9#8-"@T*5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"458
M250@(%-13$=E=$EN9F]7("!W:71H(')E='5R;B!C;V1E(# @*%-13%]354-#
M15-3*0T*"0E(1$)#(" @(" @(" @(" @(" @(#!X,#)C-S!A,S0-"@D)55=/
M4D0@(" @(" @(" @(" @(" @(" @(" @(#<W(#Q344Q?1%))5D527T]$0D-?
M5D52/@T*"0E05%(@(" @(" @(" @(" @(" @(#!X,#)C-S X.#0@6R @(" @
M(#$P72 B,#(N,# B#0H)"5-73U)$(" @(" @(" @(" @(" @(" @(" @(#$R
M." -"@D)4U=/4D0@*B @(" @(" @(" @(" P># P83-F,60V("@Q,"D-"@T*
M5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$=E
M=$EN9F]7( T*"0E(1$)#(" @(" @(" @(" @(" @(#!X,#)C-S!A,S0-"@D)
M55=/4D0@(" @(" @(" @(" @(" @(" @(" @(#0W(#Q344Q?55-%4E].04U%
M/@T*"0E05%(@(" @(" @(" @(" @(" @(#!X,#)C-S X.#0@#0H)"5-73U)$
M(" @(" @(" @(" @(" @(" @(" @(#$R." -"@D)4U=/4D0@*B @(" @(" @
M(" @(" P># P83-F,60V#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF
M9F8X9#9A8@E%6$E4("!344Q'971);F9O5R @=VET:"!R971U<FX@8V]D92 P
M("A344Q?4U5#0T534RD-"@D)2$1"0R @(" @(" @(" @(" @(" P># R8S<P
M83,T#0H)"5573U)$(" @(" @(" @(" @(" @(" @(" @(" T-R \4U%,7U53
M15)?3D%-13X-"@D)4%12(" @(" @(" @(" @(" @(" P># R8S<P.#@T(%L@
M(" @(" @-ET@(G=D;"(-"@D)4U=/4D0@(" @(" @(" @(" @(" @(" @(" @
M,3(X( T*"0E35T]21" J(" @(" @(" @(" @(#!X,#!A,V8Q9#8@*#8I#0H-
M"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%3E1%4B!344Q'
M971);F9O5R -"@D)2$1"0R @(" @(" @(" @(" @(" P># R8S<P83,T#0H)
M"5573U)$(" @(" @(" @(" @(" @(" @(" @(" R." \4U%,7TE$14Y4249)
M15)?0T%313X-"@D)4%12(" @(" @(" @(" @(" @(" P># P83-F,60T#0H)
M"5-73U)$(" @(" @(" @(" @(" @(" @(" @(" @,B -"@D)4U=/4D0@*B @
M(" @(" @(" @(" P># P83-F,60V#0H-"E9&4#8@(" @(" @(" @("!F9F9B
M,V)E-SIF9F8X9#9A8@E%6$E4("!344Q'971);F9O5R @=VET:"!R971U<FX@
M8V]D92 P("A344Q?4U5#0T534RD-"@D)2$1"0R @(" @(" @(" @(" @(" P
M># R8S<P83,T#0H)"5573U)$(" @(" @(" @(" @(" @(" @(" @(" R." \
M4U%,7TE$14Y4249)15)?0T%313X-"@D)4%12(" @(" @(" @(" @(" @(" P
M># P83-F,60T("@R*0T*"0E35T]21" @(" @(" @(" @(" @(" @(" @(" @
M(#(@#0H)"5-73U)$("H@(" @(" @(" @(" @,'@P,&$S9C%D-B H,BD-"@T*
M5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$=E
M=$EN9F]7( T*"0E(1$)#(" @(" @(" @(" @(" @(#!X,#)C-S!A,S0-"@D)
M55=/4D0@(" @(" @(" @(" @(" @(" @(" @(#(Y(#Q344Q?241%3E1)1DE%
M4E]154]415]#2$%2/@T*"0E05%(@(" @(" @(" @(" @(" @(#!X,#)C-S!F
M,#0@#0H)"5-73U)$(" @(" @(" @(" @(" @(" @(" @(#$R." -"@D)4U=/
M4D0@*B @(" @(" @(" @(" P># P83-F,60V#0H-"E9&4#8@(" @(" @(" @
M("!F9F9B,V)E-SIF9F8X9#9A8@E%6$E4("!344Q'971);F9O5R @=VET:"!R
M971U<FX@8V]D92 P("A344Q?4U5#0T534RD-"@D)2$1"0R @(" @(" @(" @
M(" @(" P># R8S<P83,T#0H)"5573U)$(" @(" @(" @(" @(" @(" @(" @
M(" R.2 \4U%,7TE$14Y4249)15)?455/5$5?0TA!4CX-"@D)4%12(" @(" @
M(" @(" @(" @(" P># R8S<P9C T(%L@(" @(" @,ET@(B(B#0H)"5-73U)$
M(" @(" @(" @(" @(" @(" @(" @(#$R." -"@D)4U=/4D0@*B @(" @(" @
M(" @(" P># P83-F,60V("@R*0T*#0I61E V(" @(" @(" @(" @9F9F8C-B
M93<Z9F9F.&0V86()14Y415(@4U%,1V5T26YF;U<@#0H)"4A$0D,@(" @(" @
M(" @(" @(" @,'@P,F,W,&$S- T*"0E55T]21" @(" @(" @(" @(" @(" @
M(" @(" @-#$@/%-13%]#051!3$]'7TY!345?4T5005)!5$]2/@T*"0E05%(@
M(" @(" @(" @(" @(" @(#!X,#)C-S X.#0@#0H)"5-73U)$(" @(" @(" @
M(" @(" @(" @(" @(#$R." -"@D)4U=/4D0@*B @(" @(" @(" @(" P># P
M83-F,60V#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%
M6$E4("!344Q'971);F9O5R @=VET:"!R971U<FX@8V]D92 P("A344Q?4U5#
M0T534RD-"@D)2$1"0R @(" @(" @(" @(" @(" P># R8S<P83,T#0H)"557
M3U)$(" @(" @(" @(" @(" @(" @(" @(" T,2 \4U%,7T-!5$%,3T=?3D%-
M15]315!!4D%43U(^#0H)"5!44B @(" @(" @(" @(" @(" @,'@P,F,W,#@X
M-" -"@D)4U=/4D0@(" @(" @(" @(" @(" @(" @(" @,3(X( T*"0E35T]2
M1" J(" @(" @(" @(" @(#!X,#!A,V8Q9#8@*# I#0H-"E9&4#8@(" @(" @
M(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%3E1%4B!344Q'971);F9O5R -"@D)
M2$1"0R @(" @(" @(" @(" @(" P># R8S<P83,T#0H)"5573U)$(" @(" @
M(" @(" @(" @(" @(" @(" S-B \4U%,7TU53%1?4D5354Q47U-%5%,^#0H)
M"5!44B @(" @(" @(" @(" @(" @,'@P,F,W,&8P-" -"@D)4U=/4D0@(" @
M(" @(" @(" @(" @(" @(" @,3(X( T*"0E35T]21" J(" @(" @(" @(" @
M(#!X,#!A,V8Q9#8-"@T*5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD
M-F%B"458250@(%-13$=E=$EN9F]7("!W:71H(')E='5R;B!C;V1E(# @*%-1
M3%]354-#15-3*0T*"0E(1$)#(" @(" @(" @(" @(" @(#!X,#)C-S!A,S0-
M"@D)55=/4D0@(" @(" @(" @(" @(" @(" @(" @(#,V(#Q344Q?355,5%]2
M15-53%1?4T544SX-"@D)4%12(" @(" @(" @(" @(" @(" P># R8S<P9C T
M(%L@(" @(" @,ET@(EDB#0H)"5-73U)$(" @(" @(" @(" @(" @(" @(" @
M(#$R." -"@D)4U=/4D0@*B @(" @(" @(" @(" P># P83-F,60V("@R*0T*
M#0I61E V(" @(" @(" @(" @9F9F8C-B93<Z9F9F.&0V86()14Y415(@4U%,
M4')E<&%R92 -"@D)2%-4350@(" @(" @(" @(" @(" P># R8S<Q-C T#0H)
M"55#2$%2("H@(" @(" @(" @(" @,'@P,31B8C=B8R!;(" @(" @+3-=(")S
M96QE8W0@*B!F<F]M('!E;R!W:&5R92!P96]?;F%M92 @/2 G02<@86YD('!E
M;U]C;V1E(#T@/UP@,"(-"@D)4T173U)$(" @(" @(" @(" @(" @(" @(" M
M,PT*#0I61E V(" @(" @(" @(" @9F9F8C-B93<Z9F9F.&0V86()15A)5" @
M4U%,4')E<&%R92 @=VET:"!R971U<FX@8V]D92 P("A344Q?4U5#0T534RD-
M"@D)2%-4350@(" @(" @(" @(" @(" P># R8S<Q-C T#0H)"55#2$%2("H@
M(" @(" @(" @(" @,'@P,31B8C=B8R!;(" @(" @+3-=(")S96QE8W0@*B!F
M<F]M('!E;R!W:&5R92!P96]?;F%M92 @/2 G02<@86YD('!E;U]C;V1E(#T@
M/UP@,"(-"@D)4T173U)$(" @(" @(" @(" @(" @(" @(" M,PT*#0I61E V
M(" @(" @(" @(" @9F9F8C-B93<Z9F9F.&0V86()14Y415(@4U%,3G5M4F5S
M=6QT0V]L<R -"@D)2%-4350@(" @(" @(" @(" @(" P># R8S<Q-C T#0H)
M"5-73U)$("H@(" @(" @(" @(" @,'@P,&$S9C,T,@T*#0I61E V(" @(" @
M(" @(" @9F9F8C-B93<Z9F9F.&0V86()15A)5" @4U%,3G5M4F5S=6QT0V]L
M<R @=VET:"!R971U<FX@8V]D92 M,2 H4U%,7T524D]2*0T*"0E(4U1-5" @
M(" @(" @(" @(" @(#!X,#)C-S$V,#0-"@D)4U=/4D0@*B @(" @(" @(" @
M(" P># P83-F,S0R#0H-"@D)1$E!1R!;4S$P,3!=($YO('%U97)Y(&AA<R!B
M965N(&5X96-U=&5D('=I=&@@=&AA="!H86YD;&4[#0I%4E)/4CH@('!A<G-E
M<CH@<&%R<V4@97)R;W(@870@;W(@;F5A<B B(B H,RD@#0H-"E9&4#8@(" @
M(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%3E1%4B!344Q%>&5C1&ER96-T
M( T*"0E(4U1-5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0-"@D)54-(05(@
M*B @(" @(" @(" @(" P># Q-&)B-V)C(%L@(" @(" M,UT@(G-E;&5C=" J
M(&9R;VT@<&5O("!72$5212 Q/3!<(# B#0H)"5-$5T]21" @(" @(" @(" @
M(" @(" @(" @+3,-"@T*5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD
M-F%B"458250@(%-13$5X96-$:7)E8W0@('=I=&@@<F5T=7)N(&-O9&4@+3$@
M*%-13%]%4E)/4BD-"@D)2%-4350@(" @(" @(" @(" @(" P># R8S<Q-C T
M#0H)"55#2$%2("H@(" @(" @(" @(" @,'@P,31B8C=B8R!;(" @(" @+3-=
M(")S96QE8W0@*B!F<F]M('!E;R @5TA%4D4@,3TP7" P(@T*"0E31%=/4D0@
M(" @(" @(" @(" @(" @(" @("TS#0H-"@D)1$E!1R!;4S$P,3!=(%1H92!H
M86YD;&4@9&]E<R!N;W0@<&]I;G0@=&\@82!S=&%T96UE;G0@=&AA="!I<R!R
M96%D>2!T;R!B92!E>&5C=71E9#L-"D524D]2.B @<&%R<V5R.B!P87)S92!E
M<G)O<B!A="!O<B!N96%R("(B("@R*2 -"@T*5D90-B @(" @(" @(" @(&9F
M9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$5R<F]R5R -"@D)2$5.5B @(" @
M(" @(" @(" @(" P># R9#9F9C%C#0H)"4A$0D,@(" @(" @(" @(" @(" @
M,'@P,F,W,&$S- T*"0E(4U1-5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0-
M"@D)5T-(05(@*B @(" @(" @(" @(" P># P83-E9#!C("A.64DI( T*( D)
M4T173U)$("H@(" @(" @(" @(" P># P83-F,6,T#0H)"5=#2$%2("H@(" @
M(" @(" @(" @,'@P,&$S93DP8R -"@D)4U=/4D0@(" @(" @(" @(" @(" @
M(" @(" @-3$R( T*"0E35T]21" J(" @(" @(" @(" @(#!X,#!A,V8Q8V$-
M"@T*5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"458250@(%-1
M3$5R<F]R5R @=VET:"!R971U<FX@8V]D92 P("A344Q?4U5#0T534RD-"@D)
M2$5.5B @(" @(" @(" @(" @(" P># R9#9F9C%C#0H)"4A$0D,@(" @(" @
M(" @(" @(" @,'@P,F,W,&$S- T*"0E(4U1-5" @(" @(" @(" @(" @(#!X
M,#)C-S$V,#0-"@D)5T-(05(@*B @(" @(" @(" @(" P># P83-E9#!C("A.
M64DI( T*( D)4T173U)$("H@(" @(" @(" @(" P># P83-F,6,T("@R*0T*
M"0E70TA!4B J(" @(" @(" @(" @(#!X,#!A,V4Y,&,@6R @(" @,3$R72 B
M5&AE(&AA;F1L92!D;V5S(&YO="!P;VEN="!T;R!A('-T871E;65N="!T:&%T
M(&ES(')E861Y('0B#0H)"5-73U)$(" @(" @(" @(" @(" @(" @(" @(#4Q
M,B -"@D)4U=/4D0@*B @(" @(" @(" @(" P># P83-F,6-A("@Q,3(I#0H-
M"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%3E1%4B!344Q%
M<G)O<E<@#0H)"4A%3E8@(" @(" @(" @(" @(" @,'@P,F0V9F8Q8PT*"0E(
M1$)#(" @(" @(" @(" @(" @(#!X,#)C-S!A,S0-"@D)2%-4350@(" @(" @
M(" @(" @(" P># R8S<Q-C T#0H)"5=#2$%2("H@(" @(" @(" @(" @,'@P
M,&$S960P8R H3EE)*2 -"B )"5-$5T]21" J(" @(" @(" @(" @,'@P,&$S
M9C%C- T*"0E70TA!4B J(" @(" @(" @(" @(#!X,#!A,V4Y,&,@#0H)"5-7
M3U)$(" @(" @(" @(" @(" @(" @(" @(#4Q,B -"@D)4U=/4D0@*B @(" @
M(" @(" @(" P># P83-F,6-A#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E
M-SIF9F8X9#9A8@E%6$E4("!344Q%<G)O<E<@('=I=&@@<F5T=7)N(&-O9&4@
M,3 P("A344Q?3D]?1$%405]&3U5.1"D-"@D)2$5.5B @(" @(" @(" @(" @
M(" P># R9#9F9C%C#0H)"4A$0D,@(" @(" @(" @(" @(" @,'@P,F,W,&$S
M- T*"0E(4U1-5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0-"@D)5T-(05(@
M*B @(" @(" @(" @(" P># P83-E9#!C("A.64DI( T*( D)4T173U)$("H@
M(" @(" @(" @(" P># P83-F,6,T#0H)"5=#2$%2("H@(" @(" @(" @(" @
M,'@P,&$S93DP8R -"@D)4U=/4D0@(" @(" @(" @(" @(" @(" @(" @-3$R
M( T*"0E35T]21" J(" @(" @(" @(" @(#!X,#!A,V8Q8V$-"@T*5D90-B @
M(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$-A;F-E;" -
M"@D)2%-4350@(" @(" @(" @(" @(" P># R8S<Q-C T#0H-"E9&4#8@(" @
M(" @(" @("!F9F9B,V)E-SIF9F8X9#9A8@E%6$E4("!344Q#86YC96P@('=I
M=&@@<F5T=7)N(&-O9&4@," H4U%,7U-50T-%4U,I#0H)"4A35$U4(" @(" @
M(" @(" @(" @,'@P,F,W,38P- T*#0I61E V(" @(" @(" @(" @9F9F8C-B
M93<Z9F9F.&0V86()14Y415(@4U%,1G)E95-T;70@#0H)"4A35$U4(" @(" @
M(" @(" @(" @,'@P,F,W,38P- T*"0E55T]21" @(" @(" @(" @(" @(" @
M(" @(" @(# @/%-13%]#3$]313X-"@T*5D90-B @(" @(" @(" @(&9F9F(S
M8F4W.F9F9CAD-F%B"458250@(%-13$9R9653=&UT("!W:71H(')E='5R;B!C
M;V1E(# @*%-13%]354-#15-3*0T*"0E(4U1-5" @(" @(" @(" @(" @(#!X
M,#)C-S$V,#0-"@D)55=/4D0@(" @(" @(" @(" @(" @(" @(" @(" P(#Q3
M44Q?0TQ/4T4^#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF9F8X9#9A
M8@E%3E1%4B!344Q#86YC96P@#0H)"4A35$U4(" @(" @(" @(" @(" @,'@P
M,F,W,38P- T*#0I61E V(" @(" @(" @(" @9F9F8C-B93<Z9F9F.&0V86()
M15A)5" @4U%,0V%N8V5L("!W:71H(')E='5R;B!C;V1E(# @*%-13%]354-#
M15-3*0T*"0E(4U1-5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0-"@T*5D90
M-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$9R9653
M=&UT( T*"0E(4U1-5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0-"@D)55=/
M4D0@(" @(" @(" @(" @(" @(" @(" @(" Q(#Q344Q?1%)/4#X-"@T*5D90
M-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD-F%B"458250@(%-13$9R9653
M=&UT("!W:71H(')E='5R;B!C;V1E(# @*%-13%]354-#15-3*0T*"0E(4U1-
M5" @(" @(" @(" @(" @(#!X,#)C-S$V,#0-"@D)55=/4D0@(" @(" @(" @
M(" @(" @(" @(" @(" Q(#Q344Q?1%)/4#X-"@T*5D90-B @(" @(" @(" @
M(&9F9F(S8F4W.F9F9CAD-F%B"45.5$52(%-13$1I<V-O;FYE8W0@#0H)"4A$
M0D,@(" @(" @(" @(" @(" @,'@P,F,W,&$S- T*#0I61E V(" @(" @(" @
M(" @9F9F8C-B93<Z9F9F.&0V86()15A)5" @4U%,1&ES8V]N;F5C=" @=VET
M:"!R971U<FX@8V]D92 P("A344Q?4U5#0T534RD-"@D)2$1"0R @(" @(" @
M(" @(" @(" P># R8S<P83,T#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E
M-SIF9F8X9#9A8@E%3E1%4B!344Q&<F5E0V]N;F5C=" -"@D)2$1"0R @(" @
M(" @(" @(" @(" P># R8S<P83,T#0H-"E9&4#8@(" @(" @(" @("!F9F9B
M,V)E-SIF9F8X9#9A8@E%6$E4("!344Q&<F5E0V]N;F5C=" @=VET:"!R971U
M<FX@8V]D92 P("A344Q?4U5#0T534RD-"@D)2$1"0R @(" @(" @(" @(" @
M(" P># R8S<P83,T#0H-"E9&4#8@(" @(" @(" @("!F9F9B,V)E-SIF9F8X
M9#9A8@E%3E1%4B!344Q&<F5E16YV( T*"0E(14Y6(" @(" @(" @(" @(" @
M(#!X,#)D-F9F,6,-"@T*5D90-B @(" @(" @(" @(&9F9F(S8F4W.F9F9CAD
M-F%B"458250@(%-13$9R965%;G8@('=I=&@@<F5T=7)N(&-O9&4@," H4U%,
M7U-50T-%4U,I#0H)"4A%3E8@(" @(" @(" @(" @(" @,'@P,F0V9F8Q8PT*
`
end
begin 600 psqlodbc.log
M8V]N;CTU,#<Y,C4W,BP@4U%,1')I=F5R0V]N;F5C="@@:6XI/2=$4TX]4&]S
M=&=R95-13#M5240]=V1L.U!71#UJ97)O;6T[1$%404)!4T4]8FUS.R<L(&9$
M<FEV97)#;VUP;&5T:6]N/3$-"D133B!I;F9O.B!$4TX])U!O<W1G<F5344PG
M+'-E<G9E<CTG<V<Q)RQP;W)T/2<U-#,R)RQD8F%S93TG8FUS)RQU<V5R/2=W
M9&PG+'!A<W-W9#TG:F5R;VUM)PT*(" @(" @(" @(')E861O;FQY/2<P)RQP
M<F]T;V-O;#TG-BXT)RQS:&]W;VED/2<P)RQF86ME;VED:6YD97@])S G+'-H
M;W=S>7-T86)L93TG,"<-"B @(" @(" @("!C;VYN7W-E='1I;F=S/2<G#0H@
M(" @(" @(" @=')A;G-L871I;VY?9&QL/2<G+'1R86YS;&%T:6]N7V]P=&EO
M;CTG)PT*1VQO8F%L($]P=&EO;G,Z(%9E<G-I;VX])S V+C0P+C P,#@G+"!F
M971C:#TQ,# L('-O8VME=#TT,#DV+"!U;FMN;W=N7W-I>F5S/3 L(&UA>%]V
M87)C:&%R7W-I>F4],C4T+"!M87A?;&]N9W9A<F-H87)?<VEZ93TX,3DP#0H@
M(" @(" @(" @(" @(" @9&ES86)L95]O<'1I;6EZ97(],2P@:W-Q;STQ+"!U
M;FEQ=65?:6YD97@],2P@=7-E7V1E8VQA<F5F971C:#TP#0H@(" @(" @(" @
M(" @(" @=&5X=%]A<U]L;VYG=F%R8VAA<CTQ+"!U;FMN;W=N<U]A<U]L;VYG
M=F%R8VAA<CTP+"!B;V]L<U]A<U]C:&%R/3 -"B @(" @(" @(" @(" @("!E
M>'1R85]S>7-T86)L95]P<F5F:7AE<STG9&1?.R<L(&-O;FY?<V5T=&EN9W,]
M)R<-"F-O;FX]-3 W.3(U-S(L('%U97)Y/2<@)PT*8V]N;CTU,#<Y,C4W,BP@
M<75E<GD])W-E="!$871E4W1Y;&4@=&\@)TE33R<G#0IC;VYN/34P-SDR-3<R
M+"!Q=65R>3TG<V5T(&=E<6\@=&\@)T]&1B<G#0IC;VYN/34P-SDR-3<R+"!Q
M=65R>3TG<V5T(&MS<6\@=&\@)T].)R<-"F-O;FX]-3 W.3(U-S(L('%U97)Y
M/2=S96QE8W0@;VED(&9R;VT@<&=?='EP92!W:&5R92!T>7!N86UE/2=L;R<G
M#0H@(" @6R!F971C:&5D(# @<F]W<R!=#0IC;VYN/34P-SDR-3<R+"!344Q$
M<FEV97)#;VYN96-T*&]U="D])T133CU0;W-T9W)E4U%,.T1!5$%"05-%/6)M
M<SM315)615(]<V<Q.U!/4E0]-30S,CM5240]=V1L.U!71#UJ97)O;6T[4D5!
M1$].3%D],#M04D]43T-/3#TV+C0[1D%+14])1$E.1$58/3 [4TA/5T])1$-/
M3%5-3CTP.U)/5U9%4E-)3TY)3D<],#M32$]74UE35$5-5$%"3$53/3 [0T].
M3E-%5%1)3D=3/2<-"F-O;FX]-3 W.3(U-S(L('%U97)Y/2=S96QE8W0@*B!F
M<F]M('!E;R!W:&5R92!P96]?;F%M92 @/2 G02<@86YD('!E;U]C;V1E(#T@
M)PT*15)23U(@9G)O;2!B86-K96YD(&1U<FEN9R!S96YD7W%U97)Y.B G15)2
M3U(Z("!P87)S97(Z('!A<G-E(&5R<F]R(&%T(&]R(&YE87(@(B(G#0I35$%4
M14U%3E0@15)23U(Z(&9U;F,]4T-?97AE8W5T92P@9&5S8STG)RP@97)R;G5M
M/3$L(&5R<FUS9STG17)R;W(@=VAI;&4@97AE8W5T:6YG('1H92!Q=65R>2<-
M"B @(" @(" @(" @(" @(" @+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0H@(" @(" @(" @
M(" @(" @(&AD8F,]-3 W.3(U-S(L('-T;70]-3 X,#<Q,# L(')E<W5L=#TP
M#0H@(" @(" @(" @(" @(" @(&UA;G5A;%]R97-U;'0],"P@<')E<&%R93TQ
M+"!I;G1E<FYA;#TP#0H@(" @(" @(" @(" @(" @(&)I;F1I;F=S/3 L(&)I
M;F1I;F=S7V%L;&]C871E9#TP#0H@(" @(" @(" @(" @(" @('!A<F%M971E
M<G,],"P@<&%R86UE=&5R<U]A;&QO8V%T960], T*(" @(" @(" @(" @(" @
M("!S=&%T96UE;G1?='EP93TP+"!S=&%T96UE;G0])W-E;&5C=" J(&9R;VT@
M<&5O('=H97)E('!E;U]N86UE(" ]("=!)R!A;F0@<&5O7V-O9&4@/2 _)PT*
M(" @(" @(" @(" @(" @("!S=&UT7W=I=&A?<&%R86US/2=S96QE8W0@*B!F
M<F]M('!E;R!W:&5R92!P96]?;F%M92 @/2 G02<@86YD('!E;U]C;V1E(#T@
M)PT*(" @(" @(" @(" @(" @("!D871A7V%T7V5X96,]+3$L(&-U<G)E;G1?
M97AE8U]P87)A;3TM,2P@<'5T7V1A=&$], T*(" @(" @(" @(" @(" @("!C
M=7)R5'5P;&4]+3$L(&-U<G)E;G1?8V]L/2TQ+"!L;V)J7V9D/2TQ#0H@(" @
M(" @(" @(" @(" @(&UA>%)O=W,],"P@<F]W<V5T7W-I>F4],2P@:V5Y<V5T
M7W-I>F4],"P@8W5R<V]R7W1Y<&4],"P@<V-R;VQL7V-O;F-U<G)E;F-Y/3$-
M"B @(" @(" @(" @(" @(" @8W5R<V]R7VYA;64])U-13%]#55(P,S W-#$S
M0R<-"B @(" @(" @(" @(" @(" @+2TM+2TM+2TM+2TM+2TM+5%297-U;'0@
M26YF;R M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0I#3TY.($52
M4D]2.B!F=6YC/5-#7V5X96-U=&4L(&1E<V,])R<L(&5R<FYU;3TQ,3 L(&5R
M<FUS9STG15)23U(Z("!P87)S97(Z('!A<G-E(&5R<F]R(&%T(&]R(&YE87(@
M(B(G#0H@(" @(" @(" @(" M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T-"B @(" @(" @(" @
M(&AE;G8]-3$X,SDQ-# L(&-O;FX]-3 W.3(U-S(L('-T871U<STQ+"!N=6U?
M<W1M=',],38-"B @(" @(" @(" @('-O8VL]-3$X,SDQ-38L('-T;71S/34Q
M.#,Y-#0P+"!L;V)J7W1Y<&4]+3DY.0T*(" @(" @(" @(" @+2TM+2TM+2TM
M+2TM+2TM+2!3;V-K970@26YF;R M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM#0H@(" @(" @(" @("!S;V-K970],30P+"!R979E<G-E/3 L(&5R
M<F]R;G5M8F5R/3 L(&5R<F]R;7-G/2<H;G5L;"DG#0H@(" @(" @(" @("!B
M=69F97)?:6X]-3 W.3@Y,# L(&)U9F9E<E]O=70]-3 X,#,P,# -"B @(" @
M(" @(" @(&)U9F9E<E]F:6QL961?:6X]-#4L(&)U9F9E<E]F:6QL961?;W5T
M/3 L(&)U9F9E<E]R96%D7VEN/30T#0I35$%414U%3E0@15)23U(Z(&9U;F,]
M4U%,3G5M4F5S=6QT0V]L<RP@9&5S8STG)RP@97)R;G5M/3,L(&5R<FUS9STG
M3F\@<75E<GD@:&%S(&)E96X@97AE8W5T960@=VET:"!T:&%T(&AA;F1L92<-
M"B @(" @(" @(" @(" @(" @+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0H@(" @(" @(" @
M(" @(" @(&AD8F,]-3 W.3(U-S(L('-T;70]-3 X,#<Q,# L(')E<W5L=#TP
M#0H@(" @(" @(" @(" @(" @(&UA;G5A;%]R97-U;'0],"P@<')E<&%R93TQ
M+"!I;G1E<FYA;#TP#0H@(" @(" @(" @(" @(" @(&)I;F1I;F=S/3 L(&)I
M;F1I;F=S7V%L;&]C871E9#TP#0H@(" @(" @(" @(" @(" @('!A<F%M971E
M<G,],"P@<&%R86UE=&5R<U]A;&QO8V%T960], T*(" @(" @(" @(" @(" @
M("!S=&%T96UE;G1?='EP93TP+"!S=&%T96UE;G0])W-E;&5C=" J(&9R;VT@
M<&5O('=H97)E('!E;U]N86UE(" ]("=!)R!A;F0@<&5O7V-O9&4@/2 _)PT*
M(" @(" @(" @(" @(" @("!S=&UT7W=I=&A?<&%R86US/2=S96QE8W0@*B!F
M<F]M('!E;R!W:&5R92!P96]?;F%M92 @/2 G02<@86YD('!E;U]C;V1E(#T@
M)PT*(" @(" @(" @(" @(" @("!D871A7V%T7V5X96,]+3$L(&-U<G)E;G1?
M97AE8U]P87)A;3TM,2P@<'5T7V1A=&$], T*(" @(" @(" @(" @(" @("!C
M=7)R5'5P;&4]+3$L(&-U<G)E;G1?8V]L/2TQ+"!L;V)J7V9D/2TQ#0H@(" @
M(" @(" @(" @(" @(&UA>%)O=W,],"P@<F]W<V5T7W-I>F4],2P@:V5Y<V5T
M7W-I>F4],"P@8W5R<V]R7W1Y<&4],"P@<V-R;VQL7V-O;F-U<G)E;F-Y/3$-
M"B @(" @(" @(" @(" @(" @8W5R<V]R7VYA;64])U-13%]#55(P,S W-#$S
M0R<-"B @(" @(" @(" @(" @(" @+2TM+2TM+2TM+2TM+2TM+5%297-U;'0@
M26YF;R M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0I#3TY.($52
M4D]2.B!F=6YC/5-13$YU;5)E<W5L=$-O;',L(&1E<V,])R<L(&5R<FYU;3TQ
M,3 L(&5R<FUS9STG15)23U(Z("!P87)S97(Z('!A<G-E(&5R<F]R(&%T(&]R
M(&YE87(@(B(G#0H@(" @(" @(" @(" M+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2T-"B @(" @
M(" @(" @(&AE;G8]-3$X,SDQ-# L(&-O;FX]-3 W.3(U-S(L('-T871U<STQ
M+"!N=6U?<W1M=',],38-"B @(" @(" @(" @('-O8VL]-3$X,SDQ-38L('-T
M;71S/34Q.#,Y-#0P+"!L;V)J7W1Y<&4]+3DY.0T*(" @(" @(" @(" @+2TM
M+2TM+2TM+2TM+2TM+2!3;V-K970@26YF;R M+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM#0H@(" @(" @(" @("!S;V-K970],30P+"!R979E<G-E
M/3 L(&5R<F]R;G5M8F5R/3 L(&5R<F]R;7-G/2<H;G5L;"DG#0H@(" @(" @
M(" @("!B=69F97)?:6X]-3 W.3@Y,# L(&)U9F9E<E]O=70]-3 X,#,P,# -
M"B @(" @(" @(" @(&)U9F9E<E]F:6QL961?:6X]-#4L(&)U9F9E<E]F:6QL
M961?;W5T/3 L(&)U9F9E<E]R96%D7VEN/30T#0I35$%414U%3E0@15)23U(Z
M(&9U;F,]4U%,17AE8W5T92P@9&5S8STG)RP@97)R;G5M/3(L(&5R<FUS9STG
M5&AE(&AA;F1L92!D;V5S(&YO="!P;VEN="!T;R!A('-T871E;65N="!T:&%T
M(&ES(')E861Y('1O(&)E(&5X96-U=&5D)PT*(" @(" @(" @(" @(" @(" M
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2T-"B @(" @(" @(" @(" @(" @:&1B8STU,#<Y,C4W
M,BP@<W1M=#TU,#@P-S$P,"P@<F5S=6QT/3 -"B @(" @(" @(" @(" @(" @
M;6%N=6%L7W)E<W5L=#TP+"!P<F5P87)E/3 L(&EN=&5R;F%L/3 -"B @(" @
M(" @(" @(" @(" @8FEN9&EN9W,],"P@8FEN9&EN9W-?86QL;V-A=&5D/3 -
M"B @(" @(" @(" @(" @(" @<&%R86UE=&5R<STP+"!P87)A;65T97)S7V%L
M;&]C871E9#TP#0H@(" @(" @(" @(" @(" @('-T871E;65N=%]T>7!E/3 L
M('-T871E;65N=#TG<V5L96-T("H@9G)O;2!P96\@(%=(15)%(#$],"<-"B @
M(" @(" @(" @(" @(" @<W1M=%]W:71H7W!A<F%M<STG<V5L96-T("H@9G)O
M;2!P96\@=VAE<F4@<&5O7VYA;64@(#T@)T$G(&%N9"!P96]?8V]D92 ]("<-
M"B @(" @(" @(" @(" @(" @9&%T85]A=%]E>&5C/2TQ+"!C=7)R96YT7V5X
M96-?<&%R86T]+3$L('!U=%]D871A/3 -"B @(" @(" @(" @(" @(" @8W5R
M<E1U<&QE/2TQ+"!C=7)R96YT7V-O;#TM,2P@;&]B:E]F9#TM,0T*(" @(" @
M(" @(" @(" @("!M87A2;W=S/3 L(')O=W-E=%]S:7IE/3$L(&ME>7-E=%]S
M:7IE/3 L(&-U<G-O<E]T>7!E/3 L('-C<F]L;%]C;VYC=7)R96YC>3TQ#0H@
M(" @(" @(" @(" @(" @(&-U<G-O<E]N86UE/2=344Q?0U52,#,P-S0Q,T,G
M#0H@(" @(" @(" @(" @(" @("TM+2TM+2TM+2TM+2TM+2U14F5S=6QT($EN
M9F\@+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+0T*0T].3B!%4E)/
M4CH@9G5N8SU344Q%>&5C=71E+"!D97-C/2<G+"!E<G)N=6T],3$P+"!E<G)M
M<V<])T524D]2.B @<&%R<V5R.B!P87)S92!E<G)O<B!A="!O<B!N96%R("(B
M)PT*(" @(" @(" @(" @+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0H@(" @(" @(" @("!H
M96YV/34Q.#,Y,30P+"!C;VYN/34P-SDR-3<R+"!S=&%T=7,],2P@;G5M7W-T
M;71S/3$V#0H@(" @(" @(" @("!S;V-K/34Q.#,Y,34V+"!S=&UT<STU,3@S
M.30T,"P@;&]B:E]T>7!E/2TY.3D-"B @(" @(" @(" @("TM+2TM+2TM+2TM
M+2TM+2T@4V]C:V5T($EN9F\@+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM
M+2TM+0T*(" @(" @(" @(" @<V]C:V5T/3$T,"P@<F5V97)S93TP+"!E<G)O
M<FYU;6)E<CTP+"!E<G)O<FUS9STG*&YU;&PI)PT*(" @(" @(" @(" @8G5F
M9F5R7VEN/34P-SDX.3 P+"!B=69F97)?;W5T/34P.# S,# P#0H@(" @(" @
M(" @("!B=69F97)?9FEL;&5D7VEN/30U+"!B=69F97)?9FEL;&5D7V]U=#TP
M+"!B=69F97)?<F5A9%]I;CTT- T*8V]N;CTU,#<Y,C4W,BP@4U%,1&ES8V]N
&;F5C= T*
`
end
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: [INTERFACES] pgsql ODBC driver and Visual Foxpro
@ 2000-02-28 00:17 Byron Nikolaidis <byron.nikolaidis@home.com>
parent: Willy De la Court <Willy.DelaCourt@pandora.be>
0 siblings, 0 replies; 3+ messages in thread
From: Byron Nikolaidis @ 2000-02-28 00:17 UTC (permalink / raw)
To: Willy De la Court <Willy.DelaCourt@pandora.be>; +Cc: pgsql-interfaces
Willy De la Court wrote:
>
> Hi,
>
> I'v got the following problem with Visual Foxpro (VFP) and using the pgsql ODBC driver.
>
> With Visual Foxpro it is possible to create parametrized views it looks something like this.
>
> create sql view xxx remote connection bms as select * from peo where peo_name = 'A' and peo_code = ?ncode
>
> where '?ncode' is the parameter. Normaly the ?ncode is replaced before the select statement is send to the backend.
> visual foxpro will try first to send the query unmodified to the backend.
> and always it gets an error from the backend. Here is a piece of the log.
>
> statement_type=0, statement='select * from peo where peo_name = 'A' and peo_code = ?'
> stmt_with_params='select * from peo where peo_name = 'A' and peo_code = '
>
> Then VFP even after it got an error it will try to get the number of rows returned.
>
> STATEMENT ERROR: func=SQLNumResultCols, desc='', errnum=3, errmsg='No query has been executed with that handle'
>
> This error message is also normal.
>
> Then VFP tries to execute an SQLExecDirect with "select * from peo WHERE 0=1"
> and this fails also which is not normal.
>
> STATEMENT ERROR: func=SQLExecute, desc='', errnum=2, errmsg='The handle does not point to a statement that is ready to be executed'
>
> AND LOOK AT THESE 2 LINES IN THE LOGFILE.
>
> statement_type=0, statement='select * from peo WHERE 1=0'
> stmt_with_params='select * from peo where peo_name = 'A' and peo_code = '
>
> What happend here???????
>
> Can somebody please help me with this I need the odbc driver to work with visual foxpro.
> PS normal SQL statements without the functionality of parameters work great.
>
> Included are both the sql.log and the psqlodbc.log
>
>
>
> Name: SQL.LOG
> SQL.LOG Type: LOG File (application/x-unknown-content-type-log_auto_file)
> Encoding: x-uuencode
>
> Name: psqlodbc.log
> psqlodbc.log Type: LOG File (application/x-unknown-content-type-log_auto_file)
> Encoding: x-uuencode
>
> ************
OK,
The real problem appears to be an escape sequence in your query:
select * from peo where peo_name = 'A' and peo_code = ?\ 0
The backend responds with:
ERROR from backend during send_query: 'ERROR: parser: parse error at or
near ""'
Since Postgres still does not have prepared statements, the driver can
not execute this statement and does not return this error in the
SQLPrepare, but in the next call, which is SQLNumResultCols. I'm not
sure if foxpro is really prepared for this but according to odbc specs,
it is supposed to handle this possibility for drivers that can not
execute prepared statements right away.
Foxpro then executes another query, which also has the bad escape
sequence:
select * from peo WHERE 1=0\ 0
However, this query never even gets to the backend because of a
state-transition problem in the driver, *which I have fixed in
v.0009*. If you try the new driver, it will still fail because of the
bad escape sequences.
Bottom line, if you can get rid of the escapes everything should work.
Byron
^ permalink raw reply [nested|flat] 3+ messages in thread
* RE: [INTERFACES] pgsql ODBC driver and Visual Foxpro
@ 2000-02-28 17:46 Willy De la Court <Willy.DelaCourt@pandora.be>
0 siblings, 0 replies; 3+ messages in thread
From: Willy De la Court @ 2000-02-28 17:46 UTC (permalink / raw)
To: pgsql-interfaces
Thanx Byron
version 0009 works perfectly now with remote views on VFP it seems the escaped character don't interfere with anything.
I think the guys at mickeysoft don't even know how to use the drivers properly.
It seems that the oracle odbc driver from oracle themselfs has the same problem.
THANK YOU VERY MUCH
On maandag 28 februari 2000 1:17, Byron Nikolaidis [SMTP:byron.nikolaidis@home.com] wrote:
>
>
> Willy De la Court wrote:
> >
> > Hi,
> >
> > I'v got the following problem with Visual Foxpro (VFP) and using the pgsql ODBC driver.
> >
> > With Visual Foxpro it is possible to create parametrized views it looks something like this.
> >
> > create sql view xxx remote connection bms as select * from peo where peo_name = 'A' and peo_code = ?ncode
> >
> > where '?ncode' is the parameter. Normaly the ?ncode is replaced before the select statement is send to the backend.
> > visual foxpro will try first to send the query unmodified to the backend.
> > and always it gets an error from the backend. Here is a piece of the log.
> >
> > statement_type=0, statement='select * from peo where peo_name = 'A' and peo_code = ?'
> > stmt_with_params='select * from peo where peo_name = 'A' and peo_code = '
> >
> > Then VFP even after it got an error it will try to get the number of rows returned.
> >
> > STATEMENT ERROR: func=SQLNumResultCols, desc='', errnum=3, errmsg='No query has been executed with that handle'
> >
> > This error message is also normal.
> >
> > Then VFP tries to execute an SQLExecDirect with "select * from peo WHERE 0=1"
> > and this fails also which is not normal.
> >
> > STATEMENT ERROR: func=SQLExecute, desc='', errnum=2, errmsg='The handle does not point to a statement that is ready to be executed'
> >
> > AND LOOK AT THESE 2 LINES IN THE LOGFILE.
> >
> > statement_type=0, statement='select * from peo WHERE 1=0'
> > stmt_with_params='select * from peo where peo_name = 'A' and peo_code = '
> >
> > What happend here???????
> >
> > Can somebody please help me with this I need the odbc driver to work with visual foxpro.
> > PS normal SQL statements without the functionality of parameters work great.
> >
> > Included are both the sql.log and the psqlodbc.log
> >
> >
> >
> > Name: SQL.LOG
> > SQL.LOG Type: LOG File (application/x-unknown-content-type-log_auto_file)
> > Encoding: x-uuencode
> >
> > Name: psqlodbc.log
> > psqlodbc.log Type: LOG File (application/x-unknown-content-type-log_auto_file)
> > Encoding: x-uuencode
> >
> > ************
>
>
> OK,
>
> The real problem appears to be an escape sequence in your query:
>
> select * from peo where peo_name = 'A' and peo_code = ?\ 0
>
> The backend responds with:
>
> ERROR from backend during send_query: 'ERROR: parser: parse error at or
> near ""'
>
> Since Postgres still does not have prepared statements, the driver can
> not execute this statement and does not return this error in the
> SQLPrepare, but in the next call, which is SQLNumResultCols. I'm not
> sure if foxpro is really prepared for this but according to odbc specs,
> it is supposed to handle this possibility for drivers that can not
> execute prepared statements right away.
>
> Foxpro then executes another query, which also has the bad escape
> sequence:
>
> select * from peo WHERE 1=0\ 0
>
> However, this query never even gets to the backend because of a
> state-transition problem in the driver, *which I have fixed in
> v.0009*. If you try the new driver, it will still fail because of the
> bad escape sequences.
>
> Bottom line, if you can get rid of the escapes everything should work.
>
>
> Byron
>
> ************
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-02-28 17:46 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-02-27 14:16 pgsql ODBC driver and Visual Foxpro Willy De la Court <Willy.DelaCourt@pandora.be>
2000-02-28 00:17 ` Byron Nikolaidis <byron.nikolaidis@home.com>
2000-02-28 17:46 RE: [INTERFACES] pgsql ODBC driver and Visual Foxpro Willy De la Court <Willy.DelaCourt@pandora.be>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox