How to give oracle client - connection for telerik report

[Ravi]

We are getting the following error -

 A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or
was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
------------- InnerException -------------
The network path was not found

when we use the codes as in the attachment . please help us how to give oracle-client connection String in vb for telerik report (trdx) file .

[Stef]

Hello Murugesan,

If you need to configure a SqlDataSource in a report, please check the attached video. On deploying the TRDX file you will have to copy the connection string by name in the application's configuration file. More details how to handle connection strings on configuring the SqlDatasource component, please check SQL Data Source Wizard

If you need to change the connection string at run-time, you can test an approach similar to this in Changing the connection string dynamically according to runtime data.

Regards,
Stef
Telerik

[Ravi]

we are using oracle Data source. we use connection string by using username and password like this   DATA SOURCE=xxx;PASSWORD=xxx;USER ID=xxx . Still we have a problem to connect Oracle Data Source.

  Dim sqlDataSource As Telerik.Reporting.SqlDataSource = New Telerik.Reporting.SqlDataSource

        Dim connectionString = "DATA SOURCE=xxx;PASSWORD=xxx;USER ID=xxx"
        Dim connectionStringHandler = New ReportConnectionStringManager(connectionString)
        Dim sourceReportSource = New UriReportSource() With { _
             .Uri = "​SampleReport.trdx" _
        }

        Dim reportSource = connectionStringHandler.UpdateReportSource(sourceReportSource)
        rvERA.ReportSource = reportSource
        rvERA.RefreshReport()

 

[Stef]

Hi Murugesan,

Please check what connection string is saved in the modified report instance by serializing it in XML. Verify all required SqlDataSource properties are set correctly (ConnectionString, ProviderName and etc.).

If you need further help, please open a support ticket and send us a demo project that illustrates the settings in your project.

Regards,
Stef
Telerik