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?
How is this a mistake?! Most corporations use centralized places like the TNSNAMES in order to prevent manual scribbling of hard-coded connectivity information in a hundred redundant places. If you've got hostname / port / service changes you will need to update every single fixed OCI reference.
what I am referring to is the post above which says the following
If you have Oracle client installed why you need DSN?!!!
just use hostname:port/Service at connection pool by selecting OCI
before that using command use tnsping <tnsname> that should return tnsentry if not check setting