Interactive reporting web client - workspace 11
O.M.MMar 18 2013 — edited Mar 19 2013we are running Hyperion interactive reporting 11.1
we are trying to execute bqy through workspace interactive reporting web client to retrieve data from MS sqlserver database.
we have define/configure the below :
1. ODBC connection & test was successfully
2. define MS sqlserver database host name in local host file
3. execute bqy report on desktop & it was processed successfully
4. configure same ODBC parameters and names in DAS (Interactive Reporting Data access service)
when we try to process the same bqy using interactive reporting web client we receive the below error
Server error[1003]: Failed to acquire access to database
SQL API: [SQLconnectW], SQL RETURN: [-1], SQL STATE: [IM002],
SQL NATIVE ERROR: [0], SQL MESSAGE: [[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified]
Please help!