Home » Infrastructure » Unix » Unix-oracle-windows-msaccess
Unix-oracle-windows-msaccess [message #249021] Tue, 03 July 2007 01:52 Go to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3211
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 #249311 is a reply to message #249044] Wed, 04 July 2007 01:18 Go to previous messageGo to next message
501360089
Messages: 4
Registered: March 2007
Junior Member
Thanks for the help. Can you pls give me full registry key?
Re: Unix-oracle-windows-msaccess [message #249340 is a reply to message #249044] Wed, 04 July 2007 02:19 Go to previous messageGo to next message
501360089
Messages: 4
Registered: March 2007
Junior Member
entry in the registry is AMERICAN_AMERICA.....
Ramesh
Re: Unix-oracle-windows-msaccess [message #249366 is a reply to message #249340] Wed, 04 July 2007 03:30 Go to previous message
ThomasG
Messages: 3211
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.
Previous Topic: UNIX- How two compare a file on a local system and remote system
Next Topic: env variable
Goto Forum:
  


Current Time: Fri Mar 29 03:36:38 CDT 2024