FIX: "SQLCODE -290, invalid description" error in the Managed Provider for DB2 when you use named parameters

Symptoms

When you run a parameterized query by using the Managed Provider for DB2 that is included in Microsoft Host Integration Server 2013, the query may fail, and you receive the following error message:

Cause

This problem may occur when you are using named parameters and use one of the named parameters two times in your query. The following code sample shows this problem:

cm.CommandText = "SELECT * from TABLE WHERE COL1 = @COL and COL2 = @COL";
cm.Parameters.AddWithValue("@COL", "AAA");

      

Resolution

Cumulative update information

The fix that resolves this problem is included in Cumulative Update 1 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.