Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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.

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.

Resolution

Cumulative update information

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

Status

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×