ODBC connection to snowflake works in Report Designer but fails when hosted in .Net 5 web application

[Dhiraj]

Hi,

I have created a cross tab report with Snowflake ODBC as a data source and it works perfectly fine in Telerik Report Designer, when I click on preview I could see the data being fetched from my snowflake database.

I have snowflake DSN setup on my machine with name "SFDevAdmin"

But when I host it in .Net 5 as REST API and trying to render it in HTML I get connection error I think I need to specify the connection string in my asp.net application and I did it like this in my appsettings.json

 "connectionStrings": {
    "SFODBC": "Data Source=SFDevAdmin"
  }

but I am getting below error 

Could you please help me on this to make odbc connection work when hosted in asp.net 5 application 

[Dimitar]

Hello Dhiraj,

That is correct, unless you embed the connection string in the report during the SqlDataSource configuration, the connection string must also be specified in the project where the reporting service will be hosted.

Note that the way you have set up the connection string, it will use System.Data.SqlClient as data provider invariant name. In order to explicitly specify the data provider, you may define the connection string like this:

    "Telerik.Reporting.Examples.CSharp.Properties.Settings.TelerikConnectionString": {
      "connectionString": "Data Source=(local)\\SQLEXPRESS;Initial Catalog=AdventureWorks;Integrated Security=SSPI",
      "providerName": "System.Data.SqlClient"
    }

Also, in order to use the snowflake data provider, you must extend the list of the supported ADO.NET data providers in .NET Core registering a new DbProviderFactory instance through the Telerik.Reporting.Processing.Data.DbProviderFactories class.

For more information, please see the How to register a DbProviderFactory in a .NET Core project KB article.

If you would need further assistance, please attach a trace listener to the project and send us the generated trace log - Troubleshooting reporting implementation into ASP.NET Core application.

Thank you for trying Telerik Reporting!

Regards, 
Dimitar
Progress Telerik