ODBC drivers errro '80040e14'

Hi Sir/Madam,
I have a error from my ASP, SQL application as :
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a row
of size
8162, which is greater than the allowable maximum of 8094.
The SQL query in ASP code as:
SQL = "select * from Entry,Entrant where Entry.EntrantID=Entrant.EntrantID
and entry.Competition = 'MADC2004' order by CatID asc"
As long as I remove the 'order by CatID asc', the error gone. I don't
understand why the 'order by CatID' will cause the error. But I need to sort
the result.
Please help.....
Thank you very much
Ben LI'm guessing that the rows of your result set, since they come from two
tables, total more than 8094 bytes. Certainly you don't need to see
every column of each table, since at the least, you only need to display
EntrantID once, and if you can live with results without all the
columns, you may solve the problem. It's also possible that you really
don't ever have 8094+ bytes in any one row - this could be the case if
you have char or nchar columns where you might be fine with varchar or
nvarchar.
SK
B L wrote:

>Hi Sir/Madam,
>I have a error from my ASP, SQL application as :
>Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
>[Microsoft][ODBC SQL Server Driver][SQL Server]Cannot sort a ro
w of size
>8162, which is greater than the allowable maximum of 8094.
>The SQL query in ASP code as:
>SQL = "select * from Entry,Entrant where Entry.EntrantID=Entrant.EntrantID
>and entry.Competition = 'MADC2004' order by CatID asc"
>As long as I remove the 'order by CatID asc', the error gone. I don't
>understand why the 'order by CatID' will cause the error. But I need to sor
t
>the result.
>Please help.....
>Thank you very much
>Ben L
>
>
>
>
>
>
>|||Hi Steve,
I selected less column and the query working now. Thank you very much for
the information.
Regards
Ben
"Steve Kass" <skass@.drew.edu> wrote in message
news:%23jGFhDZBEHA.3804@.TK2MSFTNGP09.phx.gbl...
> I'm guessing that the rows of your result set, since they come from two
> tables, total more than 8094 bytes. Certainly you don't need to see
> every column of each table, since at the least, you only need to display
> EntrantID once, and if you can live with results without all the
> columns, you may solve the problem. It's also possible that you really
> don't ever have 8094+ bytes in any one row - this could be the case if
> you have char or nchar columns where you might be fine with varchar or
> nvarchar.
> SK
> B L wrote:
>
Entry.EntrantID=Entrant.EntrantID
sort
>