FIX: Error Setting Sort to Char Field Greater than 255 (189837)
The information in this article applies to:
- ActiveX Data Objects (ADO) 2.0
This article was previously published under Q189837 SYMPTOMS
When you use an ADO recordset object, you cannot Sort on a field with more
than 255 characters. Attempting to sort on a field with more that 255 characters results in the following error:
Run-time error '-2147217824 (80040e60)': The requested order could not be opened
You also see this error on attempting to sort on a SQL Server Text field, a Microsoft Access Memo field, or other Binary Large Object (BLOB) field.
With ADO 2.1 Service Pack 2 and later, this error does not occur on attempting to sort on a field with more than 255 characters. However, this error does occur on attempting to sort on a Binary Large Object (BLOB) field.
STATUS
This problem has been fixed in MDAC version 2.1 and later.
Modification Type: | Minor | Last Reviewed: | 3/2/2005 |
---|
Keywords: | kbbug kbDSupport kbMDACNoSweep KB189837 |
---|
|