Microsoft KB Archive/911174

From BetaArchive Wiki

Article ID: 911174

Article Last Modified on 12/4/2007



APPLIES TO

  • Microsoft Host Integration Server 2004 Standard Edition
  • Microsoft OLE DB Provider for DB2




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.

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 name File version File size Date Time Platform SP requirement
Db2oledb.dll 6.0.2021.0 487,936 17-Mar-2006 00:34 x86 SP1
Db2oledb.h Not Applicable 24,516 17-Mar-2006 00:40 Not Applicable SP1
Ddmstr.dll 6.0.2021.0 44,032 17-Mar-2006 00:34 x86 SP1
Drdaresync.exe 6.0.2021.0 337,408 17-Mar-2006 00:34 x86 SP1
Microsoft.hostintegration.dataaccesslibrary.dll 6.0.2021.0 86,016 17-Mar-2006 00:34 x86 SP1
Microsoft.hostintegration.dataaccesstool.exe 6.0.2021.0 2,703,360 17-Mar-2006 00:35 x86 SP1
Microsoft.hostintegration.msdb2client.dll 6.0.2021.0 114,688 17-Mar-2006 00:34 x86 SP1
Mseidb2c.dll 6.0.2021.0 71,680 17-Mar-2006 00:34 x86 SP1
Mseidb2d.dll 6.0.2021.0 435,200 17-Mar-2006 00:34 x86 SP1
Mseidrda.dll 6.0.2021.0 694,784 17-Mar-2006 00:35 x86 SP1

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 name File version File size Date Time Platform
Db2oledb.dll 7.0.2485.0 507,392 25-Feb-2006 01:38 x86
Microsoft.hostintegration.dataaccesslibrary.dll 7.0.2485.0 2,554,640 27-Feb-2006 23:33 x86
Microsoft.hostintegration.dataaccesstool.exe 7.0.2485.0 617,224 27-Feb-2006 23:33 x86
Mseidrda.dll 7.0.2485.0 765,440 25-Feb-2006 01:39 x86

64-bit (x64) version

File name File version File size Date Time Platform Service branch
Db2oledb.dll 7.0.2485.0 747,008 25-Feb-2006 02:29 x64 Not Applicable
Microsoft.hostintegration.dataaccesslibrary.dll 7.0.2485.0 2,550,544 27-Feb-2006 23:04 x64 Not Applicable
Microsoft.hostintegration.dataaccesstool.exe 7.0.2485.0 613,128 27-Feb-2006 23:04 x64 Not Applicable
Mseidrda.dll 7.0.2485.0 1,332,736 25-Feb-2006 02:29 x64 Not Applicable
Db2oledb.dll 7.0.2485.0 507,392 25-Feb-2006 01:38 x86 SYSWOW
Mseidrda.dll 7.0.2485.0 765,440 25-Feb-2006 01:39 x86 SYSWOW

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.

Keywords: kbinfo kbfix kbpubtypekc kbmsccsearch kbexpertiseinter kbhotfixserver kbhis2004 kbdb2oledb KB911174