default connect to a database

[Philippe Vervoort]

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 !

[Tom Geudens]

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

[T G Manikandan]

I did not understand,Please explain.

[Yogeeraj_1]

hi,

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


hope this helps!

regards
Yogeeraj

[Philippe Vervoort]

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.

[Brian Crabtree]

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

[T G Manikandan]

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?

[Yogeeraj_1]

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