ADO - Cursor Types

[Jimbob]

I know different cursor types offer different functionality, the most annoying one beng lack of recordcount in some, but when I try to run this query: -

SELECT DISTINCT *
FROM Ticket
WHERE [AgtTNumber] IN
        (SELECT [AgtTNumber]
      FROM [Ticket] AS Tmp
      GROUP BY [AgtTNumber], [BorisBooking], 
           [BorisOpLine]
      HAVING COUNT(*) = 1 AND 
           [BorisBooking] <> [Ticket].[BorisBooking] AND 
           [BorisOpLine] <> [Ticket].[BorisOpLine]) AND 
    Reconciled = 0
ORDER BY [AgtTNumber], [BorisBooking], [BorisOpLine];

with a Keyset, I get told that 'Object or Provider is not capable of performing the requested operation' but using a Dynamic crsor it works fine

why is this???