Knowledge Base

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.

RESOLUTION

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.

REFERENCES

For additional information about DB2 packages and other related topics, click the following article numbers to view the articles in the Microsoft Knowledge Base:

235631 Crtpkgw.exe Hangs While Trying to Create Packages in DB2 When Connected over TCP/IP

216810 Creating Packages for Use with ODBC Driver for DB2 and OLE DB Provider for DB2

The third-party products that are discussed in this article are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

Keywords: kbqfe KB818622

Microsoft KB Archive/818622

Contents