Re: ODBC-Problems

"MensSana" <awellmer_at_gmx.de> wrote in message news:<bp2dom$j94$00$1_at_news.t-online.com>...
> I'm trying to read data from oracle 9.2 into access 2000 using Oracle's
> latest odbc driver. As soon as a column with decimal numbers is involved,
> the driver has severe problems. An error pop up says (translated from
> german): "The precision of a decimal field is too low to add the number".
> Obviously the driver tried to convert the number format from oracle into a
> decimal format in access.
> I'm forced to make this run on my computer without changing the data model.

If you look at the DSN configuration, there are going to be a few options for how to treat decimal numbers (i.e. use NLS settings, Oracle settings, etc). I would first try fiddling with that parameter to see if it solves the problem.

Justin Received on Sat Nov 15 2003 - 21:58:16 CST