Re: odbc 8.01.02 8190 bytes limitation

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 !

I am a bit lost with these errors. I am not a database specialist and may be
I do not use the good way to insert binary data. I also will try to insert
binary data using the ado streams ....

thanks for your help
Mike

----- Original Message -----
From: "Ludek Finstrle" <luf(at)pzkagis(dot)cz>
To: "Michael GUIARD" <m(dot)guiard(at)nestor-tech(dot)com>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Sent: Tuesday, April 25, 2006 12:37 PM
Subject: Re: [ODBC] odbc 8.01.02 8190 bytes limitation

>> I use PostgreSQL database via ado (win32).
>> I succeeded in storing/retrieving binary format (bytea) to/from
>> database (I use it for images).
>>
>> But I am limited to 8190 bytes. Is it a way to disable this limitation ?
>
> Could you try 07.03.026X version? It's enhanced experimental branch which
> is now CVS tip and it'll be released as new stable release in relatively
> short time. IMHO it's more stable version.
>
>> I saw that the odbc have a MaxLongVarChar option set to 8190. May be
>> my problem come from this, but how can I update this option using ado ?
>
> There is connection string too in ADO. So specify it in it.
>
>> I saw many posts about this subject but I did not find the
>> solution - may be I am too blind today ;)
>
> I don't want waste my time in developing dead branch (which 08.01 is).
>
> Regards,
>
> Luf
> ---------------------------------------------------------------------------------------
> 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.
>
>
>