The setup of Mariner and Microsoft SQL Reporting Services (SRS) requires that both servers can initiate communication with each other. Mariner makes a call to the SRS server which in turn makes calls to the database via a data source that is setup in SRS. All calls to the Mariner database are processed through the Mariner Web application server.
Failed to connect to data source < name >... <error> ChangeMan DS is unable to connect to the data source . The ODBC driver lists why the connection failed.
Failed to connect to the Dimensions Server! ... DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ... DBC-IM002:0-[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified Error: Unable to connect to database "DMSYS" ... Clicking on OK from the error dialog then presents the connection dialog, and the user is able to connect successfully.
... find out the name of the driver ... ... depending on what data source you are using ... Find the data source and check the name of the driver listed for it. Next click the Drivers tab and find the driver that was listed for the data source . You will find the name of the ODBC driver dll on that line. Now run the command "walkdlls {driver dll}" and it will try to load the specified dll file and will report on any dlls that it failed to load.
