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

Hi Hiroshi,

thanks for your hint.
But where to change *MaxLongVarcharSize* ?
I open the recordset with
Open( "select * from table", activeConnection: "Driver={PostgreSQL Unicode};Server=localhost;Uid=<uid>;Pwd=<pwd>;Database=<database>" )
I do not know where to give this option. In an ODBC-Setting, there ist the possibility to define *MaxLongVarcharSize*, but i am using the driver by gibving its systemname.

Thanks for your hints !

Josef Springer

On 14.06.2013 16:07, Hiroshi Inoue wrote:

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