Skip to Content

How to connect Crystal Reports to an Oracle VPD from a Visual Studio project

Oct 13, 2017 at 08:06 AM


avatar image

My application runs reports with parameters set by an Oracle Stored Procedure.
Crystal Reports need to connect to the Oracle DB using a VPD enabled connection string. The string looks like:
"metadata=res://*/DataModel.csdl|res://*/DataModel.ssdl|res://*/DataModel.msl;provider=Devart.Data.Oracle;provider connection string=\"User Id=user;Password=****;Server=Server;ClientId=CLIENT\""
I'm using CrystalDecisions.Shared.TableLogOnInfo.ConnectionInfo to set up ServerName, UserId and Password
Unfortunately I'm not able to pass an Oracle VPD specific ClientID property this way.
I tested setting ConnectionInfo.LogonProperties but it ends up with a "Failed to load database information".

What is the right way of connecting Crystal Reports to an Oracle VPD?

Environment: VS2017, CrystalDecisions.CrystalReports.Engine 13.0.19, Oracle 12c

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

0 Answers