[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2007-04-02
17
Medium Priority
?
7,256 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
16 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
Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

 
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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

872 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