Error executing View Data command - Oracle Enterprise Stage

rasi · Post by **rasi** » Sun Feb 19, 2006 9:58 pm

Is this the first time you are trying to connect to Oralce?....

ksfun · Post by **ksfun** » Sun Feb 19, 2006 10:11 pm

Yes. It is the first time connect to oracle.

rasi · Post by **rasi** » Sun Feb 19, 2006 10:20 pm

Hi

First you need to configure your environment in order to connect. You need have entry in dsenv defining ORACLE_HOME,ORAHOME,ORACLE_SID
Have PATH, LIBPATH assigned for Oracle.

ksfun · Post by **ksfun** » Sun Feb 19, 2006 10:28 pm

I am using window 2000 server environment, what is the configuration path I need to have entry in dsenv? Can you please show the example?

thanks rasi.

lstsaur · Post by **lstsaur** » Sun Feb 19, 2006 11:19 pm

Hi Ksfun,
You should use the service_name of the DB in your tnsnames.ora file to populate the Remote Server field under the Connection of the Properties tab.

ksfun · Post by **ksfun** » Mon Feb 20, 2006 12:06 am

Thanks lstsaur again! I am able to view the data from Oracle Enterprise Stage based on your advice.

Thank you very much!