Received: from mail.vng.ru ([194.87.161.99]) by hub.org (8.9.1/8.8.8) with ESMTP id CAA00255 for ; Thu, 22 Oct 1998 02:20:37 -0400 (EDT) (envelope-from angg@vng.ru) Received: from mis1 (192.1.1.238 [192.1.1.238]) by mail.vng.ru with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.1960.3) id V1JQZFGL; Thu, 22 Oct 1998 11:53:45 +0500 Reply-To: "angg" From: "angg" To: Cc: Subject: [INTERFACES] C++ Builder (Delphi), ODBC and large objects Date: Thu, 22 Oct 1998 12:01:52 +0500 Message-ID: <01bdfd89$d8d61ea0$0b02a8c0@mis1> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----=_NextPart_000_0009_01BDFDB3.C1AC26A0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 4.71.1712.3 X-MimeOLE: Produced By Microsoft MimeOLE V4.71.1712.3 This is a multi-part message in MIME format. ------=_NextPart_000_0009_01BDFDB3.C1AC26A0 Content-Type: text/plain; charset="koi8-r" Content-Transfer-Encoding: 7bit 21.10.1998 Byron Nikolaidis wrote: >Please send me the psqlodbc.log files showing both the "0-value" error and the >"couldn't open large object for reading". I have type 'lo' created CREATE TYPE lo ( internallength=4, externallength=10, input=int4in, output=int4out, default='', passedbyvalue ); as it is recomended in http://www.insightdist.com/psqlodbc/psqlodbc_faq.html#largeobjects and a table CREATE TABLE tmp_rq ( req_id int2, req_content lo ); I manually (to simplify debugging) insert record with req_id = 1. In my application I have an SQL (RequestLive), SELECT req_id, req_content FROM tmp_rq WHERE req_id = 1; It binded to TDBRichEdit (TDBMemo) component. I run the application, write text (long) to the large object field fromTDBRichEdit, and exit. I'm attaching psqlodbc.log file renaming it to WriteData.log Then run the application again try to read data from large object field by TDBRichEdit (nothing is showed), and exit. This time I renamed psqlodbc.log file to ReadAfterWriteData.log I can see there are some information you don't need, but I decided to leave the files as is not to remove something valuable by ignorance. >Also, send the odbc trace log files (sql.log) as well showing the results of >both the read and write attempts. Make sure the log file is clean before you begin. In both cases described above sql.log file was emty. To try to get the files I did the following: In MS 32-bit ODBC I checked "All the time" ("When to trace" on "Tracing" page)" and press "Start tracing Now" button. In ODBC Administrator (PostOdbc driver) I set Trace mode = 0x0040 Here is quoting from "ODBC driver connection settings" help: TRACE MODE A numeric value (bit mask) specifying how much trace information to log. The Windows OutputDebugString call is used to output the requested information to the debug window. The following table shows which information is logged based on bit settings: Bit Settings Logged Information 0x0001 prepared query statement 0x0002 executed query statements 0x0004 vendor errors 0x0008 statement options (that is: allocate, free) 0x0010 connect / disconnect 0x0020 transaction 0x0040 BLOB I/O 0x0080 miscellaneous 0x0100 vendor calls But I do get 488 KB sql.log file when I create large object. I'm not attaching it because I don't know whether you need it. If you do I'll send it too. I got a message from Sergey E. Levov he writes: >If you have sources try the follwing: >Find the string > if (pcbValue && *pcbValue <= SQL_LEN_DATA_AT_EXEC_OFFSET) >in the file bind.c and change it into > if (pcbValue && ((*pcbValue <= SQL_LEN_DATA_AT_EXEC_OFFSET) || > (*pcbValue == SQL_DATA_AT_EXEC))) >and rebuild the driver. Perhaps it help. I downloaded sources from www.insightdist.com/psqlodbc. Unfortunatelly I need MS Visual C++ 4.0 to rebuild the driver which I haven't. I am seeking an opportunity to do the job now. Thank you, Mikhail. ------=_NextPart_000_0009_01BDFDB3.C1AC26A0 Content-Type: application/octet-stream; name="WrteData.log" Content-Transfer-Encoding: uuencode Content-Disposition: attachment; filename="WrteData.log" M8V]N;CTT-S$X-C T,"P@4U%,1')I=F5R0V]N;F5C="@@:6XI/2=$4TX]0V]U M#TG,"F4]-# Y- T*(" @(" @(" @(" @(" @(&1IF5R/3$L('5N:7%U95]I;F1E>#TQ+"!U7!N86UE/2=L;R7!M;V0L(&$N871T;F]T;G5L;"!F7-I9"D@/2!I;G0T;W5T*&,N7!I9" ] M('0N;VED(&%N9" H82YA='1N=6T@/B P*2!A;F0@8RYR96QN86UE(&QI:V4@ M)W=E;&Q?7!M;V0L(&$N871T;F]T;G5L;"!F3TG4T5,14-4(&%R+F%R96$@#0H@($923TT@87)E85]R(&%R M+"!W96QL7W(@=W(@#0H@(%=(15)%('=R+G=E;&P@/2 G,S(G( T*(" @($%. M1"!A7-I9"D@/2!I M;G0T;W5T*&,N3TG0T]-34E4)PT*8V]N;CTT-S$X-C T,"P@ M<75E3TG0D5'24XG M#0IC;VYN/30W,3@V,#0P+"!Q=65R>3TG55!$051%(&1O;F5?=&UP-SDS-R!3 M150@#0H@(&)R:6=?;F\@/2 G,3 Q)RP@#0H@('=E;&P@/2 G,S(G+" -"B @ M9&%T95]D3TG M2!A='1N=6TG#0H@(" @6R!F971C:&5D(#8@3TG7!N86UE+"!A+F%T=&YU;2P@82YA='1L M96XL(&$N871T='EP;6]D+"!A+F%T=&YO=&YU;&P@9G)O;2!P9U]U3TG"!I+"!P9U]C;&%S')E;&ED(&%N9"!D+G)E;&YA;64@/2 G9&]N95]T;7 W.3,W M)R!A;F0@9"YO:60@/2!I+FEN9')E;&ED)PT*(" @(%L@9F5T8VAE9" P(')O M=W,@70T*8V]N;CTT-S$X-C T,"P@<75E7-I9"D@ M/2!I;G0T;W5T*&,N<&=??%YD9%\G(&%N9"!R96QN86UE("%^("=>>&EN=ELP+3E=*R<@86YD M(&EN=#1O=70H=7-E2!R96QN86UE)PT*(" @(%L@9F5T8VAE9" Q(')O=W,@70T*8V]N;CTT-S$X M-C T,"P@<75E7-I9"D@/2!I;G0T;W5T*&,N7!I9" ]('0N;VED(&%N M9" H82YA='1N=6T@/B P*2!A;F0@8RYR96QN86UE(&QI:V4@)VED;&5?=&UP M,C$S.3DG(&]R9&5R(&)Y(&%T=&YU;2<-"B @("!;(&9E=&-H960@-B!R;W=S M(%T-"F-O;FX]-#7!M;V0L(&$N871T;F]T;G5L;"!F M3TG"!I+"!P9U]C;&%S')E;&ED(&%N9"!D+G)E;&YA;64@ M/2 G:61L95]T;7 R,3,Y.2<@86YD(&0N;VED(#T@:2YI;F1R96QI9"<-"B @ M("!;(&9E=&-H960@,"!R;W=S(%T-"F-O;FX]-#3TG9&1?)R!A;F0@7!M;V0L(&$N871T;F]T;G5L;"!F7!M;V0L(&$N871T;F]T;G5L;"!F M2P@:2YI;F1I3TG4T5,14-4(")R97%?8V]N M=&5N="(L(")R97%?:60B($923TT@(G1M<%]R<2(@5TA%4D4@*")R97%?:60B M*2 ]("@Q*2<-"B @("!;(&9E=&-H960@,2!R;W=S(%T-"F-O;FX]-#7!M;V0L(&$N871T;F]T;G5L;"!F%]E%]M87@L#0H@(" @(" @8U]E;G9D:69F>%]M:6XL#0H@(" @(" @8U]E M;G9P;6%N9E]E"P-"B @(" @ M("!C7VUU9'9O;%]M:6XL#0H@(" @(" @8U]M=61W871E7-I M9"D@/2!I;G0T;W5T*&,N3TG4T5,14-4(%-5 M32AI9&QE7V1U3TG0D5'24XG M#0IC;VYN/30W,3@V,#0P+"!Q=65R>3TG1%)/4"!404),12!I9&QE7W1M<#(Q M,SDY.PT*)PT*8V]N;CTT-S$X-C T,"P@<75E#TG,"F4]-# Y- T*(" @(" @(" @(" @(" @(&1IF5R/3$L('5N:7%U95]I;F1E>#TQ+"!U7!N86UE/2=L;R7!M;V0L(&$N871T;F]T;G5L;"!F7-I9"D@/2!I;G0T;W5T*&,N7!I9" ] M('0N;VED(&%N9" H82YA='1N=6T@/B P*2!A;F0@8RYR96QN86UE(&QI:V4@ M)W=E;&Q?7!M;V0L(&$N871T;F]T;G5L;"!F3TG4T5,14-4(&%R+F%R96$@#0H@($923TT@87)E85]R(&%R M+"!W96QL7W(@=W(@#0H@(%=(15)%('=R+G=E;&P@/2 G,S(G( T*(" @($%. M1"!A7-I9"D@/2!I M;G0T;W5T*&,N<&=??%YD M9%\G(&%N9"!R96QN86UE("%^("=>>&EN=ELP+3E=*R<@86YD(&EN=#1O=70H M=7-E2!R96QN86UE M)PT*(" @(%L@9F5T8VAE9" Q(')O=W,@70T*8V]N;CTT-S$X-C T,"P@<75E M7-I9"D@/2!I;G0T;W5T*&,N7!I9" ]('0N;VED(&%N9" H82YA='1N M=6T@/B P*2!A;F0@8RYR96QN86UE(&QI:V4@)V1O;F5?=&UP,C8W-C@G(&]R M9&5R(&)Y(&%T=&YU;2<-"B @("!;(&9E=&-H960@-B!R;W=S(%T-"F-O;FX] M-#7!M;V0L(&$N871T;F]T;G5L;"!F3TG"!I+"!P9U]C;&%S')E;&ED(&%N9"!D+G)E;&YA;64@/2 G9&]N95]T M;7 R-C3TG M<&=??%YD9%\G(&%N9"!R96QN86UE("%^("=>>&EN=ELP M+3E=*R<@86YD(&EN=#1O=70H=7-E2!R96QN86UE)PT*(" @(%L@9F5T8VAE9" Q(')O=W,@70T* M8V]N;CTT-S$X-C T,"P@<75E7-I9"D@/2!I;G0T;W5T*&,N7!I9" ] M('0N;VED(&%N9" H82YA='1N=6T@/B P*2!A;F0@8RYR96QN86UE(&QI:V4@ M)VED;&5?=&UP,C(P,S0G(&]R9&5R(&)Y(&%T=&YU;2<-"B @("!;(&9E=&-H M960@-B!R;W=S(%T-"F-O;FX]-#7!M;V0L(&$N871T M;F]T;G5L;"!F2!A='1N=6TG M#0H@(" @6R!F971C:&5D(#8@3TG"!I+"!P9U]C;&%S')E;&ED(&%N9"!D M+G)E;&YA;64@/2 G:61L95]T;7 R,C S-"<@86YD(&0N;VED(#T@:2YI;F1R M96QI9"<-"B @("!;(&9E=&-H960@,"!R;W=S(%T-"F-O;FX]-#3TG7!N86UE+"!A+F%T=&YU;2P@ M82YA='1L96XL(&$N871T='EP;6]D+"!A+F%T=&YO=&YU;&P@9G)O;2!P9U]U M7!E('0@ M=VAE9&1?)R!A;F0@7!M;V0L(&$N871T;F]T;G5L M;"!F7!M;V0L(&$N871T M;F]T;G5L;"!F2P@:2YI;F1I3TG4T5,14-4 M(")R97%?8V]N=&5N="(L(")R97%?:60B($923TT@(G1M<%]R<2(@5TA%4D4@ M*")R97%?:60B*2 ]("@Q*2<-"B @("!;(&9E=&-H960@,2!R;W=S(%T-"F-O M;FX]-#7!M;V0L(&$N871T;F]T;G5L;"!F&5C7W!A7-E=%]S:7IE/3 L(&-U7!E/3 L('-C3TQ#0H@(" @(" @(" @(" @(" @(&-U7!E M/3$U.#DQ,@T*(" @(" @(" @(" @+2TM+2TM+2TM+2TM+2TM+2!3;V-K970@ M26YF;R M+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM+2TM#0H@(" @(" @ M(" @("!S;V-K970],S L(')E=F5R%]E%]M87@L#0H@(" @(" @8U]E;G9D:69F>%]M:6XL M#0H@(" @(" @8U]E;G9P;6%N9E]E"P-"B @(" @("!C7VUU9'9O;%]M:6XL#0H@(" @(" @8U]M=61W871E M7-I9"D@/2!I;G0T;W5T*&,N7!I9" ]('0N;VED(&%N9" H82YA M='1N=6T@/B P*2!A;F0@8RYR96QN86UE(&QI:V4@)V-O;F9I9R<@;W)D97(@ M8GD@871T;G5M)PT*(" @(%L@9F5T8VAE9" T-R!R;W=S(%T-"F-O;FX]-#3TG0T]-34E4)PT*8V]N;CTT-S$X-C T,"P@<75E