Microsoft KB Archive/813321

= DB2OLEDB INSERT and UPDATE Statements May Fail When There Are More Than 84 Columns =

Article ID: 813321

Article Last Modified on 9/27/2005

-

APPLIES TO


 * Microsoft Host Integration Server 2000 Standard Edition
 * Microsoft Host Integration Server 2000 Service Pack 1

-



SYMPTOMS
When you run a previously prepared SQL statement such as an INSERT command or an UPDATE command and that command specifies more than 84 columns, the Microsoft OLE DB Provider for DB2 (DB2OLEDB) may fail with the following error message:

Invalid description. SQLSTATE: HY000, SQLCODE: -290



CAUSE
The DB2OLEDB provider uses the DDM SQLDTA codepoint to send the column descriptors and the data for the parameters of a previously prepared SQL statement such as an INSERT command or an UPDATE command. The column descriptions are sent in groups of up to 84. If you want to send more than 84 column descriptors, you must send in multiple groups. The DB2OLEDB provider is incorrectly limited to sending only one group of column descriptors in its SQLDTA message. The result is that the DB2OLEDB provider does not send all the column descriptors to the target DB2 system. In this scenario, the target system replies with a DDM DSCINVRM codepoint that is the &quot;Invalid description&quot; message.



Service pack information
To resolve this problem, obtain the latest service pack for Microsoft Host Integration Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

328152 How to obtain the latest service pack for Host Integration Server 2000

Hotfix information
The English version of this hotfix has the file attributes (or later file attributes) that are listed in the following table. The dates and times for these files are listed in Coordinated Universal Time (UTC). When you view the file information, it is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time tool in Control Panel.   Date         Time   Version            Size    File name --  21-Jan-2003  19:14  5.0.0.900         311,568  Crtpkg.dll 21-Jan-2003 19:14  5.0.0.900         667,920  Db2oledb.dll 21-Jan-2003 19:14  5.0.0.900          53,552  Ddmstr.dll 21-Jan-2003 19:14  5.0.0.900          78,096  Mseidb2c.dll 21-Jan-2003 19:14  5.0.0.900         880,912  Mseidb2d.dll 21-Jan-2003 19:14  5.0.0.900          24,848  Mseidpm.dll 21-Jan-2003 19:14  5.0.0.900         262,416  Mseidrda.dll 21-Jan-2003 19:14  5.0.0.900         147,728  Mseidt.dll 21-Jan-2003 19:14  5.0.0.900          65,808  Crtpkg.exe 01-Oct-2002 12:17  5.0.0.900          82,192  Ddmserv.exe

Note Because of file dependencies, the most recent fix that contains the preceding files may also contain additional files.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

This problem was corrected in Microsoft Host Integration Server 2000 Service Pack 2.



MORE INFORMATION
For more information about DDM and DDM commands, visit The Open Group Database Interoperability Consortium Web site:

http://www.opengroup.org/dbiop/

Keywords: kbbug kbfix kbqfe kbhotfixserver KB813321

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.