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: The OLE DB Provider for DB2 returns inaccurate data in a Host Integration Server 2010 environment when a VARCHAR column is longer than 8,192 characters and the column contains an empty string


View products that this article applies to.

Symptoms

Consider the following scenario:
  • In a Microsoft Host Integration Server 2010 environment, you have the hotfix installed that is described in the following Microsoft Knowledge Base article:
    2559748  FIX: Incorrect values are written to DB2 when you send an empty string to DB2 by using SQL Server Integration Services in a Host Integration Server 2010 environment
  • You use the Microsoft OLE DB Provider for DB2 to read from a VARCHAR column that is longer than 8,192 characters.
  • The column contains an empty string.
In this scenario, you receive inaccurate data.

Notes
  • If the column does not contain an empty string, the column value is read correctly.
  • If you use the Microsoft.HostIntegration.MsDb2Client namespace, the problem does not occur.

↑ Back to the top


Resolution

The hotfix that resolves this issue is included in Cumulative Update 1 for Host Integration Server 2010.

For more information about how to obtain this cumulative update package, click the following article number to view the article in the Microsoft Knowledge Base:
2533330 Cumulative update package 1 for Host Integration Server 2010

↑ Back to the top


Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top


Keywords: kbnotautohotfix, kbqfe, kbfix, kbexpertiseinter, kbsurveynew, kbbug, kb

↑ Back to the top

Article Info
Article ID : 2584652
Revision : 2
Created on : 9/26/2018
Published on : 9/26/2018
Exists online : False
Views : 287