Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

FIX: Inserted LONGRAW Data Truncated with MSDAORA Provider Using AppendChunk

View products that this article applies to.

This article was previously published under Q236790

↑ Back to the top


When Using ActiveX Data Objects (ADO) and AppendChunk, Microsoft OLE DB Provider for Oracle truncates data that is being inserted into LONGRAW and LONG datatypes. Approximately 40K inserts into a LONGRAW field, while about 64K inserts into a LONG field.

↑ Back to the top


The only workaround is to use OLE DB Provider for ODBC and the Microsoft Oracle ODBC driver instead of OLE DB Provider for Oracle.

↑ Back to the top


Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

This problem was corrected in MDAC 2.6.

↑ Back to the top

Keywords: KB236790, kbprovider, kboracle, kbmdacnosweep, kbmdac260fix, kbfix, kbdatabase, kbbug

↑ Back to the top

Article Info
Article ID : 236790
Revision : 3
Created on : 11/17/2003
Published on : 11/17/2003
Exists online : False
Views : 318