RSS Forums RSS
Please support our Oracle advertiser: Programming Forums
Views: 14097 | Replies: 3
Reply
Join Date: Aug 2004
Posts: 11
Reputation: zaman1111 is an unknown quantity at this point 
Rep Power: 5
Solved Threads: 0
zaman1111 zaman1111 is offline Offline
Newbie Poster

Accessing Oracle 10g table with MS access 2003

  #1  
Jun 9th, 2005
We were successful on linking the table from MS access to Oracle 10g, but we dont see any data in the MS access linked table. It shows as data #deleted. Can you please describe how we can see those datas.
AddThis Social Bookmark Button
Reply With Quote  
Join Date: Jul 2005
Posts: 1
Reputation: dbugme is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
dbugme dbugme is offline Offline
Newbie Poster

Re: Accessing Oracle 10g table with MS access 2003

  #2  
Jul 29th, 2005
Was there any answer to this. I'm having the same problem. Using AccessXP, I can link to Oracle Tables via Oracle 10g ODBC Driver. But when I open the table all values in fields are displayed as "#deleted". The weird thing is if I connect to the same table using MSQRY32.exe everthing displays correctly.
Reply With Quote  
Join Date: Aug 2005
Posts: 5
Reputation: weilander is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
weilander weilander is offline Offline
Newbie Poster

Re: Accessing Oracle 10g table with MS access 2003

  #3  
Aug 1st, 2005
I have the same kind of problem.

The error message: The decimal field's precision is too small to accept the numeric you attempted to add.

The oracle-field is: NUMBER(6,3)
In Access the field is: Decimal (6,3).

Can someone tell me how to solve this problem?
Reply With Quote  
Join Date: Aug 2005
Posts: 5
Reputation: weilander is an unknown quantity at this point 
Rep Power: 0
Solved Threads: 0
weilander weilander is offline Offline
Newbie Poster

Re: Accessing Oracle 10g table with MS access 2003

  #4  
Aug 2nd, 2005
To fix this, go to registry,

change all "HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEx\NLS_LANG to "AMERICAN_AMERICA.WE8ISO8859P1".
Reply With Quote  
Reply

Only community members can participate in forum threads. You must register or log in to contribute.

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

 

Thread Tools Display Modes
Forums | Blogs | Tutorials | Code Snippets | Whitepapers | RSS Feeds | Advertising
All times are GMT -4. The time now is 10:41 am.
Newsletter Archive - Sitemap - Privacy Statement - Acceptable Use Policy - Contact Us
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC