Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2003

    Unanswered: Problems when selecting from Oracle via ODBC in Access

    Scenario: Access frontend selects from Oracle backend via ODBC

    I have a "fun" problem.... When I select from a field that contains a float, I get funny numbers.

    Even when I look at numbers in simple select query they are wrong!
    For example 345,2365 will come out as 3452365.

    If I look in SQL Plus it comes out as 345,2365

    It is defined in oracle as NUMBER(15,5).

    Is there something wrong with my ODBC link?

    Server info:
    Oracle9i Enterprise Edition Release - 64bit Production
    With the Partitioning, OLAP and Oracle Data Mining options
    JServer Release - Production

    Access 2000

    ODBC: Oracle Corporation

    There are three choices on "Numeric Settings":
    Use Oracle NLS Settings
    Use Microsoft regional settings
    Use US Settings

    I've tried all three and restarted my comp between the tries.

    Any ideas?

  2. #2
    Join Date
    Jul 2003
    The reason behind this "nice" behaviour was bad ODBC-links....

    I relinked all tables today and the problem was gone, did NOT work yesterday.

    I mailed my dba on the Oracle database but haven't got an answer yet, but I doubt that there was a problem there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts