Despite not reading documentation ahead of time (much), there is a method to my madness. I learn best by breaking stuff...multiple times.
So, there I am, fresh from exporting from Discoverer then migrating that RPD from 10g to 11g...configuring the Connection Pools. I select a random table and then hit View Data.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhRC3M3dzjxGL0vDdcnIJQHTTA8H5uYN_Z0ERzXx7Uf-nVnywI4qyBHljQ6hO_uF_6rcv9k4KOCi0c1WBtxB4fjrpcEnSJCPNHad4200OUKX3juOQIrFfQrEah1XMvii86PFdvUXjEmXX6G/s800/02_connection_failed.png)
Awesome. Very descriptive.
I tried using the BI ODBC Client tool to test the connection.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh3Zhzg0gtXqKxtZn-CR_W1ALknTIKBSewbKW3TRi-6-_isGSnvelkzFMKfJ8DZlKINZfThr9VwQHFzUHU7RulZn1iFCH_rXKAMhU4DRQ2s2ZkhD90psb-5OB5vpURhUQgwHGDFIu0DMwE0/s800/05_obiee_odbc_error.png)
Awesomer.
Using the Google Machine, I found this reference to Visual Basic (is that really still used?).
Let's try looking something else up (like the documentation you say?). Actually, I didn't find it, a colleague did.
Over on the Siebel Essentials blog, tip #4 for OBIEE 11g, Connections.
To sum it up, you can either use the tns entry as the Data Source Name or you must put a tnsnames.ora file in the <ORACLE_HOME>\OracleBI1\network\admin folder.
Awesomest.
2 comments:
It did help me to figure out where the tnsnames is hosted in obiee. Thanks and Keep blogging :)
Dude, you look like anything BUT a nerd.
Keep on spreading some o' that 11g love.
Post a Comment