I am working on an application that integrates with another app that
exposes its database thru ADODB. I can get a recordset without any
trouble, but I get a strange error when I call db.sort = "field".

The error is:

An unhandled exception of type
'System.Runtime.InteropServices.COMException' occurred in dbtest.exe

Additional information: Relate, Compute By, and Sort operations cannot
be performed on column(s) whose defined size is unknown or too large.

I have googled, and checked out MSDN to no avail. The only additional
info I have is that the field I am trying to sort by is defined as
LongVarChar. Is it not possible to sort by this field type? Is there
any way around this problem?

Thanks for your insight.