FIX: A call to the GetLiteralInfo function may return an incorrect error message in the Microsoft Host Integration Server 2000 DB2 driver (892480)

SYMPTOMS

A call to the GetLiteralInfo function may return an incorrect error message in the Microsoft Host Integration Server 2000 DB2 driver. When SQL Server Distribution Agent cannot synchronize with the IBM DB2/MVS heterogeneous subscriber, the synchronization ends. You may receive the following error message:

Agent message code 20084. The process could not connect to Subscriber '<Subscriber Name>'. Message: Replication-Replication Distribution Subsystem: agent <Distribution Agent Name> failed. The process could not connect to Subscriber '<Subscriber Name>'.

[12/12/2004 9:16:31 PM]Distributor.distribution: {call sp_MSadd_repl_alert(3, Agent ID, Error ID, 14151, ?, -1, N'Publisher'', N'Publisher Database', N'Subscriber', N'Subscriber Database', ?)} ErrorId = Error ID, SourceTypeId = 1 ErrorCode = '' ErrorText = ''

Additionally, you may receive the following error message:

0x80040E21 (DB_E_ERRORSOCCURRED)

However, you are supposed to receive the following error message:

0x00040EDA (DB_S_ERRORSOCCURRED)

This problem occurs in Host Integration Server 2000.

CAUSE

This problem occurs when you perform SQL Server Transactional Replication to a DB2/MVS heterogeneous subscriber. You do this by using the Host Integration Server 2000 DB2 driver. SQL Server Distribution Agent makes a call to the GetLiteralInfo function to obtain information about the literals that are supported by the DB2/MVS server. Sometimes, the DB2 OLE DB driver may return an incorrect HRESULT to SQL Server Distribution Agent. This causes SQL Server Distribution Agent to prematurely end.

Note There is a small timing window where a "buffer overread" can occur in the call to the GetLiteralInfo function. This is true if one of the parameters that is passed is in the DBLITERAL_QUOTE literal.

RESOLUTION

A supported hotfix is now available from Microsoft, but it is only intended to correct the problem that is described in this article. Only apply it to systems that are experiencing this specific problem. This hotfix may receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next Host Integration Server 2000 service pack that contains this hotfix.

To resolve this problem immediately, contact Microsoft Product Support Services to obtain the hotfix. 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

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The English version of this hotfix 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.

   Date         Time   Version            Size    File name
   --------------------------------------------------------------
   22-Jan-2005  01:29  5.0.0.1022        311,568  Crtpkg.dll       
   22-Jan-2005  01:29  5.0.0.1022        700,688  Db2oledb.dll     
   22-Jan-2005  01:29  5.0.0.1022         53,552  Ddmstr.dll       
   22-Jan-2005  01:29  5.0.0.1022         78,096  Mseidb2c.dll     
   22-Jan-2005  01:29  5.0.0.1022        889,104  Mseidb2d.dll     
   22-Jan-2005  01:29  5.0.0.1022         24,848  Mseidpm.dll      
   22-Jan-2005  01:29  5.0.0.1022        270,608  Mseidrda.dll     
   22-Jan-2005  01:29  5.0.0.1022        147,728  Mseidt.dll       
   22-Jan-2005  01:29  5.0.0.1022         65,808  Crtpkg.exe       
   22-Jan-2005  01:29  5.0.0.1022         82,192  Ddmserv.exe

Note Because of file dependencies, the most recent hotfix that contains the previous files may also contain additional files.

FIX: A call to the GetLiteralInfo function may return an incorrect error message in the Microsoft Host Integration Server 2000 DB2 driver (892480)

SYMPTOMS

CAUSE

RESOLUTION

STATUS