Re: FW: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table reorganization. - Mailing list pgsql-odbc

Hi Hiroshi,

Thanks for the response. I see a "mylog" file in the C:\ directory on the PC. But it is a one-liner which says
"detachingprocess". Apart from that I don't see any other log file apart from the one which I posted earlier and which
wasa file that we directed the "tracing" option in ODBC to write to. Can you let me know how to produce the Mylog file
andI shall try it it out.
 

Thanks.

Alanoly Andrews
Invera Inc
Tel: (514) 935-8170, ext 2328


-----Original Message-----
From: Inoue, Hiroshi [mailto:inoue@tpf.co.jp]
Sent: Monday, September 08, 2014 7:55 PM
To: Alanoly Andrews; 'pgsql-odbc@postgresql.org'
Cc: 'Adrian Klaver'
Subject: Re: [ODBC] FW: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table
reorganization.

(2014/09/08 23:03), Alanoly Andrews wrote:
> Hello experts in postgres-odbc,
>
> The following was the latest in a series of posts that I had made to the admin and general discussion groups. This
postcontains an excerpt from the log produced by the postgres odbc client when an attempt was made to retrieve an image
storedon a backend postgres database (AIX server). The postgres database is 9.1.4 version. The column containing the
imageis defined as type "lo". The SQL is a simple one of the type "select image from table where image_key=keyvalue".
Inthe early part of the log all return codes are 0. When the return code is 1, we get the "The buffer was too small for
theGetData" and "Error reading from large object" messages. Would any of you know what these messages mean and how we
canget around the problem? The code for sql retrieval is written in VB code. It should be noted that the same image(s)
areretrievable through non VB/ODBC applications.
 
>
> Feedback very much appreciated.
>
> Alanoly Andrews.
>
> -----Original Message-----
> From: Alanoly Andrews
> Sent: Friday, September 05, 2014 11:33 AM
> To: 'Adrian Klaver'; 'Craig James'
> Cc: pgsql-admin@postgresql.org; pgsql-general@postgresql.org
> Subject: RE: [GENERAL] Re: [ADMIN] Cannot retrieve images inserted through VB and odbc, after a table
reorganization.
>
> Hi Adrian,
>
> 1. We are storing our large objects in a table column whose datatype is "lo" (which, I understand, ultimately is in
fact"bytea").
 
> 2. The error messge returned to the VB is, yes, very generic. And the backend postgres server does not have any
messagesrelevant to this issue.
 
> 3. We set the trace on in the odbc driver and got a large log file, from which I give below the part that I think is
significant.

> It refers to the "buffer size being too small". Where, in the odc settings,  do we set the buffer size?

It isn't a problem.

> STELimageViewOn 834-fec          EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                        1 <SQL_C_CHAR>
>                                  PTR                 0x0018EECF [       0] ""
>                                  SQLLEN                     0
>                                  SQLLEN *            0x0018EEA4 (6)
>
>                                  DIAG [01004] The buffer was too small for the GetData. (-2)
>
> STELimageViewOn 834-fec          ENTER SQLGetData
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                       -2 <SQL_C_BINARY>
>                                  PTR                 <unknown type>
>                                  SQLLEN                     0
>                                  SQLLEN *            0x0018EE54
>
> STELimageViewOn 834-fec          EXIT  SQLGetData  with return code 1 (SQL_SUCCESS_WITH_INFO)
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                       -2 <SQL_C_BINARY>
>                                  PTR                 <unknown type>
>                                  SQLLEN                     0
>                                  SQLLEN *            0x0018EE54 (46165)
>
>                                  DIAG [01004] The buffer was too small for the GetData. (-2)
>
> STELimageViewOn 834-fec          ENTER SQLGetData
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                       -2 <SQL_C_BINARY>
>                                  PTR                 <unknown type>
>                                  SQLLEN                 32768
>                                  SQLLEN *            0x003CE284
>

> STELimageViewOn 834-fec          EXIT  SQLGetData  with return code -1 (SQL_ERROR)
>                                  HSTMT               0x002BFC70
>                                  UWORD                        2
>                                  SWORD                       -2 <SQL_C_BINARY>
>                                  PTR                 <unknown type>
>                                  SQLLEN                 32768
>                                  SQLLEN *            0x003CE284

>                                  DIAG [S1000] Error reading from large object. (1)

This is a problem.
Could you take Mylog output and send it to me?

regards,
Hiroshi Inoue

--
I am using the free version of SPAMfighter.
SPAMfighter has removed 12510 of my spam emails to date.
Get the free SPAMfighter here: http://www.spamfighter.com/len

Do you have a slow PC? Try a Free scan
http://www.spamfighter.com/SLOW-PCfighter?cid=sigen

________________________________

If you no longer wish to receive any of our emails, click on
UNSUBSCRIBE.<mailto:unsubscribe@invera.com?subject=***Unsubscribe***>This e-mail may be privileged and/or confidential,
andthe sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the
informationit contains by other than an intended recipient is unauthorized. If you received this e-mail in error,
pleaseadvise me (by return e-mail or otherwise) immediately.
 

Si vous ne désirez plus recevoir de nos courriels, veuillez appuyer sur
DÉSABONNEMENT.<mailto:unsubscribe@invera.com?subject=***Unsubscribe***>Ce courriel est confidentiel et protégé.
L'expéditeurne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce
messageou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est
interdite.Si vous recevez ce courriel par erreur, veuillez m'en aviser immédiatement, par retour de courriel ou par un
autremoyen.