Skip to Content
Former Member
Oct 13, 2017 at 08:11 AM

How to connect Crystal Reports to an Oracle VPD from within a VS 2017 project

122 Views Last edit Oct 13, 2017 at 10:14 PM 2 rev

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