Re: ADO-Error when inserting row with text column with large text

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: ADO-Error when inserting row with text column with large text
Date: 2013-06-14 14:07:45
Message-ID: 51BB23B1.2030905@tpf.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

Hi Josef,

(2013/06/14 16:00), Josef Springer wrote:
> Hello,
>
> i am using
> - PostgreSQL 8.2.5
> - ODBC: PostgreSQL Unicode 8.02.04.0
>
> When i am inserting via the ADO-driver a row with column text with
> textsize about 10000, i get the ado error 0x80004005.
> Inserting the same row with the SQL-editor in pgAdmin III works fine.
>
> The ado details:
> Using cursorLocation = adUseClient
> Using lockType = adLockBatchOptimistic
> recordset editNew ... putting column values ... recordset addNew,
> recordSet updateBatch (thows the ado error)
>
> Has the ADO-diver any limitation ?
> Thanks for any help !

Please try to increase *MaxLongVarcharSize*.

regards,
Hiroshi Inoue

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Josef Springer 2013-06-14 14:49:39 Re: ADO-Error when inserting row with text column with large text
Previous Message Heikki Linnakangas 2013-06-14 13:37:38 Re: ADO-Error when inserting row with text column with large text