Обсуждение: pgsql ODBC driver and Visual Foxpro

Поиск
Список
Период
Сортировка

pgsql ODBC driver and Visual Foxpro

От
Willy De la Court
Дата:
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.visualfoxpro 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
beexecuted'
 

AND LOOK AT THESE 2 LINES IN THE LOGFILE.
                statement_type=0, statement='select * from peo  WHERE 1=0'                stmt_with_params='select *
frompeo 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



Re: [INTERFACES] pgsql ODBC driver and Visual Foxpro

От
Byron Nikolaidis
Дата:

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
tobe 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