Skip site navigation (1) Skip section navigation (2)

Re: odbc 8.01.02 8190 bytes limitation

From: "Michael GUIARD" <michael(at)nestor-tech(dot)com>
To: "Ludek Finstrle" <luf(at)pzkagis(dot)cz>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: odbc 8.01.02 8190 bytes limitation
Date: 2006-04-26 07:52:51
Message-ID: 012301c66906$6c711b70$027ba8c0@NSTMike (view raw or flat)
Thread:
Lists: 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(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.
>
>
> 



In response to

Responses

pgsql-odbc by date

Next:From: Philippe LangDate: 2006-04-26 07:56:31
Subject: Re: PG 8 INOUT parameters & ADO
Previous:From: Hiroshi InoueDate: 2006-04-26 03:39:03
Subject: Re: PG 8 INOUT parameters & ADO

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group