User Name Password Register
DaniWeb IT Discussion Community
All
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 374,445 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,795 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 12464 | Replies: 3
Reply
Join Date: Aug 2004
Posts: 11
Reputation: zaman1111 is an unknown quantity at this point 
Rep Power: 4
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)

 

DaniWeb Oracle Marketplace
Thread Tools Display Modes

Similar Threads
Other Threads in the Oracle Forum

All times are GMT -4. The time now is 12:31 pm.
Forum system based on vBulletin Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
©2003 - 2008 DaniWeb® LLC