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

From: Josef Springer <Josef(dot)Springer(at)joops(dot)com>
To:
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: ADO-Error when inserting row with text column with large text
Date: 2013-06-14 07:00:02
Message-ID: 51BABF72.2090107@joops.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

<!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">
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
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,
recordSet updateBatch (thows the ado error)<br>
<br>
Has the ADO-diver any limitation ?<br>
Thanks for any help !<br>
<br>
Best Regards,<br>
Josef Springer<br>
<br>
<br>
</body>
</html>

Attachment Content-Type Size
unknown_filename text/html 996 bytes

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Heikki Linnakangas 2013-06-14 07:57:35 Re: ADO-Error when inserting row with text column with large text
Previous Message Joshua Berry 2013-06-13 19:30:32 Re: [ODBC] Segmentation Fault in Postgres server when using psqlODBC