The information in this article applies to:
SYMPTOMSWhen you run a query containing parameter markers like the following: UPDATE EMPLOYEE SET DEPTNO = 20 WHERE DEPTNO = ?and the query is not prepared using the ICommandPrepare::Prepare method, the OLE DB Provider for DB2 returns E_FAIL with the following error message:
RESOLUTIONTo resolve this problem, obtain the latest service pack for SNA Server version 4.0. For additional information, please see the following article in the
Microsoft Knowledge Base: Q215838 How to Obtain the Latest SNA Server Version 4.0 Service Pack WORKAROUNDPrepare the command using the ICommandPrepare::Prepare method. STATUSMicrosoft has confirmed this to be a problem in Microsoft SNA Server version 4.0 Service Pack 2. This problem was first corrected in SNA Server version 4.0 Service Pack 3. Additional query words: MSDB2OLE Mainframe AS/400 MVS OS/390 OS/400
Keywords : sna4sp3fix |
Last Reviewed: September 29, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |