FIX: Four-Part Inserts to DB2 Through LinkedServer Fail

View products that this article applies to.

This article was previously published under Q274160

Expand all | Collapse all

SYMPTOMS

If a LinkedServer is configured by using SQL Server to DB2 (OS/390 version 5.1) with the Microsoft OLE DB Provider for DB2 (DB2OLEDB) or the Microsoft ODBC Driver for DB2 (MSDB2OLE), and an INSERT statement is issued by using the four-part syntax similar to the following

INSERT INTO <LinkedServer Name>.<Catalog>.<Owner>.<Table name> VALUES (...)

the following error message may be reported:

[OLE/DB provider returned message: A SQL error has occurred. Please consult the documentation for your specific DB2 version for a description of the associated Native Error and SQL State. SQLSTATE: 24501, SQLCODE: -501]

Back to the top

RESOLUTION

To resolve this problem, obtain the latest service pack for SNA Server 4.0. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

215838 (http://support.microsoft.com/kb/215838/EN-US/ ) How to Obtain the Latest SNA Server Version 4.0 Service Pack

Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

This problem was first corrected in SNA Server 4.0 Service Pack 4.

Back to the top