Server name in Oracle enterprize stage

cnu · Post by **cnu** » Thu Jul 31, 2008 11:17 am

Hi:

I am using the Oracle enterprise stage tp read the daya from Oracle database.I am wondering where can give the server name in the stage.
In the properties tab there is DB Options and DB Options mode.
I am using the Userdefined SQL option.
In DB Option there is User and password only to enter.

Where can specify the database servername in the stage.Please give me advice.

Thanks in advance
Cnu

fmcmullan · Post by **fmcmullan** » Thu Jul 31, 2008 12:01 pm

On the "Properties" tab, click on the "Connection" folder icon. In the lower right of the dialog is the "Available properties to add" section. Click on the "Remote Server" property to add that to the connection options. The value you enter in the top right of the dialog is the database name you are trying to connect to.

cnu · Post by **cnu** » Thu Jul 31, 2008 12:46 pm

Hi Thanks !!
Added the Server and specify the user name and passowrd also as user=user,password=password.It fail to connect when i click on View Data button.
But i am able to connect to the database by using same.
Is that way of passing user and password is correct.Please advice me.

Thanks
cnu

jseclen · Post by **jseclen** » Thu Jul 31, 2008 3:38 pm

Hi cnu

In this case you must type the full that appear in the tnsnames.ora, for example

my.database.ora.com
{
etc
etc
}

when you define the property: Remote Server = my.database.ora.com

I hope this help

keshav0307 · Post by **keshav0307** » Thu Jul 31, 2008 8:35 pm

It fail to connect when i click on View Data button

what is the error?

cnu · Post by **cnu** » Fri Aug 01, 2008 3:18 pm

Hi:
the error is select privileges.
I will work with DBA on that.

Thanks
cnu

cnu · Post by **cnu** » Fri Aug 01, 2008 3:21 pm

Hi:
the error is select privileges.
I will work with DBA on that.

Thanks
cnu

DSXchange