topic Re: default connect to a database in Operating System - HP-UX

default connect to a database

Philippe Vervoort — Fri, 19 Sep 2003 07:01:40 GMT

I have Oracle 9i in which I created 2 databases, prd and dev. I use the OPS$
technique to transparantly login to the database. Despite this, users allways
have to type in their userid, password and databasename. Is it possible to
define a 'default' database, so that an extra login is not needed anymore ?
Before I had Oracle 8.6 with only 1 database, and there, users who were
authenticated by the operating system, didn't need to login anymore !

Re: default connect to a database

Tom Geudens — Fri, 19 Sep 2003 07:10:09 GMT

Hi,
Could this be an environment issue ? If you make sure the databaseSID (+ database-environment) is set in the users profile, the logon should still work.

Regards,
Tom Geudens

Re: default connect to a database

T G Manikandan — Fri, 19 Sep 2003 07:53:03 GMT

I did not understand,Please explain.

Re: default connect to a database

Yogeeraj_1 — Fri, 19 Sep 2003 09:54:21 GMT

hi,

try setting environment variables:
TWO_TASK (connect string from TNSNAMES.ORA), ORACLE_SID,
and CONNECT_STRING

hope this helps!

regards
Yogeeraj

Re: default connect to a database

Philippe Vervoort — Fri, 19 Sep 2003 11:29:41 GMT

Sorry, I had to tell the whole story.
When we make an MS Access application in Windows, and want to query data in our Oracle 9i database (via an external link, defined in ODBC), Access allways shows a dialog-window, in which the user must give his id, password and databasename.
This wasn't the case when we connected to our 8.6 database.

Re: default connect to a database

Brian Crabtree — Mon, 22 Sep 2003 20:27:22 GMT

Did you use the same OPS$ name on the two databases as you did on the original?

Is the oracle software installed under the same UX userid as the 8i userid?

Thanks,

Brian

Re: default connect to a database

T G Manikandan — Mon, 22 Sep 2003 22:34:15 GMT

For that you need to edit your registry
where you can provide the password for that DSN so that it does not prompt for the password again and again.

In the meanwhile where did you get the crown?

Re: default connect to a database

Yogeeraj_1 — Mon, 22 Sep 2003 23:52:29 GMT

hi,

are you using the 9i drivers?

also check:
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76960/hs_genco.htm#173

regards
Yogeeraj