A Syntax Error Has Occurred

Error Number  = 350

Error Message = Native SQL Error Code

Error Details = iSQL ALIAS="prod" DBNAME="[ removed ]" LOGIN="[ removed ]" INDEXED="true" ESC="false" SQL="
					SELECT DISTINCT p.id,
						   p.name AS name,
						   p.sell AS price,
						   p.picture,
						   p.field1 AS dimensions,
						   p.field3 AS brand,
						   p.field5 AS recommended,
						   p.imnew,
						   p.special,
						   p.stock,
						   c.id AS subcatid,
						   c.name AS subcategory,
						   c.description AS subcatdesc
					FROM products p, category c, catlink cl
					WHERE p.active=1 AND cl.prodid=p.id AND c.id=cl.catid AND c.active=1  AND
						c.storeid=1 AND p.storeid=1 AND cl.storeid=1 
					ORDER BY c.name, p.name"

SQL Error:      [Microsoft][ODBC SQL Server Driver][SQL Server]The text data type cannot be selected as DISTINCT because it is not comparable.
[Microsoft][ODBC SQL Server Driver][SQL Server]The cursor was not declared.

 @ Error Executing Statement

SQL Statement:  SELECT cvalue FROM config WHERE cname='DBMODE' AND storeid=1