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

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: 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:

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.

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:

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:

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. Note Because of file dependencies, the most recent hotfix that contains the previous file may also contain additional files.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

This problem was corrected in Microsoft Host Integration Server 2000 Service Pack 2.