Re: Compatbility of Microsoft Access 97 with Oracle 8

From: Matthias Smit <magicmat_at_nikocity.de>
Date: 2000/07/27
Message-ID: <397ff117$0$21547@businessnews.de.uu.net>#1/1

That's right and the only solution for your problem is to convert the Access 97 into an Access 2000 Database.

The second Problem is our problem too. When we use an ORACLE ODBC Driver
8.0.4 the convert datatype is correct.but we have an very bad paerformance
(unacceptable). The newest Driver 8.0.6.1 has not a performance problem, but

now our Long Interger are only convert as Decimal 10,0. Thats a oracle specification for an long intger but the odbc driver should convert it into long onteger.

<rgbautista_at_hotmail.com> schrieb in im Newsbeitrag: 8lm1h0$bn$1_at_nnrp1.deja.com...
> I have read somwhere that the Oracle Migration Assistant for Microsoft
> Access is incompatible with Microsoft Access 97 databases. I always
> encounter an error: A serious internal error has occured 440 whenever
> migration begins.
>
> Another thing is whenever I exported a Microsoft Access 97 table that
> contains number fields (single or double precision) though the Oracle
> ODBC, Oracle always converts these fields to VARCHAR. I tried changing
> them manually through the Schema Manager but the program does allow me
> to because it contains data.
>
> Can anyone verify this? Is there a simple solution to this?
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Jul 27 2000 - 00:00:00 CDT