How to give oracle client - connection for telerik report

4 posts, 0 answers
  1. Murugesan Jambukesan
    Murugesan Jambukesan avatar
    12 posts
    Member since:
    Sep 2009

    Posted 14 Sep 2015 Link to this post

    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 .

  2. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 14 Sep 2015 Link to this post

    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

  3. Murugesan Jambukesan
    Murugesan Jambukesan avatar
    12 posts
    Member since:
    Sep 2009

    Posted 14 Sep 2015 in reply to Stef Link to this post

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

     

  4. Stef
    Admin
    Stef avatar
    3036 posts

    Posted 16 Sep 2015 Link to this post

    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
Back to Top