Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODBC Decimal problem

411285Dec 16 2003 — edited Jan 5 2004
Since we use a new application (in Oracle8) to which I a get connected with MS Access 2000, trough an Oracle 8 ODBC driver, I do have a problem with numeric fields of the type decimal. I get an error message: "The decimal field's precision is too small to accept the numeric you attempted to add". As you may know you cannot influence the format of a linked table. When we used a driver Microsoft ODBC for Oracle, we did not have this problem, but that driver is not used for the new application.

How can I solve this problem?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 2 2004
Added on Dec 16 2003
2 comments
650 views