Microsoft KB Archive/830301

= FIX: OLE DB Provider for DB2 does not create packages when a stored procedure is called =

Article ID: 830301

Article Last Modified on 10/26/2005

-

APPLIES TO


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

-



SYMPTOMS
When an application uses the OLE DB Provider for DB2 (DB2OLEDB) to execute a stored procedure, you may receive the following error 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: 51002, SQLCODE: -805

This problem may occur under the following circumstances:
 * The call to execute the stored procedure is the first statement that is passed to DB2OLEDB.
 * The packages do not exist on DB2.



CAUSE
DB2OLEDB does not call the function that is used to dynamically create the DB2 packages when a stored procedure is executed.



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 ---  07-Nov-2003  19:47  5.0.0.950    311,568  Crtpkg.dll 07-Nov-2003 19:47  5.0.0.950    688,400  Db2oledb.dll 07-Nov-2003 19:47  5.0.0.950     53,552  Ddmstr.dll 07-Nov-2003 19:47  5.0.0.950     78,096  Mseidb2c.dll 07-Nov-2003 19:47  5.0.0.950    885,008  Mseidb2d.dll 07-Nov-2003 19:47  5.0.0.950     24,848  Mseidpm.dll 07-Nov-2003 19:47  5.0.0.950    266,512  Mseidrda.dll 07-Nov-2003 19:47  5.0.0.950    147,728  Mseidt.dll 07-Nov-2003 19:47  5.0.0.950     65,808  Crtpkg.exe 07-Nov-2003 19:47  5.0.0.950     82,192  Ddmserv.exe Note Because of file dependencies, the most recent fix that contains the previous 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.

