| title | description | type | page_title | slug | tags | res_type |
|---|---|---|---|---|---|---|
Error Data source name not found |
Error Data source name not found and no default driver specified |
troubleshooting |
Error Data source name not found |
error-data-source-not-found-odbc-connection |
odbc |
kb |
| Product | Progress® Telerik® Report Server |
| Operating System | Windows |
The message 'Data source name not found and no default driver specified' appears 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.
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. The solution is to register the DSN as System DSN in ODBC Data Source Administrator, so it will be available to all users.