Home Forums SQL Server 7,2000 T-SQL Different sorting behavior ADO - TSQL RE: Different sorting behavior ADO - TSQL

  • 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]