Hi thomas,

Is it possible to connect remote database without giving service name.

i tried by setting TOW_TASK environment variable. i am able to connect any remote database from Unix client, if i
-set TWO_TASK environment and
-not giving the service name while entering username and password

but i am *not* able to do the same in windows-NT.


Here is an example.

First Instance, NTORCL, on windows-NT
Second Instance, UNORAC, on Sun-solarais

1. Login into unix client
2. add entry in tnsnames.ora, to the instance NTORCL
3. set TWO_TASK environment variable(assign the NTORCL service name)
4. sqlplus username/password

works fine...

now...
1. Login into windows client
2. add entry in tnsnames.ora, to the instance UNORAC
3. set TWO_TASK environment variable(assign the UNORAC service name)
4. sqlplus username/password
gives invalid username/password...

but it works if i give 'sqlplus username/password@service_name'

am i doing anything wrong or is it not possible.

please advice me.

thanks.

senthil.