| Unix-oracle-windows-msaccess [message #249021] |
Tue, 03 July 2007 01:52  |
501360089
Messages: 4
Registered: March 2007
|
Junior Member |
|
|
Hi,
I've come across a problem with oracle9(later) on Unix and windowsXP msaccess database which is linked. oracle's numeric filed data is coverting to text in the msaccess.
table in oracle is as follows
SampleID NUMBER(5) not null,
SAMPLE NUMBER not null.
It has 2 fields, one is number with precision 5 and the other is NUMBER with no precision. This means it accepts float values. But there is a limitation with MSAccess that it converts number to text if the precision is greater than 15. Oracle's default precision is 38. So, in this case precision is 38.but everything is fine in the other machine with same config. Is there any other reason that causes the problem with unix-oracle and windowsXp-MsAccess combi.
Ramesh
|
|
|
|
| Re: Unix-oracle-windows-msaccess [message #249044 is a reply to message #249021] |
Tue, 03 July 2007 02:37  |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
I had a similar problem back when we upgraded from Access 97 to Access 2000.
I could fix it there by Changing the
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0\NLS_LANG
registry entry from GERMAN_GERMANY..... to AMERICAN_AMERICA.....
Have a look at the to machines, and see if they are configured different somewhere under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\
|
|
|
|
|
|
|
|
| Re: Unix-oracle-windows-msaccess [message #249366 is a reply to message #249340] |
Wed, 04 July 2007 03:30 |
ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
I can't give you the keys, because they depend you YOUR coufiguraton.
Just compare the ones on the working machine to the ones on the not working machine.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
