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: Dynamic Insert statement with AddWithValue fails with SQLCODE -206


View products that this article applies to.

Symptoms

When you run a dynamic Insert statement that uses the AddWithValue method, the statement fails, and you receive the following error message:

Error Message SqlCode = -206 error message: @Parameter_Name IS NOT VALID IN THE CONTEXT WHERE IT IS USED

↑ Back to the top


Resolution

This problem is fixed in Cumulative Update 1 for Host Integration Server 2016.

↑ 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


References

Learn about the terminology Microsoft uses to describe software updates.

↑ Back to the top


Keywords: kbQFE, kbfix, kbBug, kbExpertiseInter, kbsurveynew

↑ Back to the top

Article Info
Article ID : 4010357
Revision : 14
Created on : 5/22/2017
Published on : 5/22/2017
Exists online : False
Views : 220