Microsoft KB Archive/274160

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

