I am trying to use AppendChunk to write a large amount of data into a recordset field of an ADO object. The target is a SQL 7 database with the field datatype of ntext. I keep getting "errors occurred". Any ideas?? The size of the data is approx. 60k or 40k characters.

-- Anonymous, March 20, 2000

Answers

Walker,

To diagnose this you must dig a little deeper to find an error number or error message. You might find more information in the SQL Error log and NT Event Viewer.

In the meantime, check out the Knowledge Base article, HOWTO: Sample Functions Demonstrating GetChunk and AppendChunk http://support.microsoft.com/support/kb/articles/Q194/9/75.ASP.

Good Luck,

Eric

-- Anonymous, March 22, 2000