Learn how easy it is to sync an existing GitHub or Google Code repo to a SourceForge project! See Demo

Close

#3 NT Authentication with Oracle returns error

closed
Bengt Gunne
None
5
2005-07-04
2005-07-04
Sean Flook
No

I am trying to use NT Authentication with Oracle. I have
Oracel setup to use NT Authentication and it works fine
with SQLPlus. The problem is that when trying to use
mimer I get the following message:

ORA-1017:invalid username/password; logon denied

Discussion

  • Bengt Gunne
    Bengt Gunne
    2005-07-04

    Logged In: YES
    user_id=895705

    What connection string are you using with your
    MpmConnection?

    Check also what connection string is passed to the
    underlying OracleConnection. Use NativeConnection property
    of the MpmConnection object.

     
  • Sean Flook
    Sean Flook
    2005-07-04

    Logged In: YES
    user_id=684148

    I am getting this error from within the Admin application.

    These are the settings I am using
    Data Source Name = TEST
    Plugin name = Oracle9
    SQL Filter List = ParametersMarkers
    DBMS type name = Oracle
    DataSource = SYMPHONY_HOLLY

    I am not providing any user name or password. As previously
    stated if I type the following from a command prompt I can
    logon to Oracle

    sqlplus /@symphony_holly

    Regards
    Sean

     
  • Bengt Gunne
    Bengt Gunne
    2005-07-04

    Logged In: YES
    user_id=895705

    The question is how you connect with Oracle's ADO.NET
    provider without supplying a username/password. In other
    providers, such as Mimer SQL and SQL Server, there is an
    IntegratedSecurity option that is used to tell the system to
    use NT Authentication. Oracle does not provide this option.
    The Mimer Provider Manager expose all options supported by
    the Oracle provider so as long as it is supported by the
    Oracle Data Provider you should be able to do it through
    Mpm too!

     
  • Bengt Gunne
    Bengt Gunne
    2005-07-04

    Logged In: YES
    user_id=895705

    Try setting User Id to /

     
  • Sean Flook
    Sean Flook
    2005-07-04

    Logged In: YES
    user_id=684148

    That works great!

    Thanks a lot.

    Sean

     
  • Bengt Gunne
    Bengt Gunne
    2005-07-04

    • assigned_to: nobody --> mimerbg
    • status: open --> closed