Microsoft KB Archive Search

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.

  1. Home
  2. FIX: Incorrect results are passed to the DB2 table in Host Integration Server 2013

FIX: Incorrect results are passed to the DB2 table in Host Integration Server 2013

View products that this article applies to.

Symptoms

You run an application that uses the Managed Provider for DB2 that's included in Microsoft Host Integration Server 2013. When you try to pass a parameter that does not specify the MsDb2Type value or when an incorrect value is used, incorrect results are passed to the DB2 table.

Note For example, this problem occurs in the following code example:

Dim Test As Decimal = 12.1234
param.MsDb2Type = MsDb2Type.Int
param.Value = Test
MyCommand.Parameters.Add(param)

Note Even if an incorrect data type is specified by the Managed Provider for DB2, the value is passed to the DB2 table.

↑ Back to the top

Cause

This problem occurs because the Managed Provider for DB2 does not perform validation regardless of whether a value is typed correctly or incorrectly. Nor does it prevent incorrect values from being passed to DB2.

↑ Back to the top

Resolution

Cumulative update information

The fix that resolves this problem is included in Cumulative Update 2 for Host Integration Server 2013.

↑ 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: kbqfe, kbfix, kbnotautohotfix, kbexpertiseinter, kbbug, kbsurveynew, kb

↑ Back to the top

Article Info
Article ID : 2950344
Revision : 1
Created on : 1/7/2017
Published on : 12/3/2014
Exists online : False
Views : 330