Solved

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

Posted on 2007-04-02
17
6,672 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
17 Comments
 
LVL 143

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 143

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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 6

Author Comment

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

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 143

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
 
LVL 143

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 143

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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

737 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