CRTPKG Fails If Package Collection Includes Special Characters (298648)


The information in this article applies to:

  • Microsoft Host Integration Server 2000
This article was previously published under Q298648

SYMPTOMS

The Create Packages for DB2 (Crtpkg.exe) utility that is included with Host Integration Server 2000 fails to create DB2 packages on an AS/400 if the Package Collection (that is, the AS/400 Library) name in the Data Link Properties of the specified OLE DB data source contains any of the following special characters:
  • At sign (@)
  • Number sign (#)
  • Dollar sign ($)
The Results windows in the Create Packages for DB2 utility contains the following when you try to create packages in an AS/400 Library (that is, LIB#1) that contains one or more of the specified special characters:

Beginning creation process
Initializing environment...
Connecting to the host...
Connection established.
Start package creation process...
Creating AUTOCOMMITTED (NC) package...
AUTOCOMMITTED (NC) package created.
Package creation succeeded.
Errors occurred when granting privilege on MSNC001           .  RETCODE=-1.
0 errors reported.
Free statement handles...
Disconnecting...
Disconnected
End of package creation.
Creation process has completed

CAUSE

The OLE DB Provider for DB2 does not correctly parse Package Collection names that include the special characters that are listed in the "Symptoms" section.

RESOLUTION

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

328152 How to Obtain the Latest Host Integration Server 2000 Service Pack

The English version of this fix should have the following file attributes or later:

File nameDateTime
crtpkg.dll05/04/200110:20AM

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 at the beginning of this article. This problem was first corrected in Host Integration Server 2000 Service Pack 1.
Modification Type:MinorLast Reviewed:4/7/2005
Keywords:kbBug kbfix kbHostIntegServ2000preSP1fix kbHostIntegServ2000SP1fix KB298648
©2004 Microsoft Corporation. All rights reserved.