Microsoft KB Archive/309290

From BetaArchive Wiki
Knowledge Base


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:

File name Date Time
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.


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