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.
'Query execution failed for dataset. (rsErrorExecutingCommand)' problem
Mengjie1024
0
Reputation points
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
1 answer
Sort by: Most helpful
-
Greg Low 1,980 Reputation points Microsoft Regional Director
2024-02-09T11:42:29.65+00:00