Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Using System DSN Credentials in OBIEE 10g

Ashish GuptaSep 8 2011 — edited Sep 9 2011

Hi Gurus/Experts

This is what i read in one of the blogs... that If the Shared Logon option is not selected, connections through the connection pool use the database user ID and password specified in the DSN
http://oracle-bi.siebelunleashed.com/articles/more-on-connection-pools/

Thought of giving it a try..
so created a System DSN
In Connection Pool, Disabled the shared logon and chose the ODBC 3.5 and gave the DSN name from the dropdown.
Now i am getting the below error in the Physical layer itself while viewing data...

A general error has occurred. [nQSError: 16001] ODBC error state: 28000 code: 1017 message: [Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied.

My Question

Can we really use the credentials from the System DSN , if the Shared Logon is unchecked?

Note: The DSN is working fine when i test it...

Thanks
Ashish

This post has been answered by Deepak Gupta on Sep 8 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 7 2011

Added on Sep 8 2011

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

8 comments

734 views