Re: odbc 8.01.02 8190 bytes limitation

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
Subject: Re: odbc 8.01.02 8190 bytes limitation
Date: 2006-04-26 12:58:14
Message-ID: 444F6E66.4090604@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

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

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Ludek Finstrle 2006-04-26 13:11:13 Re: Support for PostgreSQL 8.1.3 stable
Previous Message Philippe Lang 2006-04-26 07:56:31 Re: PG 8 INOUT parameters & ADO