'Query execution failed for dataset. (rsErrorExecutingCommand)' problem

Mengjie1024 0 Reputation points
2023-12-04T09:15:14.2633333+00:00

The report page shows 'Query execution failed for dataset. (rsErrorExecutingCommand)' when I add Chinese character values into this dataset and deploy it on Project Online,

does anyone know which kind of this problem could it be

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
3,054 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Greg Low 1,980 Reputation points Microsoft Regional Director
    2024-02-09T11:42:29.65+00:00

    Keep in mind that SSRS parses your SQL and sends to the database what it thinks you meant, rather than what you actually asked for. It only rewrites the commands because it knows it's SQL Server that it's talking to. What I'd do as a first test, is try to see if it works if you change the connection type to OLEDB as a generic data source, instead of the SQL Server data source. See if that works.

    1 person found this answer helpful.
    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.