BUG: Parameterized Queries that Are Not Prepared Fail to Execute Through DB2OLEDB

ID: Q235299

The information in this article applies to:

SYMPTOMS

When 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:
Statement not prepared.


WORKAROUND

Prepare the command using the ICommandPrepare::Prepare method.


STATUS

Microsoft has confirmed this to be a problem in Microsoft SNA Server version 4.0 Service Pack 2.

Additional query words: MSDB2OLE Mainframe AS/400 MVS OS/390 OS/400 


Keywords          : 
Version           : WINDOWS:4.0 SP2
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: June 28, 1999