Microsoft KB Archive/818622

= FIX: Packages Are Not Created for Host Integration Server OLE DB Provider for DB2 =

Article ID: 818622

Article Last Modified on 7/14/2005

-

APPLIES TO


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

-





SYMPTOMS
When you try to use the Create Packages for DB2 utility (Crtpkg.exe) to create packages on an IBM DB2 Universal Database Version 8 for Windows, you may receive the following error message:

Errors occurred when granting privilege on MSCS001. RETCODE=-1. SQL Error: Code=-901, State=58004, Error Text=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: 58004, SQLCODE: -901 1 errors reported.

Four packages are created. The error is reported for each package that is created.

When you create the packages implicitly by connecting to the DB2 database for the first time through the Microsoft OLE DB Provider for DB2 (DB2OLEDB), or the Microsoft ODBC Driver for DB2 (both are included with the Microsoft Host integration Server), and you execute a statement, 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



CAUSE
The statement that is issued to create the packages is not valid.



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 fix has the file attributes (or later) 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 --  15-Apr-2003  19:47  5.0.0.904         311,568  Crtpkg.dll 15-Apr-2003 19:47  5.0.0.904         672,016  Db2oledb.dll 15-Apr-2003 19:47  5.0.0.904          53,552  Ddmstr.dll 15-Apr-2003 19:47  5.0.0.904          78,096  Mseidb2c.dll 15-Apr-2003 19:47  5.0.0.904         880,912  Mseidb2d.dll 15-Apr-2003 19:47  5.0.0.904          24,848  Mseidpm.dll 15-Apr-2003 19:47  5.0.0.904         262,416  Mseidrda.dll 15-Apr-2003 19:46  5.0.0.904         147,728  Mseidt.dll 15-Apr-2003 19:47  5.0.0.904          65,808  Crtpkg.exe 14-Apr-2003 10:55  5.0.0.903          82,192  Ddmserv.exe Note Because of file dependencies, the most recent fix that contains these files may also contain additional files.



WORKAROUND
There are no known workarounds.



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 corrected in Microsoft Host Integration Server 2000 Service Pack 2.

