Hi,
Try the following:
String sql = "SELECT StockID,Config.ConfigID,ProductName,Features,Price,sum(Quantity) from Stock,Config where Stock.ConfigID=Config.ConfigID group by StockID,productname,Price,Features,Config.ConfigID having (sum(quantity) > 0) order by ProductName";
I modified the bracket surrounding the sum expression.
String sql = "SELECT StockID,Config.ConfigID,ProductName,Features,Price,sum(CONVERT(INT, Quantity)) from Stock,Config where Stock.ConfigID=Config.ConfigID group by StockID,productname,Price,Features,Config.ConfigID having (sum(CONVERT(INT,quantity)) > 0) order by ProductName"
Hope it helps.