FIX: Inserted LONGRAW Data Truncated with MSDAORA Provider Using AppendChunk (236790)


The information in this article applies to:

  • Microsoft OLE DB Provider for Oracle 2.0
  • Microsoft OLE DB Provider for Oracle 2.1
  • Microsoft Data Access Components 2.5
This article was previously published under Q236790

SYMPTOMS

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.

RESOLUTION

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

STATUS

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.
Modification Type:MajorLast Reviewed:11/17/2003
Keywords:kbbug kbDatabase kbfix kbMDAC260fix kbMDACNoSweep kbOracle kbProvider KB236790
©2003 Microsoft Corporation. All rights reserved.