Re: ODBC and OPS$ accounts (sorry if repost)

From: Richard D Holowczak <holowcza_at_andromeda.rutgers.edu>
Date: 20 May 94 14:15:03 GMT
Message-ID: <May.20.10.15.03.1994.29761_at_andromeda.rutgers.edu>

anewson_at_cix.compulink.co.uk ("Alastair Newson") writes:

>Hi,
 

>If you want to use ops$ accounts over ODBC you'll need to type the full
>account name and use a password. When the windows session connects up to

  What is my Oracle password if I set up my accounts (in Oracle 7 on   Netware) as

     CREATE USER OPS$HOLOWCZAK IDENTIFIED EXTERNALLY;    With Oracle tools (SQL*Plus or SQL*Forms for example) the check is    made against the Netware bindary when either no Username/Password    is given or if the '/' character is given.

   In any case, several people suggested using a '/' for both Username    and for Password. This way, ODBC is happy because you have typed    something in for both fields. Then Oracle must somehow resolve    the '//' it gets into a single '/' as in the above case.

   This trick seems to work with most tools save the tricky    process control software I'm trying to get this to work with.    My solution for the present has been to create the primary user's    account "normally" with a username and password. This seems to be    OK for now because e does not use other tools at present.

Thanks again for all who responded.

Rich Holowczak                       holowcza_at_andromeda.rutgers.edu

Rutgers University
Ph.D. Computers and Information Systems Program

+---------------------------------------------------+---------------+
|  For best results, squeeze .sig from the bottom   | Ask about the |
|           and flatten as you go up.               | car alarm FAQ |
 +---------------------------------------------------+---------------+

Received on Fri May 20 1994 - 16:15:03 CEST