This is a migrated thread and some comments may be shown as answers.

How to give oracle client - connection for telerik report

3 Answers 152 Views
Sharepoint Integration
This is a migrated thread and some comments may be shown as answers.
Ravi
Top achievements
Rank 1
Ravi asked on 14 Sep 2015, 09:35 AM

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 .

3 Answers, 1 is accepted

Sort by
0
Stef
Telerik team
answered on 14 Sep 2015, 11:50 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Ravi
Top achievements
Rank 1
answered on 14 Sep 2015, 02:27 PM

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()

 

0
Stef
Telerik team
answered on 16 Sep 2015, 10:49 AM
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
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Tags
Sharepoint Integration
Asked by
Ravi
Top achievements
Rank 1
Answers by
Stef
Telerik team
Ravi
Top achievements
Rank 1
Share this question
or