FIX: You may receive error messages when you try to filter an ADO recordset that has an AS/400 keyed physical file in Host Integration Server 2000 and in Host Integration Server 2000 Service Pack 1 (887191)

SYMPTOMS

You may receive error messages when you try to filter a Microsoft ActiveX Data Objects (ADO) recordset that has an AS/400 keyed physical file in Microsoft Host Integration Server 2000 and in Host Integration Server 2000 Service Pack 1.

When you use Host Integration Server 2000 OLE DB Provider to try to filter an ADO recordset that has an AS/400 keyed physical file with multiple keys in the index, you may receive the following error message:

"Host Not Responding" error (-2147467259)

When you use Host Integration Server 2000 OLE DB Provider to try to filter an ADO recordset that has a different AS/400 keyed physical file that only has one key in the index, you may receive the following error message:

Unspecified Error

CAUSE

This problem may occur for the following reasons:

Multiple key columns are not supported when you use Host Integration Server 2000 OLE DB Provider.
There is no supported syntax for this functionality in an ADO recordset. The Recordset.Find method can only be used with one column at a time or the Recordset.Find method returns an ADO error.

Although this functionality is not supported in Host Integration Server 2000 OLE DB Provider, the validation check condition is incorrect and no error is reported. This leads to a condition where Host Integration Server 2000 OLE DB Provider tries to convert and to compare a numeric column, column ordinal 2, with a string value that is the value that is used in the find.

RESOLUTION

To resolve the multiple key column problem, you must create a logical file over your physical file. The logical file must have an index that only has one key.

To create the logical file over your physical file, run the following command on an AS/400:

CREATE INDEX LIBRARY/idx01 ON LIBRARY/KEYEDPHYSICALFILE (COLUMNTOINDEX)

You can install the hotfix that is mentioned in this section. This hotfix makes sure that you do not receive the following error message:

Unspecified Error

Service pack information

To resolve this problem, obtain the latest service pack for Microsoft Host Integration Server 2000. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

328152 How to obtain the latest service pack for Host Integration Server 2000

Hotfix information

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
   --------------------------------------------------------------
   09-Dec-2004  00:51  5.0.0.1014        368,912  Snaoledb.dll