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

    Encountered Ora 01017 after creating Oracle to sql server link.


      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





      Please help me on this issue.