Analytics Software

Hello,

I installed a 11g datawarehouse oracle DB and installed OBIEE (11g)

I'm able to connect to sqlplus, sqldeveloper, Toad to the 11g datawarehouse DB.

I'm able to ping to this database as well.

defined an microsoft ODBC connection with DW ( connection test passed )

- I opened the BI rpd in offline mode and opened the folder in physical layer
- modified the connection pool "Connection Pool" to use Default (OCI 10g/11g)
- modified the data source name (DSN) to ORCL ( DSN name in ODBC, the TEST connection of which works perfectly )
- modified the user name and password ( same as in DSN for ODBC )
- tried to update row count for the fact D1_ORDERS2

the error: unable to connect database using connection pool "Connection Pool".

I looked at the NQSAdminTool.log. I find "TNS:could not resolve the connect identifier specified
at OCI call OCIServerAttach" which is surprising.

any ideas on what could be the issue?

Edited by: 882460 on Aug 30, 2011 12:07 PM