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

Hi Hiroshi,<br /><br /> thanks for your hint. <br /> But where to change *MaxLongVarcharSize* ?<br /> I open the
recordsetwith <br /><i>Open( "select * from table", activeConnection: "Driver={PostgreSQL
Unicode};Server=localhost;Uid=<uid>;Pwd=<pwd>;Database=<database>")</i><br /> I do not know where to
givethis option. In an ODBC-Setting, there ist the possibility to define *MaxLongVarcharSize*, but i am using the
driverby gibving its systemname.<br /><br /> Thanks for your hints !<br /><br /> Josef Springer<br /><br /> On
14.06.201316:07, Hiroshi Inoue wrote: <blockquote cite="mid:51BB23B1.2030905@tpf.co.jp" type="cite">Hi Josef, <br /><br
/>(2013/06/14 16:00), Josef Springer wrote: <br /><blockquote type="cite">Hello, <br /><br /> i am using <br /> -
PostgreSQL8.2.5 <br /> - ODBC: PostgreSQL Unicode 8.02.04.0 <br /><br /> When i am inserting via the ADO-driver a row
withcolumn text with <br /> textsize about 10000, i get the ado error 0x80004005. <br /> Inserting the same row with
theSQL-editor in pgAdmin III works fine. <br /><br /> The ado details: <br /> Using cursorLocation = adUseClient <br />
UsinglockType = adLockBatchOptimistic <br /> recordset editNew ... putting column values ... recordset addNew, <br />
recordSetupdateBatch (thows the ado error) <br /><br /> Has the ADO-diver any limitation ? <br /> Thanks for any help !
<br/></blockquote><br /> Please try to increase *MaxLongVarcharSize*. <br /><br /> regards, <br /> Hiroshi Inoue <br
/><br/><br /><br /></blockquote><br /><div class="moz-signature"><br /></div>