Conversion of decimal in Oracle to Access 2000


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Conversion of decimal in Oracle to Access 2000

  1. #1
    Villy Olsson Guest

    Conversion of decimal in Oracle to Access 2000

    Hello,

    I have some tables linked in Access 2000 to an Oracle 8i database. These
    tables have some decimal fields.
    When I looked at the tables with Sql+ the decimal fields have a comma as the
    decimal separator, but in Access 2000 these fields have no decimal. 1,2 is
    shown as 12.
    If I use Access 97 I get the decimal, but the decimal fields are reurned as
    string.
    I think that I have the latest ODBC-driver from Oracle.

    Can somebody help me with a solution.?

    Villy Olsson,
    Denmark



  2. #2
    Stefano G. Guest

    Re: Conversion of decimal in Oracle to Access 2000


    "Villy Olsson" <villy.olsson@get2net.dk> wrote:
    >Hello,
    >
    >I have some tables linked in Access 2000 to an Oracle 8i database. These
    >tables have some decimal fields.
    >When I looked at the tables with Sql+ the decimal fields have a comma as

    the
    >decimal separator, but in Access 2000 these fields have no decimal. 1,2

    is
    >shown as 12.
    >If I use Access 97 I get the decimal, but the decimal fields are reurned

    as
    >string.
    >I think that I have the latest ODBC-driver from Oracle.
    >
    >Can somebody help me with a solution.?
    >


    I exactly the same problem . If you recevie the solution can you repost
    me too,please? (sguardigli@tomware.it)
    Thank you however

    >Villy Olsson,
    >Denmark
    >
    >



  3. #3
    dnagel Guest

    Re: Conversion of decimal in Oracle to Access 2000

    In the past I have turned to using the MS ODC driver. One reason
    is that Oracles is a little tighter with seciurity, and if Person A created
    and MDB and query with a DB link from Oracle, then Person B was not
    able to put in their username and password. They had to know the
    password of Person A. While the MS ODBC Driver will allow you to
    change the Username as well as the password.

    Maybe the MS driver will be more intelligent about the decimal type...

    Just a guess, but worth a try.

    D.

    "Stefano G." <sguardigli@tomware.it> wrote in message news:3ca47304@10.1.10.29...
    |
    | "Villy Olsson" <villy.olsson@get2net.dk> wrote:
    | >Hello,
    | >
    | >I have some tables linked in Access 2000 to an Oracle 8i database. These
    | >tables have some decimal fields.
    | >When I looked at the tables with Sql+ the decimal fields have a comma as
    | the
    | >decimal separator, but in Access 2000 these fields have no decimal. 1,2
    | is
    | >shown as 12.
    | >If I use Access 97 I get the decimal, but the decimal fields are reurned
    | as
    | >string.
    | >I think that I have the latest ODBC-driver from Oracle.
    | >
    | >Can somebody help me with a solution.?
    | >
    |
    | I exactly the same problem . If you recevie the solution can you repost
    | me too,please? (sguardigli@tomware.it)
    | Thank you however
    |
    | >Villy Olsson,
    | >Denmark
    | >
    | >
    |



  4. #4
    Villy Olsson Guest

    Re: Conversion of decimal in Oracle to Access 2000

    I will give a try. Thanks

    Villy


    "dnagel" <GrandNagel@hotmail.com> skrev i en meddelelse
    news:3ca49915@10.1.10.29...
    > In the past I have turned to using the MS ODC driver. One reason
    > is that Oracles is a little tighter with seciurity, and if Person A

    created
    > and MDB and query with a DB link from Oracle, then Person B was not
    > able to put in their username and password. They had to know the
    > password of Person A. While the MS ODBC Driver will allow you to
    > change the Username as well as the password.
    >
    > Maybe the MS driver will be more intelligent about the decimal type...
    >
    > Just a guess, but worth a try.
    >
    > D.
    >
    > "Stefano G." <sguardigli@tomware.it> wrote in message

    news:3ca47304@10.1.10.29...
    > |
    > | "Villy Olsson" <villy.olsson@get2net.dk> wrote:
    > | >Hello,
    > | >
    > | >I have some tables linked in Access 2000 to an Oracle 8i database.

    These
    > | >tables have some decimal fields.
    > | >When I looked at the tables with Sql+ the decimal fields have a comma

    as
    > | the
    > | >decimal separator, but in Access 2000 these fields have no decimal. 1,2
    > | is
    > | >shown as 12.
    > | >If I use Access 97 I get the decimal, but the decimal fields are

    reurned
    > | as
    > | >string.
    > | >I think that I have the latest ODBC-driver from Oracle.
    > | >
    > | >Can somebody help me with a solution.?
    > | >
    > |
    > | I exactly the same problem . If you recevie the solution can you repost
    > | me too,please? (sguardigli@tomware.it)
    > | Thank you however
    > |
    > | >Villy Olsson,
    > | >Denmark
    > | >
    > | >
    > |
    >
    >




  5. #5
    Villy Olsson Guest

    Re: Conversion of decimal in Oracle to Access 2000

    Hi,

    I have tried it now and it works. Yhanks

    Villy

    "dnagel" <GrandNagel@hotmail.com> skrev i en meddelelse
    news:3ca49915@10.1.10.29...
    > In the past I have turned to using the MS ODC driver. One reason
    > is that Oracles is a little tighter with seciurity, and if Person A

    created
    > and MDB and query with a DB link from Oracle, then Person B was not
    > able to put in their username and password. They had to know the
    > password of Person A. While the MS ODBC Driver will allow you to
    > change the Username as well as the password.
    >
    > Maybe the MS driver will be more intelligent about the decimal type...
    >
    > Just a guess, but worth a try.
    >
    > D.
    >
    > "Stefano G." <sguardigli@tomware.it> wrote in message

    news:3ca47304@10.1.10.29...
    > |
    > | "Villy Olsson" <villy.olsson@get2net.dk> wrote:
    > | >Hello,
    > | >
    > | >I have some tables linked in Access 2000 to an Oracle 8i database.

    These
    > | >tables have some decimal fields.
    > | >When I looked at the tables with Sql+ the decimal fields have a comma

    as
    > | the
    > | >decimal separator, but in Access 2000 these fields have no decimal. 1,2
    > | is
    > | >shown as 12.
    > | >If I use Access 97 I get the decimal, but the decimal fields are

    reurned
    > | as
    > | >string.
    > | >I think that I have the latest ODBC-driver from Oracle.
    > | >
    > | >Can somebody help me with a solution.?
    > | >
    > |
    > | I exactly the same problem . If you recevie the solution can you repost
    > | me too,please? (sguardigli@tomware.it)
    > | Thank you however
    > |
    > | >Villy Olsson,
    > | >Denmark
    > | >
    > | >
    > |
    >
    >




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center