“ODBC: ERROR RIM002] ]Microsoft]tODBC Driver Manager] Data source name not found and no default driver specified” error means that the Data Source Name (DSN) specified in the connection configuration is not being found in the Windows registry.
One reason could be due to the Data Source Name created as a User DSN instead of System DSN. We have seen many users before getting this error when connecting with a User DSN. Lack of necessary permissions of the User might cause issues with accessing DSNs, especially if the user does not have permission to access the specific parts of the Registry where DSNs are stored. Make sure you are using a System DSN.
Another reason for this error is due to the usage of the Workspace server instead of the Integrated workspace. If the CData ODBC Driver is installed on a Remote server, the Analysis Service instance should be set to “Integrated workspace.”
To learn more on this issue please follow this Stackoverflow post:
Please reach out to [email protected] if this does not resolve the problem for you.
