Package Creation Errors Cause SQL Errors (309290)
The information in this article applies to:
- Microsoft Host Integration Server 2000
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.
RESOLUTIONTo 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:
|
| Crtpkg.dll | May-31-2001 | 12:00 |
NOTE: Because of file dependencies, the most recent fix that
contains the preceding files may also contain additional files.
STATUSMicrosoft 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.
| Modification Type: | Minor | Last Reviewed: | 3/11/2005 |
|---|
| Keywords: | kbbug kbfix kbHostIntegServ2000preSP1fix kbHostIntegServ2000SP1fix KB309290 |
|---|
|