Hi Patrick,
maybe a quick-shot, but ORDER BY is executed on the server and ADO sort property requires a client-side cursor. Is there a different setting?
BTW, since VB 6 is quite a while out, maybe it's appropriate to apply SP6.
Cheers,
Frank
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]