Solved

ODBC call failed... Restricted data type attribute violation.

Posted on 2007-04-02
17
6,437 Views
Last Modified: 2008-03-14
I am having difficulty while trying to link tables from Oracle database. The error I'm getting is "ODBC -- call failed... Restricted data type attribute violation. Any idea?
0
Comment
Question by:nathaniel
17 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18841536
check the data types in the oracle table you want to link. probably some blob, timestamp or the like.
you will need to create an view in the oracle database to perform the data type conversion, and link to that view
0
 
LVL 6

Author Comment

by:nathaniel
ID: 18841559
I'm getting this error after logging in, I'm not able to view the tables (to link to) from the database.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18841562
can you login to the database using sqlplus or any other tools?
do you get any messages/warnings over there?
0
 
LVL 6

Author Comment

by:nathaniel
ID: 18841694
yes, i can login using sqlplus and other tools.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18841739
what version of Oracle?
what version of Access?
at what exact moment of the link table wizard do you get the error?
can you try with another login?
0
 
LVL 6

Author Comment

by:nathaniel
ID: 18841816
Oracle 8.1.7
Access 2003
error displays after log-in (it seems connecting but unsuccessful due to error message).
I tried another login but i get the same error.

0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18841855
can you verify with which driver you do actually connect?
0
 
LVL 6

Author Comment

by:nathaniel
ID: 18841925
Oracle ODBC Driver  Version 8.00.510.00
0
U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18841933
that all looks fine and dandy...
for your oracle, you said 8.1.7, I hope it is patched to at least 8.1.7.4 ? (although that should not solve this problem, but it would be exclude any other potential problems...)

do you have some other oracle database where it works?
do you have some other computer from which you could make it work?
the oracle server is remote or locally on the same box?
0
 
LVL 6

Author Comment

by:nathaniel
ID: 18841961
do you have some other oracle database where it works? have no idea, have to check.
do you have some other computer from which you could make it work? yes, in another computer. But not sure of the driver version it is using (yeah right! I should check that also)
the oracle server is remote or locally on the same box? oracle server is remote.
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 18841968
with above questions, I am trying to get the problem isolated, if it's the oracle part, or rather your current computer installation...
0
 
LVL 1

Expert Comment

by:ShesALive1
ID: 18845987
I can add a few questions to Angel's list.  <g>

How long has this been happening?  Has ODBC linking to Access ever worked?  Can you open tables you linked before?  Is there a vendor\programmer involved here who has changed anything lately? Can you IMPORT? Can you link with Excel ODBC?

In looking around the web on this error, (as much as I can with the firewall here at work)  this seems related to missing column headings and\or data types that give access (ahem) hairballs.
0
 
LVL 6

Author Comment

by:nathaniel
ID: 18848756
the ODBC driver version in another PC  that is working, is the same with what Im trying to establish a link in my new PC.

additional info:
the other PC's OS is Windows 2000
while the new PC uses Windows XP.
0
 
LVL 6

Author Comment

by:nathaniel
ID: 18881433
I can linked with EXCEL ODBC
0
 
LVL 6

Author Comment

by:nathaniel
ID: 18916140
I tried using the Microsoft ODBC for Oracle 2.575.1117.00 driver, Instead of using the said driver that I've downloaded. - It worked.  Thanks anyway.
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 21130212
PAQed with points refunded (500)

Computer101
EE Admin
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now