Skip to Content

How to code VB .NET to use schema owner to retrieve and export crystal output to PDF

Aug 02, 2017 at 09:03 PM


avatar image

I have a simple report that connects to Oracle via TNS. The table that it uses is called "A". The Crystal report was created by a user name (and DB owner) "sysadm". Data cannot be retrieved by a user "user1' with password "pwd" that has read access to table via the VB.NET application. Running the application using the "sysadm" credentials the programs works. Running it with user1 credentials the application gives the error "

"Failed to retrieve data from the database." & vbLf & "Details: [Database Vendor Code: 942 ]".

User1 can query table A in a query tool only by prefixing the table with the owner: SELECT ANYCOL FROM SYSADM.A.

So I am assuming my code needs to somehow tell crystal the schema owner.

Any help is appreciated.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Don Williams
Aug 02, 2017 at 09:04 PM

Correct, CR fully supports DB security.

Try searching first before posting, lots of posts on how to use CR API's to set log on info. - SetTableLocation


10 |10000 characters needed characters left characters exceeded