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.