Search code examples
reporting-servicesodbcdatasource

SSRS: Dataset error with odbc datasource

I am trying to create a dataset using a shared datasource. My datasource is a ODBC connection to Impala.

When I add the datasource in SQL Server Reporting Builder, the connection is successful. But when I try to add a dataset with this connexion, I get this error:

ERROR [IM002] [Microsoft][ODBC Driver Manager] The name of the data source is not found and no default driver was specified

This error only happens in remote mode.

Thanks in advance.

Solution

  • The ODBC connection has to exist on the PC client that is using Report Builder. Thanks Jesse