Re: Access97 Pass-Thru Query giving Numeric Value out of range(#0)
From: Billy Yao [MSFT] (v-binyao_at_online.microsoft.com)
Date: 04/13/04
- Next message: Graham Feeley: "Re: Summary Question in a Query"
- Previous message: Chris2: "Re: Find all references to a query in it's MS Access DB"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Access97 Pass-Thru Query giving Numeric Value out of range(#0)"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 13 Apr 2004 05:55:06 GMT
Hi CLM,
>From your description, I understand that the pass-thru SELECT query to oracle tables failed with the
following error message:
"ODBC - call failed" followed by:
[Microsoft][ODBC Driver for Oracle]Error in column #: Numeric value out of range.
Based on my experience, this is mapping error occurring due to the Oracle data type for the specified
column. The reason of this problem may be the ODBC driver issue or the data type of the column(s) in the
back-end Oracle database.
==================================
To isolate the problem, please check the following information:
1) Check the version of file msorcl32.dll (ODBC Driver for Oracle)
In the Oracle ODBC driver version 2.5, the values precision and scale are set to zero in such cases
according to the ODBC specifications. Hence, some applications that depend on these values usually bind
the columns in the result set to the lowest possible data type (Integer) for numeric data types. When the
values go out of range for these data columns, the Oracle driver throws the error message.
To resolve this issue, it is recommended that you upgrade your MDAC to 2.7 SP1 Refresh/ latest MDAC 2.8
version via the following link:
http://msdn.microsoft.com/data/downloads/updates/default.aspx#MDACDownloads
2) Check if the data type of the column(s) is changed on the Oracle Server.
If possible, set precision and scale on Oracle's NUMBER data type. For example: NUMBER(10,3).
3) Another possibility is that some data in the pass-thru query are resulting in numeric values that are larger
than what the driver or Access can handle.
In this case, we can try to modify the SQL statements such that they return commonly used data types. For
example: Select TO_CHAR(test_seq.NEXTVAL) from SYS.DUAL
For more information, you can refer to the following KB article:
199293 PRB: Numeric Value Out of Range Error with MS Oracle ODBC Driver Version
http://support.microsoft.com/?id=199293
====================================
CLM, lease apply my suggestions above and let me know if this helps resolve your problem. If the problem
persists after you tried all, please let us know your Access version and Jet40.dll file version. In this way, we
can have a chance to reproduce your problem for futuer analysis.
I'm looking forward to hearing from you.
Best regards,
Billy Yao
Microsoft Online Support
----------------------------------------------------
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.
- Next message: Graham Feeley: "Re: Summary Question in a Query"
- Previous message: Chris2: "Re: Find all references to a query in it's MS Access DB"
- In reply to: anonymous_at_discussions.microsoft.com: "Re: Access97 Pass-Thru Query giving Numeric Value out of range(#0)"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
