Re: ODBC Oracle-Access

From: Johannes Wilhelm <x15_at_aixterm8.urz.uni-heidelberg.de>
Date: 16 Jul 2001 06:21:38 GMT
Message-ID: <9iu15i$6md$1@news.urz.uni-heidelberg.de>

Andreas Jaendl <andreas.jaendl_at_weihenstephan.org> wrote:
> We have an application running on linked tables in Access 2000 and there is
> a problem in datatype mapping. Number(0,0) datatypes are mapped to text and
> other numbers with fixed length (e.g. number (10,2)) are mapped to Access
> datatype decimal (10,2), which would be correct. However we cannot update or
> insert numbers with decimal places but get Oracle error 01722 (invalid
> number). Is there a workaround to this problem or does anyone else know
> about it? We encountered it with Oracle 8.1.5 Personal edition and Oracle
> 8.1.6 enterprise edition databases.

> Thanks for any help, Andreas Jaendl

Ist in beiden Sytemen der gleiche Sprachlevel eingestellt? Sieht nämlich schwer nach Punkt/Komma-Verwechslung aus.

Johannes Wilhelm Received on Mon Jul 16 2001 - 01:21:38 CDT