Hi, we have SQL Server 7.00.961 running on Windows 2000. On the client
side we use ODBC driver 3.70.09.61 and an OCX component to retrieve rows
from a table having about 600 000 rows.

All works fine if we just retrieve rows without ordering them. If we put
order by clause to the query, we get the following error message:

-2147467259 unspecified error. This error comes almost immediately after
submitting the query.

If we modify the select clause so that we retrieve only 30 rows, we can use
order by without problem :

Select column1,... from table --
this works
Select column1,... from table order by column -- this doesn't
work
Select top 30 column1,... from table order by -- this works

If we use SQL Server Query analyzer all works fine. So this problem comes
probably from odbc driver ?


I wonder if somebody has faced this same problem ?


Regards, Tomi Laamanen