Re: Acc20: Write-conflict on records in newly created Oracle-Tables

In <4v13ru$5h1_at_izb.izb.de> snie_at_izb.de (Stefan Niemeyer) writes:
>ms_at_dream.hb.north.de (Martin Schroeder) wrote:
 

>>...
>>We create a new table like another, add the keys, copy the data from the
>>source table -- and when I then attach this table with MS-Access, I get
>>a write-conflict-warning from MS-Access on _some_ records in the table
>>(but not all!). :-(
 

>It would be helpful to know what kind of error message you get.
 

>Anyway, make sure that you use the Oracle ODBC driver 1.11.002 or any
>newer version if there exists one. The old 1.10.xxx made some
>problems. I guess the problem is a NUMBER field in your Oracle table.
>Define your number fields just as big as you need them, e.g.
>NUMBER(10,3). I'm not sure if the ODBC driver 1.11.002 still have this
>problem but the old one definitly had them. This error only happened
>with some records because the numbers need to get converted to binary
>and back to decimal and some numbers "suddenly" have digits far behind
>the decimal point where Oracle still handles them an Access doesn't.
>So these numbers seem to be "different" and cause some trouble.

That seems to be the problem :-(

We installed the newest ODBC driver and the problem persists. :-( All floating point fields are defined as float(126) with Oracle and Access sees them as Double.

If I set the value of these fields from some float to -1, everything works fine. %-(( [independent of the driver version]

We are currently thinking of changing the definition with Oracle to something like number(10,6) [10 pre- and 6 post-dot] in the hope that this will solve our problems.

I was quite surprised to learn that Oracle stores floats as BCDs---I expect _floats_ to be IEEE-compatible and not some vendor specific format---and that seems to be the cause of these ODBC-problems. I'm searching information about the internal format of Oracle-floats... :-)

What do the experts suggest?

Thanks in advance

        Martin

-- 
               Martin Schr"oder, MS_at_Dream.HB.North.DE
Governments of the Industrial World, [...]
Cyberspace consists of transactions, relationships, and thought
itself, arrayed like a standing wave in the web of our communications.
Ours is a world that is both everywhere and nowhere, but it is not
where bodies live.
	(John Perry Barlow: A Cyberspace Independence Declaration)