Error 'Data source name not found' when using ODBC connection with Telerik Report Server.
Environment
| Product | Progress® Telerik® Reporting, Report Server |
| Report Designer | Standalone Report Designer |
| Report Item | SqlDataSource |
Description
The error ppears when Standalone Report Designer tries to open an ODBC connection, registered in Telerik Report Server, although the connection string is valid and ODBC DSN is registered as User DSN.
Error Message
'Data source name not found and no default driver specified.'
Possible Cause
When a DSN is registered as User DSN, this means that only the currently logged-in user can access it.
The Report Server pool uses LocalSystem built-in account by default, so it probably is unable to access the registered User DSN.
Solution
The solution is to register the DSN as System DSN in ODBC Data Source Administrator, so it will be available to all users.