ADODB Recordset Error On Sort
- From: misterqj@xxxxxxxxx
- Date: 22 Nov 2006 14:41:30 -0800
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.
.
- Follow-Ups:
- Re: ADODB Recordset Error On Sort
- From: Cindy M .
- Re: ADODB Recordset Error On Sort
- Prev by Date: Re: Exception not caught when calling .NET DLL via (regular) ASP
- Next by Date: Strange!!! GetComInterfaceForObject behaves differently on win2k and winXP
- Previous by thread: Exception not caught when calling .NET DLL via (regular) ASP
- Next by thread: Re: ADODB Recordset Error On Sort
- Index(es):
Relevant Pages
|
