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

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?
LVL 6
nathanielIT ConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
nathanielIT ConsultantAuthor Commented:
I'm getting this error after logging in, I'm not able to view the tables (to link to) from the database.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you login to the database using sqlplus or any other tools?
do you get any messages/warnings over there?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

nathanielIT ConsultantAuthor Commented:
yes, i can login using sqlplus and other tools.
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
nathanielIT ConsultantAuthor Commented:
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
Guy Hengel [angelIII / a3]Billing EngineerCommented:
can you verify with which driver you do actually connect?
0
nathanielIT ConsultantAuthor Commented:
Oracle ODBC Driver  Version 8.00.510.00
0
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
nathanielIT ConsultantAuthor Commented:
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
Guy Hengel [angelIII / a3]Billing EngineerCommented:
with above questions, I am trying to get the problem isolated, if it's the oracle part, or rather your current computer installation...
0
ShesALive1Commented:
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
nathanielIT ConsultantAuthor Commented:
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
nathanielIT ConsultantAuthor Commented:
I can linked with EXCEL ODBC
0
nathanielIT ConsultantAuthor Commented:
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
Computer101Commented:
PAQed with points refunded (500)

Computer101
EE Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.