Re: Problems with ODBC driver Oracle to Access

From: Tim Romano <tim_at_superstream.net>
Date: Wed, 27 May 1998 23:02:21 -0400
Message-ID: <6kikas$b2t5_at_helium.superstream.net>


Sjef,
I get the same problem under NT. Workaround: enlarge the Oracle column to number(6) and enforce maximum of 99999 with a check constraint if necessary. Access/ODBC treats number(6) as long integer. Tim

News Slustig wrote in message <6ke1ks$qhh4_at_reader2.wxs.nl>...
>Hello,
>
>I have problems with the ODBC driver in NT4.0. Win95 works all right.
>
>The problem is that a oracle 5 number field in Access inported an interger
>field is.
>A 5 digit number field can store more than an integer so i get an error
>messages and the hole table can't be inported.
>
>In Win95 there is no problem, the field is converted to a long integer in
>Access.
>
>Who can help me????
>
>Sjef Lustig (Holland)
>
>
Received on Thu May 28 1998 - 05:02:21 CEST

Original text of this message