Re: 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