Re: odbc 8.01.02 8190 bytes limitation

Hi Hiroshi,

I did not find the ByteaAsLongVarchar option in the odbc driver. But because
of your request I searched a bit more and I saw the "byte as lo" option.
I tried it and now it works !! GOOOOD :)

So I configure the maxLongVarChar as -4 and check the "byte as lo" option,
and now I can store/retreive image of more than 16KB !
Thanks a lot for your help !!! :)

I tried with the 7.03.02.60 and 8.01.02 drivers. With the 7.03.02xx version
the recordset update takes very long time. With the 8.01.02 I have no
problems.

All is good for me except one thing : how can I set the "byte as lo" option
in the odbc connection string ?

Mike

----- Original Message -----
From: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
To: "Michael GUIARD" <m(dot)guiard(at)nestor-tech(dot)com>
Cc: "Ludek Finstrle" <luf(at)pzkagis(dot)cz>; <pgsql-odbc(at)postgresql(dot)org>
Sent: Wednesday, April 26, 2006 2:58 PM
Subject: Re: [ODBC] odbc 8.01.02 8190 bytes limitation

> Michael GUIARD wrote:
>
>> Hi Luf !
>> thanks for your answer.
>>
>> I will give you some precisions : I work with ado and odbc driver to
>> connect. For insertion in database I use variant types. For array my
>> variant is defined as this : VT_ARRAY|VT_UI1
>>
>> I tried the ODBC driver 7.03.02.60, I got the following errors :
>> - connection with default settings (maxLongVarChar = 8190) :
>> . less than 8k insertion : ERROR during field affectation :
>> "Multiple-step operation generated errors. Check each status value"
>> . less than 16k insertion : idem
>> ... idem
>> - connection with maxLongVarChar = 16382 :
>> . less than 8k insertion : idem as above
>> ... idem
>>
>> With the ODBC driver 8.01.02.00, I got the following errors :
>> - conenction with default settings : maxLongVarChar = 8190
>> . less than 8k insertion : OK !
>> . less than 16k insertion : ERROR during RecordSet update : Microsoft
>> cursor engine : data provider or other service returned an E_FAIL status.
>> ... idem as 16k insertion
>> - connection with maxLongVarChar = 16382 :
>> . less than 8k : OK !
>> . less than 16k : OK !
>> . more than 16k : ERROR during RecordSet update : Microsoft cursor
>> engine : data provider or other service returned an E_FAIL status.
>> - connection with maxLongVarChar = 32768 :
>> . less than 8k : ERROR during RecordSet update : type "lo" does not
>> exist
>> ... always the same error
>>
>> After to have inserted data of 8k with ODBC 8.01.02, if I tried to
>> connect with ODBC 7.03.02.60 and retrieve the data, I have no errors.
>> But if I try to insert new data, I have always the error : type "lo" does
>> not exist !
>
>
> Please turn on the ByteaAsLongVarchar option.
>
> regards,
> Hiroshi Inoue
> ---------------------------------------------------------------------------------------
> Wanadoo vous informe que cet e-mail a ete controle par l'anti-virus mail.
> Aucun virus connu a ce jour par nos services n'a ete detecte.
>
>
>