New to Telerik Reporting? Download free 30-day trial

Should I use System.Data.OracleClient .NET data provider to retrieve data for reports from an Oracle database?

Environment

Product Progress® Telerik® Reporting
Report Item SqlDataSource Component

Description

System.Data.OracleClient is a Microsoft .NET data provider allowing you to connect to an Oracle database. The provider is deprecated and it should not be used - Oracle and ADO.NET.

Solution

We recommend the usage of the Oracle Data Provider for .NET/ODP.NET. More .NET data providers and how they can be used for connecting to an Oracle database can be found in the Oracle connection strings article.

You may also check out Data provider is missing in the SqlDataSource wizard.

Notes

Each .NET data provider has its own specification how to read SQL queries. If you use SQL parameters, please check the valid syntax for typing parameters in the SQL query.

In this article