Solved

Retrieving a record using ADO from a Table in Oracle. The Data Type of one of the attributes is BFILE

Posted on 2004-04-29
5
147 Views
Last Modified: 2010-05-02
I am retreiving data from a table in Oracle using VB.
One of the attributes data type is BFILE, that is what I want in the record set.

When I execute the query for my development environment it returns me a record successfully.

But when I execute that query in the same environment using another role, I get this error:

Run-time error -2147467259(80004005)
Data provider or other service returned an E_FAIL status.

any body knows what could be the possible cause of that. I have checked all grants and  permissions to the specific role and they are all there.

Thanks
0
Comment
Question by:jupiterz
5 Comments
 

Author Comment

by:jupiterz
ID: 10951827
We figured it out. Assumptions are dangerous.
We thought that we had a one of the grants in place which was in fact not there.
Setting the grant on that table for the user solved it.

How can I give points to myself?
0
 
LVL 4

Expert Comment

by:Javin007
ID: 10952906
Just ask a moderator to remove this post.

-Javin
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 11468884
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

777 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