OK, this is my mistake.
The first query works with DBCommand().
The reason it was not working is the account running kix32 didn't have select access on the table...
My bad!

Edited by marvince (2012-05-11 09:36 PM)
Edit Reason: typo