Re: odbc 8.01.02 8190 bytes limitation - Mailing list pgsql-odbc

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@pzkagis.cz>
To: "Michael GUIARD" <m.guiard@nestor-tech.com>
Cc: <pgsql-odbc@postgresql.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.
>
>
>