Article ID: 911174 - Last Review: December 4, 2007 - Revision: 1.2

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.

Back to the top

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:

http://support.microsoft.com/contactus/?ws=support (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.

Collapse this tableExpand this table

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:

http://support.microsoft.com/contactus/?ws=support (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

Collapse this tableExpand this table

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

Collapse this tableExpand this table

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.

Back to the top