• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 165
  • Last Modified:

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

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
jupiterz
Asked:
jupiterz
1 Solution
 
jupiterzAuthor Commented:
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
 
Javin007Commented:
Just ask a moderator to remove this post.

-Javin
0
 
moduloCommented:
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now