This content has been marked as final. Show 6 replies
I created a DSN A and added the name to my connection pool in OBIEE 10G rpd. When i click on "Test Connection" in the DSN, it connects successfully. However, when i create an ad-hoc report in Answers with a subject area that uses the same connection pool, i get the no listener error:
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 16001] ODBC error state: S1000 code: 12541 message: [Oracle][ODBC][Ora]ORA-12541: TNS:no listener. (HY000)
What am i doing wrong?