Knowledge Base

FIX: Four-Part Inserts to DB2 Through LinkedServer Fail

Article ID: 274160

Article Last Modified on 3/10/2004

APPLIES TO

Microsoft OLE DB Provider for DB2
Microsoft OLE DB Provider for DB2
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>. 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.

Additional query words: Mainframe OS/390 MVS DQP DB2/MVS

Keywords: kbbug kbfix kbsna400presp4fix kbsna400sp4fix KB274160

Microsoft KB Archive/274160

Contents