Re: ADO-Error when inserting row with text column with large text - Mailing list 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