473,322 Members | 1,714 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Getchunk and AppendChunk

I'm having trouble getting more than 2000 characters into an Oracle
10g CLOB column, and was trying to use the AppendChunk method in
Access 97. I guess I haven't broken the code yet, since I still
haven't been able to get more than 2000 chars into the field, or maybe
I should say that when I do, my module errors out on the line which
says r2.update.

I'm not sure if it is an Oracle or Access problem. If anyone knows,
please help.

Thanks,
Bill Hutchison

Feb 25 '06 #1
1 5215
After the line that says

I would add a line that says


"Bill Hutchison" <bi***@gci.net> wrote in message
news:43**************@news.gci.net...
I'm having trouble getting more than 2000 characters into an Oracle
10g CLOB column, and was trying to use the AppendChunk method in
Access 97. I guess I haven't broken the code yet, since I still
haven't been able to get more than 2000 chars into the field, or maybe
I should say that when I do, my module errors out on the line which
says r2.update.

I'm not sure if it is an Oracle or Access problem. If anyone knows,
please help.

Thanks,
Bill Hutchison

Feb 25 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: Bill | last post by:
Hi all, I have an asp page that writes to an ntext field in SQL Server 2000. All was going well until I had to put in a section of text greater than 8000 bytes. Then I got a timeout error and...
3
by: Adam | last post by:
I have an ASP page that will take form info that a user has entered, then save it into SQL server, and retrive and display the info on another page. My problem is with long text data (10,000 bytes...
1
by: Bill | last post by:
Hi all, I have an asp page that writes to an ntext field in SQL Server 2000. All was going well until I had to put in a section of text greater than 8000 bytes. Then I got a timeout error and...
1
by: John Hoffman | last post by:
Hello I have a legacy SQL Database that uses ADO and AppendChunk to store a BLOB of data in a column. It was written in C++ I am now trying to retrieve that data back using C# and a DataReader...
4
by: Mark | last post by:
Hi I am attempting to load data from an ADO recordset (data type = image on SQL server) into a rich text box. I can save data from the box to the server ok but I can't display it :@( I keep...
16
by: Mark | last post by:
Hello. I am attempting to use AppendChunk() to write binary data to a memo field in Access 2000. My initial call to AppendChunk() results in a data type conversion error. Any suggestions? Here...
0
by: xkp | last post by:
Hi all, i just had to install the 5.0 version of mysql. previously i used an old 3."something" (my server crashed so i dont remember the precise version). I used to access mysql database using...
3
by: Ariharan | last post by:
I have created a table in access with memo field.Now this table is not able to use in Vb coding
2
by: =?Utf-8?B?QUEyZTcyRQ==?= | last post by:
ADO has GetChunk & AppendChunk, features that are not supported by ADO.NET. Is there a workaround in ADO.NET? I am trying to write large files to LOB fields in a database table.
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.