Microsoft KB Archive/911174

= 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: &quot;SQLSTATE 58004, SQLCODE -901&quot; =

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 :

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.

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:

http://support.microsoft.com/contactus/?ws=support

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.

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:

http://support.microsoft.com/contactus/?ws=support

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

64-bit (x64) version

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

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.