Re: ODBC and OPS$ accounts (sorry if repost)
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.eduRutgers 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