In an ASP.NET page with OLEDB Connection to DB2400 Table:


This One Works:
SELECT QTRAILER, QFDAT, Sum(QWGT) as TotWeight From TTCDD.D6BOL215...GROUP BY QTRAILER, QFDAT


This One...
SELECT QTRAILER, QFDAT, Sum(QWGT) as TotWeight From TTCDD.D6BOL215...GROUP BY QTRAILER, QFDAT

Fails With:
OleDbDataAdapter internal error: invalid rowset accessor: Ordinal=3 Status=UNSUPPORTEDCONVERSION


The QWGT field is numeric and it I attach this table to MS Access and do the same query with a Group By and Sum it works