Hi,

I'm using:
- Oracle 9.2.0.1.0 on Linux
- Microsoft ODBC for Oracle 2.573.9030.00
- Application using ADO 6.0

I have an application which runs a query against
this database through ODBC. The query does a two
table join, a simple group by and a sum on a
NUMBER(10,2) field.

When run through ODBC the numbers returned to the app. are
wrong by a factor of 40. When I run the same
query against Oracle directly, the results are fine.

If I remove all indexes from the table being queried,
the results are correct when the query in my app. is
run through ODBC.

I know the MS ODBC driver isn't recommended with 9i, but
we don't do anything Oracle specific or anything which
is in the known 'bug' list. All other functionality works
perfectly.

Has anybody ever seen anything like this?

Thanks.