[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

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

Posted on 2007-04-02
17
Medium Priority
?
7,103 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

650 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