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: "Hiroshi Inoue" <inoue(at)tpf(dot)co(dot)jp>
Cc: <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: odbc 8.01.02 8190 bytes limitation
Date: 2006-04-26 13:51:46
Message-ID: 018201c66938$91133d00$027ba8c0@NSTMike (view raw or flat)
Thread:
Lists: pgsql-odbc
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.
>
>
> 



In response to

Responses

pgsql-odbc by date

Next:From: Ludek FinstrleDate: 2006-04-26 14:03:02
Subject: Re: odbc 8.01.02 8190 bytes limitation
Previous:From: Ludek FinstrleDate: 2006-04-26 13:11:13
Subject: Re: Support for PostgreSQL 8.1.3 stable

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