I meet the same problem as yours. My workaround is clumsy. I convert the
numeric type output to string, and then convert it back to numeric at the
client program. I don't think you are looking for such a solution, right?
BTW, with the new version of the ODBC driver, have you try selecting numeric
field that with decimal value, and found it successful?
Rgds.
Robert Clore <robert.clore_at_ci.seattle.wa.us> wrote in message
news:rkdR2.49$56.11169_at_news-west.eli.net...
> Pass though queries from Access 97 using the newer MSORCL32.DLL v
2.573.xxx
> ODBC drivers that comes in MDAC/ADO 2.x fail on queries that return long
> integers. That is when a SELECT COUNT... ,or a SELECT
sequencename.NEXTVAL
> FROM DUAL etc, returns a value greater than 32767 we get a numeric value
> out of range error. This didn't happen with MSORCL32.DLL v 2.73.xxx
>
> Is there a workaround to this problem?
>
> Thanks,
> Bob Clore
> Seattle City Light
>
>
Received on Fri Apr 30 1999 - 05:59:37 CDT
