Re: auto logins using sqlnet V2 and oracle 7.0

In article: <3mb08m$q2o_at_gabriel.keele.ac.uk> brenda_at_cs.keele.ac.uk (Brenda Banks) writes:
>
> I want to use auto logins (ops$ accounts) using oracle 7.0 and sqlnet V2 on
 sun sparc stations running OS 4.1.3
> I had no problem with oracle 6 and sqlnet 1
> but when using net 2, we always have to state the service name of our
 database along with the username and password
> How do I set a default service name (as given in /etc/tnsnames.ora) so that
 the auto login will work
>

Brenda,

        Use the environment variable TWO_TASK on Unix, set to the tnsnames.ora alias for the connection string. For example, if tnsnames.ora has an alias ...

        MYDB = (DESCRIPTION = (ADDRESS = (etc...

then, in Unix...

        TWO_TASK=MYDB; export TWO_TASK;

(With V6 and net V1 it would have been TWO_TASK=t:mybox:MYDB)

Hope this helps

-- 
---------------------------------------------------------------------------
| Keith Bremer    EMail kbremer_at_lecky.demon.co.uk                         |
---------------------------------------------------------------------------