I am using the telerik report designer to build my reports and html report viewer to display them.
When I use MySql.Data.MyqlClient with a standard connection string (server, uid etc) everything works fine.
When I use a ODBC dsn connection however, the connection works on the report builder but on the report viewer it says the following:
An error has occurred while processing Table 'table2':Unable to establish a connection to the database. Please verify that your connection string is valid. In case you use a named connection string from the application configuration file, make sure the name is correct and the connection string settings are present in the configuration file of your application.------------- InnerException -------------Keyword not supported: 'dsn'
I do have System.Data.Odbc installed as this is what I used for my db connections and this is also what the report builder uses.
Telerik Reporting v16.2
.Net core 6 (long term support)