FIX: Four-Part Inserts to DB2 Through LinkedServer Fail (274160)


The information in this article applies to:

  • Microsoft OLE DB Provider for DB2 4.0 SP2
  • Microsoft OLE DB Provider for DB2 4.0 SP3
  • Microsoft ODBC Driver for DB2 4.0 SP2
  • Microsoft ODBC Driver for DB2 4.0 SP3
This article was previously published under Q274160

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]

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 How to Obtain the Latest SNA Server Version 4.0 Service Pack

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.

REFERENCES

SQL Server books online.
Modification Type:MinorLast Reviewed:3/10/2004
Keywords:kbbug kbfix kbSNA400PreSP4fix kbSNA400sp4fix KB274160
©2004 Microsoft Corporation. All rights reserved.