Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Error message when you use Microsoft OLE DB Provider for DB2 (DB2OLEDB) to connect to an IBM DB2 database that is running on a Sun Microsystems Solaris system: "SQLSTATE 58004, SQLCODE -901"


View products that this article applies to.

Introduction

When you use Microsoft OLE DB Provider for DB2 (DB2OLEDB) to connect to an IBM DB2 database that is running on a Sun Microsystems Solaris system, OLE DB Provider for DB2 returns an error message that is similar to the following:
Could not connect to data source Data Source Name:
One or more errors occurred during processing of command.
A SQL system error has occurred. The current SQL statement cannot be completed successfully. SQLSTATE: 58004, SQLCODE: -901
An IBM DB2 database that is running on a Sun Microsystems Solaris system returns one of the following server class strings during the Exchange Server Attributes negotiation:
  • QDB2/SUN for 32-bit server systems
  • QDB2/SUN64 for 64-bit server systems
This error occurs because OLE DB Provider for DB2 does not recognize these server class strings. OLE DB Provider for DB2 was not tested in this IBM DB2 operating environment.

OLE DB Provider for DB2 is not officially supported for use with an IBM DB2 database that is running on a Sun Microsystems Solaris system. The following IBM DB2 operating environments are supported by OLE DB Provider for DB2:
  • IBM DB2 for z/OS version 7 and later versions to support an SNA LU 6.2 network connection or a TCP/IP network connection
  • IBM DB2 for OS/400 V5R1, IBM DB2 for i5/OS V5R3, and later versions to support an SNA LU 6.2 network connection or a TCP/IP network connection
  • IBM DB2 Universal Database version 8.1 and later versions for the Microsoft Windows operating system and for the IBM AIX operating system to support a TCP/IP network connection
The supported IBM DB2 operating environments and features are listed in the Installation Guide.htm file that is included with Microsoft Host Integration Server 2004.

↑ Back to the top


More information

OLE DB Provider for DB2 has been updated to support use with an IBM DB2 database that is running on a Sun Microsystems Solaris system. After you apply this feature, OLE DB Provider for DB2 correctly recognizes the server class strings that are returned by an IBM DB2 database that is running on a Sun Microsystems Solaris system.

Software update information

Host Integration Server 2004

A supported feature that modifies the product's default behavior is now available from Microsoft, but it is only intended to modify the behavior that this article describes. Apply it only to systems that specifically require it. This feature may receive additional testing. Therefore, if the system is not severely affected by the lack of this feature, we recommend that you wait for the next Host Integration Server 2004 service pack that contains this feature.

To obtain this feature immediately, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
File information
The English version of this feature 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.
File nameFile versionFile sizeDateTimePlatformSP requirement
Db2oledb.dll6.0.2021.0487,93617-Mar-200600:34x86SP1
Db2oledb.hNot Applicable24,51617-Mar-200600:40Not ApplicableSP1
Ddmstr.dll6.0.2021.044,03217-Mar-200600:34x86SP1
Drdaresync.exe6.0.2021.0337,40817-Mar-200600:34x86SP1
Microsoft.hostintegration.dataaccesslibrary.dll6.0.2021.086,01617-Mar-200600:34x86SP1
Microsoft.hostintegration.dataaccesstool.exe6.0.2021.02,703,36017-Mar-200600:35x86SP1
Microsoft.hostintegration.msdb2client.dll6.0.2021.0114,68817-Mar-200600:34x86SP1
Mseidb2c.dll6.0.2021.071,68017-Mar-200600:34x86SP1
Mseidb2d.dll6.0.2021.0435,20017-Mar-200600:34x86SP1
Mseidrda.dll6.0.2021.0694,78417-Mar-200600:35x86SP1
Note Because of file dependencies, the most recent feature that contains these files may also contain additional files.

OLE DB Provider for DB2 version 1.0

A supported feature that modifies the product's default behavior is now available from Microsoft, but it is only intended to modify the behavior that this article describes. Apply it only to systems that specifically require it. This feature may receive additional testing. Therefore, if the system is not severely affected by the lack of this feature, we recommend that you wait for the next OLE DB Provider for DB2 1.0 release that contains this feature.

To obtain this feature immediately, contact Microsoft Product Support Services. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:
File information
The English version of this feature 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.

32-bit (x86) version
File nameFile versionFile sizeDateTimePlatform
Db2oledb.dll7.0.2485.0507,39225-Feb-200601:38x86
Microsoft.hostintegration.dataaccesslibrary.dll7.0.2485.02,554,64027-Feb-200623:33x86
Microsoft.hostintegration.dataaccesstool.exe7.0.2485.0617,22427-Feb-200623:33x86
Mseidrda.dll7.0.2485.0765,44025-Feb-200601:39x86
64-bit (x64) version
File nameFile versionFile sizeDateTimePlatformService branch
Db2oledb.dll7.0.2485.0747,00825-Feb-200602:29x64Not Applicable
Microsoft.hostintegration.dataaccesslibrary.dll7.0.2485.02,550,54427-Feb-200623:04x64Not Applicable
Microsoft.hostintegration.dataaccesstool.exe7.0.2485.0613,12827-Feb-200623:04x64Not Applicable
Mseidrda.dll7.0.2485.01,332,73625-Feb-200602:29x64Not Applicable
Db2oledb.dll7.0.2485.0507,39225-Feb-200601:38x86SYSWOW
Mseidrda.dll7.0.2485.0765,44025-Feb-200601:39x86SYSWOW
Note Because of file dependencies, the most recent feature that contains these files may also contain additional files.

The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.

↑ Back to the top


Keywords: KB911174, kbinfo, kbexpertiseinter, kbdb2oledb, kbhis2004, kbfix, kbhotfixserver

↑ Back to the top

Article Info
Article ID : 911174
Revision : 3
Created on : 12/4/2007
Published on : 12/4/2007
Exists online : False
Views : 362