# Oracle Data Provider

This topic demonstrates how to connect to the Oracle Data Provider in ActiveReports.

## Content

Use this sample if you want to connect to the Oracle Data Provider, which is otherwise not available since System.Data.OracleClient is deprecated.
![Screenshot 2025-05-30 140252](https://cdn.mescius.io/document-site-files/images/b298aea2-8cb8-4a0f-be88-4f54aa263ebd/Screenshot%202025-05-30%20140252.0d0ab4.png?width=650)

### Sample Location

**Visual Basic.NET**
[https://github.com/activereports/Samples20/tree/main/Advanced/PageAndRDLX/OracleDataProvider/VB.NET](https://github.com/activereports/Samples20/tree/main/Advanced/PageAndRDLX/OracleDataProvider/VB.NET)
**C#**
[https://github.com/activereports/Samples20/tree/main/Advanced/PageAndRDLX/OracleDataProvider/C#](https://github.com/activereports/Samples20/tree/main/Advanced/PageAndRDLX/OracleDataProvider/C%23)

### 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.
<br>
    **Sample Oracle Connection String**
<br>
    data source=in-data-sql/orcl.grapecity.net;user id=user1;password=password@123
<br>
    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:

```xml
<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"/>
```