Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

default connect to a database

default connect to a database

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 !
7 REPLIES
Tom Geudens
Honored Contributor

Re: default connect to a database

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
A life ? Cool ! Where can I download one of those from ?
T G Manikandan
Honored Contributor

Re: default connect to a database

I did not understand,Please explain.
Yogeeraj_1
Honored Contributor

Re: default connect to a database

hi,

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


hope this helps!

regards
Yogeeraj

No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)

Re: default connect to a database

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
Honored Contributor

Re: default connect to a database

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
Honored Contributor

Re: default connect to a database

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
Honored Contributor

Re: default connect to a database

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
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)