SYMPTOMS
When an application uses the OLE DB Provider for DB2 (DB2OLEDB) to execute a stored procedure, 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
This problem may occur under the following circumstances:
- The call to execute the stored procedure is the first statement that is passed to DB2OLEDB.
- The packages do not exist on DB2.
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 hotfix has the file attributes (or later file attributes) 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
-------------------------------------------------------
07-Nov-2003 19:47 5.0.0.950 311,568 Crtpkg.dll
07-Nov-2003 19:47 5.0.0.950 688,400 Db2oledb.dll
07-Nov-2003 19:47 5.0.0.950 53,552 Ddmstr.dll
07-Nov-2003 19:47 5.0.0.950 78,096 Mseidb2c.dll
07-Nov-2003 19:47 5.0.0.950 885,008 Mseidb2d.dll
07-Nov-2003 19:47 5.0.0.950 24,848 Mseidpm.dll
07-Nov-2003 19:47 5.0.0.950 266,512 Mseidrda.dll
07-Nov-2003 19:47 5.0.0.950 147,728 Mseidt.dll
07-Nov-2003 19:47 5.0.0.950 65,808 Crtpkg.exe
07-Nov-2003 19:47 5.0.0.950 82,192 Ddmserv.exe
Note Because of file dependencies, the most recent fix that contains the previous files may also contain additional files.
REFERENCES
For more information about another common cause of the SQLCODE: -805 error, click the following article number to view the article in the Microsoft Knowledge Base:
269626
Permissions needed to create packages using DB2OLEDB on DB2 and DB2/400
For more information about DB2 packages, click the following article number to view the article in the Microsoft Knowledge Base:
216810
Creating packages for use with ODBC Driver for DB2 and OLE DB Provider for DB2