Oracle Data Provider

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/Samples19/tree/main/Advanced/PageAndRDLX/OracleDataProvider/VB.NET

C#

https://github.com/activereports/Samples19/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 Provider.

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 with the report design by pulling the data from Oracle data provider.

The sample consists of the 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. A sample ActiveReports.config content to configure the Oracle extension is as follows:

<Extension Name="ORACLE" 

      DisplayName="Oracle Managed Data Access" 

      Type = "Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess"

      AdapterType = "GrapeCity.ActiveReports.ReportsCore.Data.CommonDbConnectionAdapter, MESCIUS.ActiveReports"

      SchemaProviderType = "GrapeCity.ActiveReports.ReportsCore.Data.DataProviders.OracleSchemaProvider, MESCIUS.ActiveReports"

      QueryDesignerSupported = "true"/>