By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,265 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

Adding long text to a database text field generates errors

P: n/a
I'm using PostgreSQL on a Windows 2000 server and cygwin. All is set up
just fine. The database works just fine, and ASP is connecting to the
database through a DSN just fine. The only problem I seem to have is
adding a large amount of text to a text column in the database. I can
enter up to 8,118 characters (including spaces), but when I go over that
amount, I receive the following error:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.

This error doesn't mean much to me. I've spent a month researching it
and trying to figure out what it means in our situation, but I have yet
to resolve it. Thus, I'm turning to this list to see if anyone has any
ideas or has tackled this problem before.

I've tried using the appendChunk method in ASP to add chunks to the
field in the database (this worked before for us on a Linux box running
ChiliSoft ASP), but I get another error saying that the method is not
supported. We are using psqlODBC to connect with the DSN--I do not know
if this driver has anything to do with this circumstance.
I am currently using ADO to update the database, but I have used a
standard SQL INSERT statement for testing, and I get the same error and
problem. When I've run an INSERT query against the database itself
(from the command prompt), it won't update the record when I try
inserting more than 8,118 characters into a text column.

I've double-checked to make sure the column is of datatype "text" and
not anything else. It is. So, it should accept unlimited text, right?

Has anyone seen this problem before? I need help ASAP because our
client is refusing to pay until this is resolved.

Thanks,
Ben
Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Ben Ramsey <br@benandliz.com> writes:
I can enter up to 8,118 characters (including spaces), but when I go
over that amount, I receive the following error: Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
Multiple-step OLE DB operation generated errors. Check each OLE DB
status value, if available. No work was done.


Weird. I dunno what's going on, but I suspect the people who will know
hang out on the pgsql-odbc list. Try there if you don't get any answers
here.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.