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" (911174)
The information in this article applies to:
- Microsoft Host Integration Server 2004
- Microsoft OLE DB Provider for DB2 1.0
INTRODUCTIONWhen 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 informationHost Integration Server 2004A 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. |
| 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.0A 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|
| 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|
| 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.
| Modification Type: | Major | Last Reviewed: | 3/31/2006 |
|---|
| Keywords: | kbHotfixServer kbfix kbHIS2004 kbDB2OLEDB kbExpertiseInter kbinfo kbmsccsearch kbpubtypekc KB911174 kbAudDeveloper |
|---|
|
|
|
©2004 Microsoft Corporation. All rights reserved.
|
|