count distinct not working

[Thomas Bock]

I receive an error 15 with

Code Select Expand


select count(distinct columnName) from table

msg(-1)=37000: [PxPlus][SQL ODBC Driver]Expected lexical element not found: <identifier>

How can I count distinct column values using ODBC 7.0.3?