0 Replies Latest reply on Nov 18, 2015 8:13 AM by user9198027

    Encountered Ora 01017 after creating Oracle to sql server link.

    user9198027

      I am trying to create Oracle to sql server link using dg4odbc.

      After creating the link i got following error

       

      SQL> select * from dbo.account@CRMLINK ;

      select * from dbo.account@CRMLINK

                                *

      ERROR at line 1:

      ORA-01017: invalid username/password; logon denied

      [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user

      'PLHO\LDDBTESTSER$'. {28000,NativeErr = 18456}

      ORA-02063: preceding 2 lines from CRMLINK

       

       

      SQL>

       

      Please help me on this issue.