Use this sample if you want to connect to the Oracle Data Provider, which is otherwise not available since System.Data.OracleClient is deprecated.

Sample Location

Visual Basic.NET

https://github.com/activereports/Samples18/tree/main/Advanced/PageAndRDLX/OracleDataProvider/VB.NET

C#

https://github.com/activereports/Samples18/tree/main/Advanced/PageAndRDLX/OracleDataProvider/C#

Details

When you run this sample, a blank DesignerForm for RDLX report is displayed. Connect to the Oracle data provider as follows:

1. Add a data source.
2. In the Report Data Source dialog, select Type as  Oracle Managed Data Access.
3. Enter the connection string.

   Sample Oracle Connection String

   data source=in-data-sql/orcl.grapecity.net;user id=user1;password=password@123
   
   Now, proceed the report designing by pulling the data from Oracle data provider.

The sample consists of following:

TestDesignerPro.csproj: This is the default start up project.

ActiveReports.config: Located inside the startup project, it is a configuration file that contains the settings for using the oracle data provider:

• DisplayName to reference data provider and Type to use the oracle custom data provider as mandatory fields
• AdapterType implemented in 'OracleConnectionAdapter' class and SchemaProviderType implemented in 'GeneralOracleSchemaProvider' class for additional features.

OracleConnectionAdapter.cs: This class provides features related to parameters such as handling multi-value paramaters and parameterized queries.

GeneralOracleSchemaProvider.cs: This class generates DataSchema to enable visual query designer support.