Data base connectivity issue - kendo reporting API C#

[Gurumani]

Hi,

i am new to telerik reporting. i tried to generate reports through API libraries in C# provided by telerik. In local , I am able to build the webapplication and generate report. But when try doing same in server .I am unable to. I am getting error that "ORA-12514: TNS:listener does not currently know of service requested in connect descriptor"

 

 

 

        <add key="connectionString" value="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=XXXXXX)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=xxxx)));User Id=xxx;Password=xxx" />
        <add key ="providerName" value="Oracle.ManagedDataAccess.Client" />

 

I have put following entries "manage.config" file in both the systems

    <system.data>
      <DbProviderFactories>
      <remove invariant="Oracle.ManagedDataAccess.Client" />
      <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=xxxxxx" />
   </DbProviderFactories>
    </system.data>

 

Please find the details of local as well as server

Local-

   OS - windows10 Pro , 64 bit

Server

OS- windows server 2012 standard 64 bit

 

I take build on webapplication visual studio 2019

Target platform : .NetFramework 4.6.1, x86, ConsoleApplication

I copy the same files(which are generated in build) to server and run the exe file. 

There other java applications connecting to above database on server.

Kindly help me here.

 

 

 

 

[Todor]

Hello Gurumani,

The Telerik Reporting engine delegates all the actions related to database connection and data fetching to the ADO.NET provider specified in the SqlDataSource component. The experienced error is thrown by the provider and transferred to the user by our code. That said, the error is outside our Reporting tool and comes from the ADO.NET provider for the Oracle database.

I am not an expert in Oracle database and checked for the error message on the Internet. Here are some of the threads I found that you may find useful when tackling the problem:

• ORA-12514 TNS: listener does not currently know of service requested in connect descriptor in Stackoverflow
• How to Resolve ORA-12514: TNS: listener does not currently know of service requested in connect descriptor

Regards,
Todor
Progress Telerik