Microsoft KB Archive/309290

= Package Creation Errors Cause SQL Errors =

Article ID: 309290

Article Last Modified on 2/22/2007

-

APPLIES TO


 * Microsoft Host Integration Server 2000 Standard Edition

-



This article was previously published under Q309290



SYMPTOMS
When you attempt to query the host for data by using the OLE DB Provider for DB2, you may receive the following error message:

[OLE/DB provider returned Msg: [Microsoft][ODBC Driver for DB2][Microsoft DB2 OLE DB Provider]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: 42501, SQLCODE: -551]



CAUSE
The Create Package Utility is experiencing permission errors when it attempts to create a package, but is not returning a message that indicates that a problem exists. If you enable logging from within the Crtpkg.exe utility, you see output that resembles the following: Beginning creation process Initializing environment... Connecting to the host... Connection established. Start package creation process... Creating READ UNCOMMITTED package... READ UNCOMMITTED package created. Package creation succeeded. Errors occured when granting privilege on MSUR001. RETCODE=-1. 0 errors reported. Free statement handles... Disconnecting... Disconnected End of package creation. Creation process has completed NOTE: To enable logging, select Out to a log file on the Options menu.



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:

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 Host Integration Server 2000. This problem was first corrected in Host Integration Server 2000 Service Pack 1.



MORE INFORMATION
With the fix in place, if permission errors are encountered, the Create Package Utility stops the creation process and reports the error. If multiple packages are being created, the Create Package Utility attempts to create the rest of the packages.

Additional query words: oledb2 create package, db2 his

Keywords: kbbug kbfix kbhostintegserv2000presp1fix kbhostintegserv2000sp1fix KB309290

-

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

© Microsoft Corporation. All rights reserved.