<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
</head>
<body text="#000000" bgcolor="#ffffff">
Hi Hiroshi,<br>
<br>
thanks for your hint. <br>
But where to change *MaxLongVarcharSize* ?<br>
I open the recordset with <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 give this option. In an ODBC-Setting, there
ist the possibility to define *MaxLongVarcharSize*, but i am using
the driver by gibving its systemname.<br>
<br>
Thanks for your hints !<br>
<br>
Josef Springer<br>
<br>
On 14.06.2013 16:07, Hiroshi Inoue wrote:
<blockquote cite="mid:51BB23B1(dot)2030905(at)tpf(dot)co(dot)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>
- PostgreSQL 8.2.5
<br>
- ODBC: PostgreSQL Unicode 8.02.04.0
<br>
<br>
When i am inserting via the ADO-driver a row with column text
with
<br>
textsize about 10000, i get the ado error 0x80004005.
<br>
Inserting the same row with the SQL-editor in pgAdmin III works
fine.
<br>
<br>
The ado details:
<br>
Using cursorLocation = adUseClient
<br>
Using lockType = adLockBatchOptimistic
<br>
recordset editNew ... putting column values ... recordset
addNew,
<br>
recordSet updateBatch (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>
</body>
</html>