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: A four-part named linked server query that contains a CALL statement against a "DB2 for i" database fails


View products that this article applies to.

Symptoms

You run a SQL Server Distributed Query for DB2. If the query is a four-part named linked server query, and it contains a CALL statement against a DB2 for i database, the query fails. Additionally, you receive an error message that resembles the following:
OLE DB provider "DB2OLEDB" for linked server "linked_server_name" returned message "An internal network library error has occurred. A network level syntax error has occurred. SQLSTATE: HY000, SQLCODE: -379".

Msg 7212, Level 17, State 1, LineNumber  Could not execute procedure 'procedure_name' on remote server 'remote_server_name'. "

↑ 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.

Third-party information disclaimer

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, about the performance or reliability of these products.

 

↑ Back to the top


Keywords: kbQFE, kbfix, kbBug, kbExpertiseInter, kbsurveynew

↑ Back to the top

Article Info
Article ID : 4023740
Revision : 7
Created on : 3/26/2018
Published on : 3/26/2018
Exists online : False
Views : 380