Solved

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

Posted on 2007-04-02
17
6,367 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

706 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

16 Experts available now in Live!

Get 1:1 Help Now